Wednesday, November 21, 2012

optimizing phplist tables

Saw that our bounce processing on krishna was slow. Followed this advice, and did some table optimizing.

Optimize table for the bounce table, and optimize table for the user_user table. For this, logged on to mysql commandline client using the credentials mentioned at the phplist config file, and used the table names after listing them - we have custom table name prefixes.

mysql -u user -p (will ask for password)
mysql> show databases;
mysql> use my_database_name;
mysql> show tables;

 etc. as given here. Bounce table optimization took two and a half minutes, user_user table took 8 sec.

But still, the bounce processing takes a good half an hour or forty minutes. So, decreased the frequency of the bounce processing cron jobs, commented many of them out.

No comments:

Post a Comment