[development] Counterintuitive but true: Caching makes
a high-traffic site slower
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).
> 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
>> 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
More information about the development