Thanks but it doesn't work... Below is the extract of the configuration file it does not matter whether I include spaces around the "=" or not, starting using mysql_safe results in a "failed" There is no entry in the error log. Commenting out the line results in a successful restart. I am probably missing something basic but...
On 30 Oct 2001, Tonu Samuel wrote: > Date: 30 Oct 2001 21:21:32 +0200 > From: Tonu Samuel <[EMAIL PROTECTED]> > To: "William R. Mussatto" <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Subject: Re: Can't set max_connections on debian version > > On Tue, 2001-10-30 at 20:53, William R. Mussatto wrote: > > I realize this is not the current version, but debian stable is stuck on: > > 3.22.32. > > > > mysqld does not start when I enter > > > > max_connections 200 > > > > although it reports max_connections 100 > > Where you enter it? Should be "max_connections=200" in my.cnf file. > > And yes, upgrade if you can :) > # This will be passed to all mysql clients [client] #password = my_password port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 log = /var/log/mysql.log basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/english skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K max_connections = 200 [mysqldump] quick set-variable = max_allowed_packet=1M [mysql] no-auto-rehash [isamchk] set-variable = key_buffer=16M Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php