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

[andre]

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

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


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