-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
The real question is what version of MySQL are you running? 4.x or 5.x?
Simon wrote:
> 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
> _______________________________________________
> Dbmail mailing list
> Dbmail@xxxxxxxxxx
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (MingW32)
iD8DBQFDJQNsUQ+xExmY+AsRAhSIAJ9K3+THX3aKUDI5AVzF21EhuJwUcwCgmN2j
EaayXN+W+QtMfMkLyhJx1bU=
=HXYG
-----END PGP SIGNATURE-----
|
