Paul J Stevens wrote:
>
>
>
> k...@ropnet.ru wrote:
>> -rw-rw 1 mysql4 mysql4 23995613184 Oct 20 11:47
>> dbmail_messageblks.ibd
>
> he! are those innodb table spaces? Been reading about them, but haven't
> used them yet..
>
>> Table "dbmail_messageblks" has almost 24Gb size (we have
On Sun, 2009-12-13 at 20:14 -0800, Daniel Mejia wrote:
> 1. Is the dbmail_messageblks table cant be optimized?
It can be optimized, but there's probably no good reason to do it. I did
it once and it didn't increase the database speed it just took a long
time to do it.
> 2. What would u suggest t
Josh Marshall-2 wrote:
>
>
>> 1. Is the dbmail_messageblks table cant be optimized?
>
> It can be optimized, but there's probably no good reason to do it. I did
> it once and it didn't increase the database speed it just took a long
> time to do it.
>
>
Would the optimization retrieve some
> Would the optimization retrieve some space? ie: reducing the table
> size?
It only recovers empty space and re-orders (like a defrag). If your
usage is increasing, the best way is to remove emails. Maybe you need to
run a dbmail-util to remove the deleted emails (there might be a SQL you
can run
Daniel Mejia wrote:
> Josh Marshall-2 wrote:
>
>>
>>> 1. Is the dbmail_messageblks table cant be optimized?
>>>
>> It can be optimized, but there's probably no good reason to do it. I did
>> it once and it didn't increase the database speed it just took a long
>> time to do it.
>>
>>
Josh Marshall-2 wrote:
>
> It only recovers empty space and re-orders (like a defrag). If your
> usage is increasing, the best way is to remove emails. Maybe you need to
> run a dbmail-util to remove the deleted emails (there might be a SQL you
> can run manually)
>
i did a cronjob to take car
Daniel Mejia wrote:
Josh Marshall-2 wrote:
It only recovers empty space and re-orders (like a defrag). If your
usage is increasing, the best way is to remove emails. Maybe you need to
run a dbmail-util to remove the deleted emails (there might be a SQL you
can run manually)
i did a cr