We are running dbmail on a dual 2.8 xeon with 2GB of ram on debian
sarge. Amavis and Postfix also share mysql for configuration settings.
We have been getting issues with mysql having to many concurrent
connections. I know that this is really a mysql configuration option..
but im guessing that dbmail users have come up with this problem before?
And if so, could offer some insight for me? (Thanks!)
These are my current mysql cfg options... Have a got them correct?
[mysqld_safe]
set-variable=max_connections=500
set-variable=wait_timeout=300
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-external-locking
old-passwords = 1
key_buffer = 256M
max_allowed_packet = 16M
thread_stack = 128K
thread_cache = 8
table_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64MB
thread_concurrency = 4
query_cache_limit = 1048576
query_cache_size = 16M
query_cache_type = 1
skip-innodb
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql]
[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
