Home   Help Login Register  
Welcome, Guest. Please login or register.

Login with username, password and session length

Search
Free Website WooThemes - Quality Themes, Great Support
Pages: [1]   Go Down
Print
Topic: MySQL error - Too many MySQL connections  (Read 1455 times)
« on: June 24, 2009, 10:47:06 PM »
digitalpoint Offline
Newbie

View Profile
*

iTrader: 0
Posts: 46



Hi Friends,

I am frequently receiving an error "Too many MySQL connections". I have to restart the MySQL service each time to fix it.

Any help would be appreciated.

Thanks,

Digitalpoint

Share this topic on AskShare this topic on BlinkbitsShare this topic on BlinklistShare this topic on BloglinesShare this topic on BmarksShare this topic on Del.icio.usShare this topic on DiggShare this topic on DzoneShare this topic on FacebookShare this topic on Feed Me LinksShare this topic on FurlShare this topic on GoogleShare this topic on LiveShare this topic on MagnoliaShare this topic on MySpaceShare this topic on NetvouzShare this topic on NewsvineShare this topic on OneviewShare this topic on RedditShare this topic on RojoShare this topic on ScuttleShare this topic on ShadowsShare this topic on SlashdotShare this topic on SpurlShare this topic on SquidooShare this topic on StumbleUponShare this topic on TechnoratiShare this topic on TwitterShare this topic on TipdShare this topic on YahooShare this topic on Google buzz
Logged
« Reply #1 on: June 24, 2009, 10:50:12 PM »
Kailash Offline
Administrator
Newbie

View Profile WWW
*****

iTrader: 50
Posts: 285



It seems that you are receiving this error due number of MySQL connections are exceeded. You can set the maximum allowed connection in '/etc/my.cnf' (Only for Linux). Additionally you will also need to check which user is using more connections on the server. Generally this happens due to bad coding and if you are not closing MySQL connections in the scripts.

Thanks,
Logged

« Reply #2 on: November 25, 2009, 06:32:28 AM »
kvchosting Offline
Newbie

View Profile
*

iTrader: 0
Posts: 17



[mysqld]

max_connections = 600

and restart the mysql


Logged
Pages: [1]   Go Up
Print
Jump to:  

Untitled Document
(c) 2010 HELM, WHM, cPanel, ASP, .Net development, PHP, MySQL, MSSQL Server, SEO support forum
Powered by SMF 1.1.16 | SMF © 2011, Simple Machines | Forum style designed by PixelSlot
Web Hosting - Sitemap - XML Sitemap