[TYPO3-english] big cachingframework tables

Katja Lampela katja.lampela at lieska.net
Wed Jan 11 15:44:29 CET 2012


Hi,

11.1.2012 11:29, Dmitry Dulepov kirjoitti:
> Just published yeaterday:
> http://www.dmitry-dulepov.com/2012/01/cleaning-and-optimising-cache-tables-in.html
>

There is one thing I don't quite understand in this:
-- quote start

If you do not want to delete the content, you can:
use ALTER TABLE to change table engine type from InnoDB to MySAIM
use ALTER TABLE to change table engine type back to InnoDB
repeat the previous step once more to ensure that table is sorted by primary key (do not skip this!)

-- quote end

To what does this last point refer "repeat the previous step..."?
To the last step? so the whole thing would be:

use ALTER TABLE to change table engine type from InnoDB to MySAIM
use ALTER TABLE to change table engine type back to InnoDB
use ALTER TABLE to change table engine type back to InnoDB

Do I understand right?

-- 
With kind regards

Katja Lampela
*Lieska-tuotanto*
www.lieska.net



More information about the TYPO3-english mailing list