The capacity is increases continuously

Use this forum for questions regarding adoption and functionality of OpenEMM

Moderator: moderator

supermail
Posts: 4
Joined: Tue Aug 25, 2009 10:10 am

The capacity is increases continuously

Post by supermail » Tue Aug 25, 2009 10:18 am

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. :(

maschoff
Site Admin
Posts: 2320
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Post by maschoff » Tue Aug 25, 2009 11:04 am

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.
OpenEMM Maintainer

supermail
Posts: 4
Joined: Tue Aug 25, 2009 10:10 am

Post by supermail » Tue Aug 25, 2009 2:37 pm

Thanks

supermail
Posts: 4
Joined: Tue Aug 25, 2009 10:10 am

Post by supermail » Thu Aug 27, 2009 3:48 am

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.

maschoff
Site Admin
Posts: 2320
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Post by maschoff » Thu Aug 27, 2009 7:29 am

Just truncate the table.
OpenEMM Maintainer

Post Reply