Re: [development] Counterintuitive but true: Caching makes a high-traffic site slower

This might be a good "SQL snippet": http://drupal.org/node/41586 Cheers, Djun

See here: http://dev.mysql.com/doc/refman/4.1/en/converting-tables-to- innodb.html

"The fastest way to alter a table to InnoDB is to do the inserts directly to an InnoDB table. That is, use ALTER TABLE ... TYPE=INNODB, or create an empty InnoDB table with identical definitions and insert the rows with INSERT INTO ... SELECT * FROM ...."

Seems a script with show tables, then alter table does the trick.

InnoDB involves creating a table space a la Oracle though, so there is more preparatory work that has to be done.