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

puregin puregin at puregin.org
Fri Dec 30 17:19:05 UTC 2005

This might be a good "SQL snippet":


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
> 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.

More information about the development mailing list