PTSMail MYSQL Support Page

For additional help with MySQL including installation, setup, troubleshooting and more, contact us by email or phone: experts@expertsinunix.com or (410) 838 5100. We do offer support on a per incident basis for $199 per incident.

On this page you will find the details necessary to help tune mysql and keep mysql running well with PTSMail Utilities.

For large systems the default my.cnf file is not adequate 
for mysql performance with the PTSMail Utilities.  
We recommend the follwing:

If you have multiple mail servers run mysql on a server dedicated
to just mysql. If this is not possible run on the mail server receiving
the least amount of mail.

Modify your my.cnf to have the following:

[mysqld]
port            = 3306
socket          = /tmp/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 1200
sort_buffer_size = 2M
net_buffer_length = 8K
read_buffer_size = 2M
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 64M
tmp_table_size = 16M
max_connections = 1000
max_user_connections = 1000
max_connect_errors = 999999

Tune the above according your needs.  MYSQL likes lots of memory.  Make sure
your server has enough.

Don't let your tables grow excessively large.  You can use the cleanup
routines in ptsfilter.conf file to clear the tables of old entries.

tblEmailFilter~5~
tblmessage~5~
tblgreylist~5~
BlackList~5~

The above clear the named tables of any entries older than 5 days. 

if you need to repair a table you can do the following:

mysql -u root -h localhost  -p  
mysql> use ptsmail
mysql> repair table BlackList;
mysql> quit

Substitute the table you wish to repair.

or change directory to where your database is stored and run the following:


myisamchk -r tblEmailFilter



You can also user the repair table option in the ptsfilter.conf file to do
a repair on all tables.

For examples of sql statements look at our
Sample SQL Statements page.

For more information on MYSQL visit the Mysql web site

For more information about our software please contact us:
info@expertsinunix.com , or call our offices at 410-838-5100.