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

Reply via email to