MySQL InnoDB performance improvement: InnoDB buffer pool instances – Updated!

Your MySQL Database at Warp Speed - img. credits: Christian Daryanto Limas @ flickr
Your MySQL Database at Warp Speed

Are you running into MySQL load problems? Learn how how I tuned my MySQL servers for a heavy InnoDB workload, by configuring innodb_buffer_pool_instances. Dividing the InnoDB Buffer Pool into multiple instances improves Disk I/O. By doing so, you run your database and website more efficiently and faster. Here is a little help for you.

Continue reading “MySQL InnoDB performance improvement: InnoDB buffer pool instances – Updated!”

Convert MySQL MyISAM tables to InnoDB

In the earlier days of MySQL, the default storage engine for your database was MyISAM. This is also why you still encounter a lot of examples with engine=MyISAM online. Nowadays, the default storage engine is InnoDB, and MyISAM is no longer actively developed. Therefore, all MySQL performance optimizations are for InnoDB, and it’s recommended to switch to this as your table storage engine.

Continue reading “Convert MySQL MyISAM tables to InnoDB”

Check, repair and optimize MySQL tables with mysqlcheck

How to use mysqlcheck when your MySQL table gets corrupted. MySQL’s mysqlcheck is a command line table maintenance program: it checks, repairs, optimizes, or analyzes tables. Very handy for automated optimizations of MySQL databases and tables. In this post I’ll show you how to use mysqlcheck to optimize all MySQL tables using a cronjob.

Continue reading “Check, repair and optimize MySQL tables with mysqlcheck”