Where can I get a sample my.cnf? Thanks, Rekha
-----Original Message----- From: Steve Katen [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 6:17 PM To: Rekha Das; '[EMAIL PROTECTED]' Subject: Re: How to set max_connections ? 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
