Divi WordPress Theme

MySQL error - Too many MySQL connections

Topic: MySQL error - Too many MySQL connections  (Read 5081 times)

Offline digitalpoint

  • New Member
  • *
  • Posts: 45
  • iTrader: +0/-0
    • View Profile
MySQL error - Too many MySQL connections
« on: June 25, 2009, 11:17:06 AM »
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
VPS Hosting - AccuWebHosting

Offline Kailash

  • Web Hosting Master
  • *****
  • Administrator
  • Posts: 660
  • iTrader: +153/-0
    • View Profile
Re: MySQL error - Too many MySQL connections
« Reply #1 on: June 25, 2009, 11:20:12 AM »
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,

Offline kvchosting

  • New Member
  • *
  • Posts: 17
  • iTrader: +0/-0
    • View Profile
Re: MySQL error - Too many MySQL connections
« Reply #2 on: November 25, 2009, 07:02:28 PM »
[mysqld]

max_connections = 600

and restart the mysql


Shopify Divi WordPress Theme
Tags:

Check MySQL service uptime through command line

Started by KailashBoard How Tos

Replies: 2
Views: 21315
Last post November 22, 2011, 10:03:24 PM
by Mrtu92
commands to start/stop/restart MySQL server

Started by AnonymousBoard MySQL

Replies: 3
Views: 5768
Last post September 20, 2021, 08:56:45 PM
by kumkum
check PHP and MySQL version through shell (SSH) on Linux Server

Started by KailashBoard cPanel/WHM

Replies: 10
Views: 74635
Last post January 11, 2019, 07:18:59 PM
by rubyatiy
Converting Microsoft Access Databases to MySQL

Started by TechBoard MS Access

Replies: 0
Views: 4756
Last post August 29, 2007, 02:21:15 AM
by Tech
MS SQL / MySQL - A Case Study

Started by TechBoard MSSQL server

Replies: 0
Views: 5894
Last post August 30, 2007, 01:51:07 AM
by Tech