Hi everyone, I imagine this subject must have been discussed and rediscussed here but as things are always changing due to new releases and increase of spam I am going bring this up again to try to get some help.
I have been running dspam for sometime on one of my servers and started to experience slowness on the message delivery. When I listed the processes running on my server I saw hundreds of dspam processes. I was also experiencing slowness to login to the server via pop3 (which uses the same mysql server) and sometimes the password changing process was failing. Then I figured that it was a problem with the database, indeed the db had grown and become slower. Plus, the number of connections was too high and was overwhelming the mysql server and anything that needed to talk to it would be unable to since the server was busy. The db is not even that big it is only about 2Gb of which the token data and index take up about 80%. For some reason I am also having problems to run the purge-4.1.sql, it seems to run but never finishes. I have run the queries manually and they start and never come back, I even left it for 24 hours and no luck. It is also important to point out that the mysql server doesn't even bother the CPU much when I run the purge queries. I suppose people here must have some pretty large dspam databases and I wondered if anyone could give me some tips on how to put my mysql to work properly with dspam. I ended up having to take dspam down since it was compromising the whole server's performance due to the db issue. My MySQL is 4.1.22 running FreeBSD 6.1 and my dspam is 3.6.8, the server's hardware is pretty good with 1Gb of RAM. Below is my my.cnf. It was sort of made by cutting and pasting from the web and with try and error since I am not very knowledgeable in mysql. Any light shed on this will be much appreciated! Thanks Vini [mysqld] max_allowed_packet=8192000 # MySQL 4.x has query caching available. # Enable it for vast improvement and it may be all you need to tweak. query_cache_type=1 query_cache_limit=1M query_cache_size=32M max_connections=200 #interactive_timeout=180 interactive_timeout=100 wait_timeout=15 connect_timeout=10 table_cache=512 # Reduced it by checking current size of *.MYI files, see notes below. key_buffer=128M thread_concurrency=2 # log slow queries is a must. Many queries that take more than 2 seconds. # If so, then your tables need enhancement. log_slow_queries=/var/log/mysqld.slow.log long_query_time=2 [isamchk] key_buffer=64M sort_buffer=64M read_buffer=16M write_buffer=16M [myisamchk] key_buffer=64M sort_buffer=64M read_buffer=16M write_buffer=16M
