Hi,
If you want to have 1000+ connections, you will need to modify and recompile
LinuxThreads. Afterwards, you'll need to recompile MySQL while linking with
the new libpthread.a library.
Check the following section from the manual:
http://www.mysql.com/doc/L/i/Linux.html
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]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, March 03, 2001 2:52 AM
Subject: Re: Re: max connections
> 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
---------------------------------------------------------------------
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