what do you mean it doesn't do anything? you should be able to set it on the command line as:
--set-variable=max_connections=200 or you could edit the my.cnf file that mysql is using when it starts-up. if you can't find the my.cnf, then you should create one. here is a link to the manpage and some default entires on mysql.com: http://www.mysql.com/doc/O/p/Option_files.html either way, you can check to see if the max connections has been updated by running the below command at the mysql prompt: show variables; katen At 06:05 PM 6/10/2002, Rekha Das wrote: >Hi all, > >I am trying to set max_connections to 200 on my server. Currently it is 100. >My mysql version 3.22.32. My problem is I am not able to find my.cnf. And if >I set the variable on command line like this: > >--set-variable = max_connections=200; > >Then it does not do anything. > >What am I doing wrong ? > >Thanks, >Rekha > >--------------------------------------------------------------------- >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 --------------------------------------------------------------------- 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
