PREVIOS THREAD ON THIS TOPIC: Hope it helps
Hi,
Make sure that MySQL on your OS supports 5000 connections !
Check OS specific restrictions in MySQL documentation.
Regards
--
Joseph Bueno
NetClub/Trader.com
John Barton wrote:
>
> Try putting a line like the following in your my.cnf file:
> This has always worked for me, including 3.23.37
>
> set-variable = max_connections=xxxx
>
> John Barton
> Unix Systems Administrator
> Primary Networks, Inc.
> [EMAIL PROTECTED]
>
> On Thu, 10 May 2001, Mark Lo (3) wrote:
>
> > Hi,
> >
> > I would like to set a higher values in max_connections for mysql.
> >
> > I have tried to use the following command "mysqld --set-variables
> > max_connections=900 -u root -ppassword". Then, it shows that I have
> > successfully changed the variable of max_connections. But, when I check
it
> > with the command of "mysqladmin variables -u root -ppassword". The
> > max_connections return to 100 which is the default value. I wonder what
is
> > wrong with mysql3.23.37. Is this a bug, or I am using the wrong
command.
> >
> > In additions, Can I set the max_connections values higher than 5000.
> >
> > Thank you
> >
> > Mark
> >
> >
> > ---------------------------------------------------------------------
> > 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
---------------------------------------------------------------------
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
-----Original Message-----
From: Don Pro [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 2:37 PM
To: msql list
Subject: simultaneous connections
Hi,
I'm reading in my documentation (I have a book) that MySQL allows up to
101 simultaneous connections. Gadzooks! How can MySQL claim to be at
the Enterprise level with this limit? Is there any way around this?
Thanks,
Don
---------------------------------------------------------------------
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