Page 1 of 1

The capacity is increases continuously

Posted: Tue Aug 25, 2009 10:18 am
by supermail
I have used openemm for few months; at first the harddisk was used about 1.X G. Now it was used over 7X G. I uploaded about 100,000 email contact to the system. I tried to delete the log files. How to reduce the size? My system will be overloaded soon.

Thanks. :(

Posted: Tue Aug 25, 2009 11:04 am
by maschoff
Have you deleted the bounce table from time to time (see Install Guide)?

Additionally, you can stop OpenEMM and delete all tables beginning with TMP (see thread http://www.openemm.org/forums/viewtopic ... +temporary).

This bug will be fixed with release 6.

Posted: Tue Aug 25, 2009 2:37 pm
by supermail
Thanks

Posted: Thu Aug 27, 2009 3:48 am
by supermail
What I have tried yesterday?
I have set "deleteBounce.cronExpression=0 0 3 * * ? " and delete all tables beginning with TMP. I go to check today, the system capacity is still over 80 G. So I go to check the database, find the table is called "bounce_tbl". The data_length is 1435183842. It uses for storing error msg. How I can clean up this table?

| admin_tbl | MyISAM | 10 | Dynamic | 1 | 88 | 88 | 281474976710655 | 3072 | 0 | 2 | 2009-04-18 05:43:48 | 2009-05-25 08:55:38 | NULL | utf8_unicode_ci | NULL | | |
| bounce_collect_tbl | MyISAM | 10 | Fixed | 0 | 0 | 0 | 7036874417766399 | 1024 | 0 | 1 | 2009-04-18 05:43:49 | 2009-04-18 05:43:49 | NULL | utf8_unicode_ci | NULL | | |
| bounce_tbl | MyISAM | 10 | Fixed | 9065563 | 29 | 1435183842 | 8162774324609023 | 507875328 | 1172282515 | 52619943 | 2009-04-18 05:43:49 | 2009-08-21 08:21:35 | NULL | utf8_unicode_ci | NULL | | |
| campaign_tbl | MyISAM | 10 | Dynamic | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 1 | 2009-04-18 05:43:49 | 2009-04-18 05:43:49 | NULL |
ma wrote:Have you deleted the bounce table from time to time (see Install Guide)?

Additionally, you can stop OpenEMM and delete all tables beginning with TMP (see thread http://www.openemm.org/forums/viewtopic ... +temporary).

This bug will be fixed with release 6.

Posted: Thu Aug 27, 2009 7:29 am
by maschoff
Just truncate the table.