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

andre mcsparkerton at yahoo.co.uk
Fri Dec 30 22:53:02 UTC 2005

Just cross posting this to documentation list.

Indeed this would be a good page.  If someone would care to create the 
entire SQL script required to make duplicate Innodb tables - and the 
corresponding INSERT INTO ... SELECT * FROM queries, I would be happy to 
put it in the snippets page (and/or elsewhere).

I would do this myself - but I think this requires an expert's hand 
(i.e. someone that has a actually done the conversion themselves).

puregin wrote:
> 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
>> 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.

To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre. http://uk.security.yahoo.com

More information about the development mailing list