[TYPO3-english] cache_pages.ibd

[Katja Lampela]

Hi,

14.11.2011 10:34, Dmitry Dulepov kirjoitti:
> "ibd" is innodb data file. InnoDB work so that it never reuses the space. When record is deleted, the space remains unoccupied in the file. When the new record is added, it is added to the end of the file.
>
> You can rebuild the file by executing the following command:
>
> ANALYZE TABLE cache_pages;
>
> That would rebuild the table into a new file. If that does not help (it does not, sometimes), you can also do:
>
> ALTER TABLE cache_pages ENGINE=MyISAM;
> ALTER TABLE cache_pages ENGINE=InnoDB;
>
> You can add that as a cron job and run at night.
>

Great, thank you Dmitry! I will try this.


-- 
With kind regards

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