MySQL Forums
Forum List  »  Newbie

Re: "Error establishing a database connection" when too busy
Posted by: Rick James
Date: October 26, 2011 08:13PM

> table_cache=8196
Perhaps excessive.

Are the tables MyISAM or InnoDB?

If all MyISAM, recommend key_buffer_size = 500M

> max_user_connections=25
Are all your users logging in with different "user" names?

> query_cache_size=128M ## 32MB for every 1GB of RAM
Excessive -- the "maintenance on that cache is 'linear'. Recommend no more than 50M.

> max_connections=500
Yes, raising it might help. Unless something else is causing the problem. Caution: 500 takes about 100MB of RAM.

Options: ReplyQuote


Subject
Written By
Posted
Re: "Error establishing a database connection" when too busy
October 26, 2011 08:13PM


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.