innodb

Convert All Tables to InnoDB

2 minute read

Some time ago I was in the situation where I was looking at 200 MyISAM tables screaming to get converted to InnoDB for performance reasons. You probably know...

Improve MySQL Insert Performance

11 minute read

Sometimes MySQL needs to work hard. I've been working on an import script that fires a lot of INSERTs. Normally our database server handles 1,000 inserts / s...