mysqloptimize against an innodb table will not reclaim disk space. if anything, you're innodb file will grow. In fact it can end up twice as large as when you started. its one of the drawbacks of innodb tables. if you want to reclaim diskspace change the table type to myisam, then run mysqloptimize against the innodb table then alter the table back to innodb. Curtis Andrea Brancatelli wrote: > I strongly suggest you to use the innodb_file_per_table and to run an > optimize table dbmail_messages (and not only, also the others) from time > to > time to free some disk space. > > ciaociao > > -----Messaggio originale----- > Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Per conto > di Sascha Braun > Inviato: martedì 31 luglio 2007 15.10 > A: DBMail mailinglist > Oggetto: Re: [Dbmail] Table dbmail_messages is full > > Is that the value you where asking for? > > innodb_data_file_path = ibdata1:10M:autoextend:max:128M > > I am now changing the max value, I hope i recognized everything > correctly. > > Best Regards, > > Sascha Braun > > Am Dienstag, den 31.07.2007, 16:30 +0400 schrieb alexander benaguev: >> give us "my.cnf", please >> >> alexander >> _______________________________________________ >> DBmail mailing list >> DBmail@dbmail.org >> https://mailman.fastxs.nl/mailman/listinfo/dbmail > > _______________________________________________ > DBmail mailing list > DBmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > _______________________________________________ > DBmail mailing list > DBmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail > -- Curtis Maurand Head Honcho Xyonet Hosting Services Biddeford, ME 04005 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
_______________________________________________ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
