Hello Steve Katen <[EMAIL PROTECTED]>, How do you tell the number of connections currently in use?
On Mon, 10 Jun 2002 18:17:19 -0700 Steve Katen <[EMAIL PROTECTED]> wrote: > 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 -- Patrick Hsieh <[EMAIL PROTECTED]> GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg --------------------------------------------------------------------- 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