thanks a million... i've got another problem that i've been struggling with for a long
time now. It needs to be fixed fast.. running out of time... the problem is this -
i'm using PHP to connect to mysql using mysql_connect(). The script runs fine till a
certain number of users. This 'certain number' keeps changing. When the machine is
rebooted, the server supports around 150 clients... but soon restarts and i get mysql
connection failed in the script. I ran the servers with logging enabled, but the
restart is not caused by any specific query as such. In the .cnf file, i've just
increased the max_connections variable. The server runs smoothly for some time and
then it just restarts without any warning... nothing in the .err file too! weird...
any hope, suggestions?
Tx.
Vinod
------------- Original Message --------------
"Jorge del Conde" <[EMAIL PROTECTED]> wrote:
To:"vinod panicker" <[EMAIL PROTECTED]>
From:"Jorge del Conde" <[EMAIL PROTECTED]>
Date:Sat, 3 Mar 2001 03:51:30 -0600
CC:<[EMAIL PROTECTED]>
Subject: Re: Re: max connections
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
