[development] Counterintuitive but true: Caching makes a
high-traffic site slower
puregin at puregin.org
Fri Dec 30 17:19:05 UTC 2005
This might be a good "SQL snippet":
> See here:
> "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.
More information about the development