Articles of innodb

Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0

I’m transferring a bunch of domains a new host. The site names remain the same, and for the sites I’ve already migrated, no manipulation was necessary in the database. It just works once name-servers are pointed at the new box. That’s great. For some sites, however, during import, mysql throws this error: Operation not allowed […]

Large database causes slow load

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 […]

If I consider changing my WordPress DB tables to InnoDB, will it have an effect on the way WordPress works?

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 […]

Can I explicitly specify ENGINE=InnoDB in WordPress?

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 […]

Performance Gains of Relational DB Setup

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 […]

WordPress use innodb by default?

I just created a new WordPress site in my server. Normally, WordPress uses MyISAM as the database type. But this time, it created all InnoDB tables! Is this normal? Has WordPress switched to InnoDB in the latest versions?

Would switching to InnoDB from MyISAM improve performance of comments table?

A site I’ve built gets lots of comments in a short space of time – so perhaps 100 comments might be left in 5 or 10 minutes. This seems to cause a pretty heavy load on the database, especially when combined with recent comment widgets – I’ve seen server load rapidly spiral up to 40+, […]

WordPress Database Slow – should I switch to InnoDB?

I have a WordPress site with well over 10k posts, and things are starting to get very slow whenever I am adding and editing posts. Pages load nice and fast for users, along with the admin lists of posts, but it is when writes or updates occur the server goes to 100% CPU and takes […]