Oops my bad should have read the previous emails Move your set-variable=max_connections=500 in to the [mysqld] section of your my.ini.
S -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Simon Sent: 11 September 2005 22:00 To: DBMail mailinglist Subject: [Dbmail] MySQL Connections 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
