Jump to content

InnoDB + MyISAM -> InnoDB


Recommended Posts

Hi friends! And thanks for Processwire!

While supporting a 5-years-old Processwire project I found that there are both InnoDB and MyISAM tables there. Personally I think that InnoDB is better for Processwire. MyISAM tables came from some modules written years before. Since I like websites to be fast, I altered all MyISAM tables to InnoDB. At first glance, it was a good solution, website is running fast and smooth. Could there be caveats? Maybe I'm taking some implicit risks? I Would like to discuss this.

  • Like 1
Link to comment
Share on other sites

Hi @theoretic 

Without details about how "big" the database is, I do not see any risks to upgrade to InnoDB. You should read the introduction made by @teppo and the post written by @ryan 



A nice and short explanation by @clsource :  https://github.com/joyofpw/how-to-install-processwire#which-engine-is-better-myisam-or-innodb

And of course, ingesting the official mysql dev doc (choose the right version according to your setup):


You might need to adjust some buffer settings, to get a first insight of it, you could run mysql-tuner, it take seconds to install and run, in order to get an easy to read report (steps below).

### Install wget (mandatory)
apt-get update
apt-get install -y wget

### Download mysqltuner
wget http://mysqltuner.pl/ -O mysqltuner.pl
wget https://raw.githubusercontent.com/major/MySQLTuner-perl/master/basic_passwords.txt -O basic_passwords.txt
wget https://raw.githubusercontent.com/major/MySQLTuner-perl/master/vulnerabilities.csv -O vulnerabilities.csv

### Run MySQLTuner
chmod u+x mysqltuner.pl
./mysqltuner.pl --user $MYSQL_USER --pass $MYSQL_PASSWORD


  • Like 4
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...