Thanks.
The capacity is increases continuously
Moderator: moderator
The capacity is increases continuously
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.
Thanks.
-
maschoff
- Site Admin
- Posts: 2628
- Joined: Thu Aug 03, 2006 10:20 am
- Location: Munich, Germany
- Contact:
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.
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.
OpenEMM Maintainer
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 |
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.