Hi stephano,
Just read the last comment at this link
http://dev.mysql.com/doc/mysql/en/optimize-table.html
and you will have positive answers to your questions.
Mathias
Selon [EMAIL PROTECTED]:
> Hi all,
>
> I have an Innodb database (MySQL 4.0.21 on Linux). The db is made of 11
> tables. 10 of
Hi all,
I have an Innodb database (MySQL 4.0.21 on Linux). The db is made of 11 tables.
10 of these tables are just a few MBs altogether, while the 11th table, due to
a longtext field where binary data is stored, is about 3GBs and counting (about
80MBs inserted everyday).
Since Innodb doesn't