Re: Innodb optimzation

2005-05-31 Thread mfatene
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

Innodb optimzation

2005-05-30 Thread stefano
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