Re: mysql max_connections
Posted by:
Rick James
Date: December 25, 2009 12:49AM
Here are 4 suggestions, each of which _might_ fix the problem.
1. Add a layer to your code to recognize the same query
2. Use the Query cache
3. Show us the slow query; perhaps we can optimize it so it not such a problem.
4. Switch to InnoDB, which does row-level locking instead of table-level.
max_connections and max_user_connections are different things. The latter gives you the control you want; the former is causing you trouble.
Subject
Written By
Posted
December 11, 2009 01:26AM
December 12, 2009 03:56PM
December 16, 2009 11:59PM
December 17, 2009 12:39AM
December 20, 2009 11:39PM
December 22, 2009 12:37AM
December 24, 2009 02:01PM
Re: mysql max_connections
December 25, 2009 12:49AM
December 25, 2009 03:30AM
December 25, 2009 03:49AM
December 25, 2009 11:12PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.