hey,
thanks for replying so soon. the max limit of files and inodes have been
increased on the system. So that is not a problem. But what i really meant to ask
was if mysql scales well over 1000 connections (assuming that i'm not having any
external problems like the OS for instance).
Tx.
Vinod
------------- Original Message --------------
"Jorge del Conde" <[EMAIL PROTECTED]> wrote:
To:<[EMAIL PROTECTED]>,
"vinod panicker" <[EMAIL PROTECTED]>
From:"Jorge del Conde" <[EMAIL PROTECTED]>
Date:Sat, 3 Mar 2001 01:17:41 -0600
Subject: Re: max connections
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
