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

[puregin]

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.