max_user_connections : What Value ?

[Henry]

Hi,

We run PHP on a Linux Server Fedora AMD 1.3 Duron, 512 MB RAM, 60 GB
HD.

The website welcomes more and more users.

Problem : we very often have max_user_connec tions errors and need to
restart SQL server.

The max_user_connec tions variable_name in MySQL is set to 0 and
max_connections is set to 100.

Question : Wish values do you think are the most appropriated ?

I thank you for your advise

Mary Henry

http://www.jssgallery.org

[Andy Hassall]

Re: max_user_connec tions : What Value ?

On 21 Dec 2004 06:03:34 -0800, Henry16@2cuk.co .uk (Henry) wrote:
[color=blue]
>We run PHP on a Linux Server Fedora AMD 1.3 Duron, 512 MB RAM, 60 GB
>HD.
>
>The website welcomes more and more users.
>
>Problem : we very often have max_user_connec tions errors and need to
>restart SQL server.
>
>The max_user_connec tions variable_name in MySQL is set to 0 and
>max_connection s is set to 100.
>
>Question : Wish values do you think are the most appropriated ?[/color]

Sounds like an "It Depends" question. How many simultaneous connections do you
need, and how many can the server handle given the typical SQL queries executed
down those connections? Presumably the answer is then the smaller of those two.

Are these connections connecting to a single username, or a small set of
usernames? If so, perhaps consider using persistent connections.

Or if the connections are to many separate usernames, make sure you're _not_
using persistent connections, else each connection to each username gets put in
the persistent connection pool and held open beyond the execution of the
script, and so makes the problem worse.

--
Andy Hassall / <andy@andyh.co. uk> / <http://www.andyh.co.uk >
<http://www.andyhsoftwa re.co.uk/space> Space: disk usage analysis tool