Installation

MySQL 5.5: MyISAM vs. INNODB

MySQL 5.5: MyISAM vs. INNODB

by Danny Glin -
Number of replies: 0
The current recommendation for WeBWorK installations using MySQL 5.5 or later is to change the default table type to MyISAM for performance reasons.

I came across some information online regarding optimizing MySQL for InnoDB tables (here is one article).  The recommendation when using InnoDB is to set innodb_buffer_pool_size to a value larger than the total size of all of your InnoDB tables (subject to available RAM).

My production server is still running MySQL 5.1 with MyISAM tables, so I haven't had the occasion to test this on a large install.  Is anyone able to fool around with this and see if it solves the InnoDB slow-down in recent versions of MySQL?

Danny