By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,117 Members | 1,714 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,117 IT Pros & Developers. It's quick & easy.

max_user_connections : What Value ?

P: n/a
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_connections errors and need to
restart SQL server.

The max_user_connections 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
Jul 17 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 21 Dec 2004 06:03:34 -0800, He*****@2cuk.co.uk (Henry) wrote:
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_connections errors and need to
restart SQL server.

The max_user_connections 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 ?


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 / <an**@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool
Jul 17 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.