i would like to do some maintenance for my phplist, because now every campaign it took around 10hours for 80k and my server always crash. I just go through and read some threads in this forum but all is for old version(v2).
Below is my database table:

Full Image: http://i.imgur.com/8OqpMpJ.png
Almost 1GB
This server is using VPS and keep crash in this few days, i believe maybe because of my database. So which table should i delete or remove to make it smaller.
And below is my config setting:
- Code: Select all
<?php
define('PLUGIN_ROOTDIR','plugins');
define("PHPMAILERHOST",'');
define("TEST",0);
define("CHECK_SESSIONIP",0);
define("EXPORT_EXCEL", 1);
$bounce_protocol = 'pop';
define ("MANUALLY_PROCESS_BOUNCES",1);
define ("MANUALLY_PROCESS_QUEUE",1);
$bounce_mailbox_host = 'localhost';
$bounce_mailbox_user = 'popuser';
$bounce_mailbox_password = 'password';
$bounce_mailbox_port = "110/pop3/novalidate-cert";
$bounce_mailbox = '/var/mail/listbounces';
$bounce_mailbox_purge = 1;
$bounce_mailbox_purge_unprocessed = 1;
$bounce_unsubscribe_threshold = 5;
define("USEFCK",0);
define("UPLOADIMAGES_DIR","lists/uploadimages");
$bounce_mailbox_port = "110/pop3/novalidate-cert";
//previous setting
define("MAILQUEUE_BATCH_SIZE",300);
define("MAILQUEUE_BATCH_PERIOD",8);
define('MAILQUEUE_THROTTLE',0);
# Don't look like a spammer.
define('USE_DOMAIN_THROTTLE',0);
define('DOMAIN_AUTO_THROTTLE',0);
# Don't forget!
define("MAXLIST",20);
define ("TEST",0);
$commandline_users = array();
Any advice and suggestions will be greatly appreciated.
phplist version: v3.0.5