List Info

Thread: R: Table dbmail_messages is full




R: Table dbmail_messages is full
country flaguser name
Italy
2007-07-31 08:18:58
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: dbmail-bouncesdbmail.org [mailto:dbmail-bouncesdbmail.org] 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
> DBmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Re: R: Table dbmail_messages is full
country flaguser name
United States
2007-07-31 08:29:26

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: dbmail-bouncesdbmail.org [mailto:dbmail-bouncesdbmail.org] 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
>> DBmaildbmail.org
>> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
> _______________________________________________
> DBmail mailing list
> DBmaildbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
> _______________________________________________
> DBmail mailing list
> DBmaildbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>


--
Curtis Maurand
Head Honcho
Xyonet Hosting Services
Biddeford, ME 04005
mailto:curtismaurand.com
mailto:cmaurandxyonet.com
[1-2]

about | contact  Other archives ( Real Estate discussion Medical topics )