I have inherited a WP site (with WP5.1 and WooCommerce 2.6.14, LearnDash 2.5.4 and few other smaller plugins). From screenshot you can see that it is a mix and match of MyISAM and InnoDB tables. We are experiencing table locking related problems (which essentially slow site down and result in 503 errors). Even on such … Read more
Is there a measurable performance difference between using INT vs. VARCHAR as a primary key in MySQL? I’d like to use VARCHAR as the primary key for reference lists (think US States, Country Codes) and a coworker won’t budge on the INT AUTO_INCREMENT as a primary key for all tables. My argument, as detailed here, … Read more
I found a superb post here about optimising WordPress for large installs. One of the steps refers to lighthttpd which sounds excellent but isn’t currently supported by DirectAdmin. Last time I messed about with a non-DA installation I managed to break my server and had to pay a professional to get it fixed… One of … Read more
I have a 2GB WordPress database (using InnoDB Storage Engine) and I noticed my site loads slow when I press the publish button right after I selected a featured image in the media library. I had a look at my tables and noticed wp_postmeta is the biggest table and wp_posts the 2nd biggest out of … Read more
This question already has answers here: MyISAM versus InnoDB [closed] (25 answers) Closed 9 years ago. I understand that this question has been asked before, but most of the time it is asked in relation to a specific database or table. I cannot find an answer on this site that describes the two engines and … Read more
In my production error logs I occasionally see: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction I know which query is trying to access the database at that moment but is there a way to find out which query had the lock at that precise moment? 11 Answers 11
I know I can issue an alter table individually to change the table storage from MyISAM to InnoDB. I am wondering if there is a way to quickly change all of them to InnoDB? 30 Answers 30
I converted all my tables to InnoDB, but the MySQL server (which I can’t access, as I’m on shared hosting) has MyISAM as the default, so every new table that WordPress creates (e.g. when I add a new site on my multisite) uses the MyISAM engine and I have to alter it manually. Can I … Read more
My MySQL database contains several tables using different storage engines (specifically myisam and innodb). How can I find out which tables are using which engine? 14 Answers 14
Our team is working on the 3rd of large WP sites for a client, and contrary to most “typical” WordPress setups, our projects are generally experience lots of requests, data pulls, and general content – if you saw (and could see) our site, you would be hard [word]pressed to know it was even a WP … Read more
