-----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@dbmail.org > 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-----
