Hi,
The maximum number of connections that mysql can accept is restricted by
both: the OS and ulimit. In other words, you can set max_connections as
high as you want without bypassing the limits specified in ulimit.
If you do ulimit -n you should get the number of connections allowed (1024
by default I think) ..
Read section 21.3 in the manual for having several servers running on
different ports on the same machine.
Regards,
Jorge
MySQL Development Team
__ ___ ____ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\____/ Mexico City, Mexico
<___/
----- Original Message -----
From: "vinod panicker" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 02, 2001 1:09 PM
Subject: max connections
> hey,
> i'm developing a product that heavily utilizes mysql databases through
PHP. The max number of connections that any server can handle is needed as
i have to think of scaleability issues. The servers are pretty powerful -
it maxes out at 4G's 2x850 P-III. I need max performance out of this box.
It will be accessed by multiple web servers.
> I also wanted to know if I can have 2 mysql servers on the same
machine accessing and serving data from the *same* database... also, at what
number of connections does mysql go for a toss?
>
> Tx.
> Vinod
>
> _____________________________________________________
> Chat with your friends as soon as they come online. Get Rediff Bol at
> http://bol.rediff.com
>
>
>
>
>
> ---------------------------------------------------------------------
> 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
