On Nov 26, 2007 4:41 PM, Earnie Boyd <earnie@users.sourceforge.net> wrote:
Quoting Khalid Baheyeldin <kb@2bits.com>:
- Add skip-innodb, which saves some 100MB of RAM for the MySQL.
Speaking of innodb; I've been testing with it as well. InnoDB can be slightly faster with selects that MyISAM and provides for row locking which you can't do with MyISAM.
With some pitfalls. When you do a SELECT COUNT(*) FROM ... it is very slow on InnoDB. MyISAM just consults the index and gets you the number instantly. On InnoDB, the index is co-resident with the data, not separate, hence it is slow. So, most of the queries in Drupal that need to know the number of rows and do SELECT COUNT(*) are slower. For example pager_query() stuff. Also, explicit table locking is gone in Drupal 6 (at least for core), so both MyISAM and InnoDB will (should?) benefit from that. -- Khalid M. Baheyeldin 2bits.com http://2bits.com Drupal optimization, development, customization and consulting.