Mysql error Too many connections

[kevin78]

Hello

 

I have one issue on my server sometimes when i editing my website (editing products, or order status or other)

Sometimes, i get this error like today :

 

On the log of /var/log/syslog :

Feb 19 17:00:09 postfix/proxymap[9976]: warning: connect to mysql server 127.0.0.1: Too many connections
Feb 19 17:00:09 postfix/trivial-rewrite[10416]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem

During this timelaps, i cant reach my website. I get the error below "too many connections".

Whereas there are only 20-30 users on the website.

 

The other website on the same server works perfectly during this problem.

I have to restart the server or wait the timeout to make working the website

 

I dont know why i get this error.

I dont find any logs in the /var/log/mysql

 

The max_connecions is configured with the default value :

 

my.cnf

key_buffer              = 16M
max_allowed_packet      = 16M
thread_stack            = 192K
thread_cache_size       = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover         = BACKUP
#max_connections        = 100
#table_cache            = 64
#thread_concurrency     = 10
#
# * Query Cache Configuration
#
query_cache_limit       = 1M
query_cache_size        = 16M

I dont think that error comes from this parameter.

Who can help me please ?

Do you think i shoud increase this value ?

 

When i get this error, nobody cant visit the website.

So there are 0 users during this problem.

All visitors get timeout and they see "mysql connection error : too many connection"

 

 

I used PS 1.5.4.1

On dedicated server

With

Linux ns209815.ovh.net 3.2.13-grsec-xxxx-grs-ipv6-64 #1 SMP Thu Mar 29 09:48:59 UTC 2012 x86_64 GNU/Linux
 

 

 

 

On the apache log, i can find also many times (this is an extract only) :

[Wed Feb 19 17:00:19 2014] [warn] mod_fcgid: process 27352 graceful kill fail, sending SIGKILL
[Wed Feb 19 17:00:31 2014] [warn] mod_fcgid: process 8450 graceful kill fail, sending SIGKILL
[Wed Feb 19 17:00:31 2014] [warn] mod_fcgid: process 24408 graceful kill fail, sending SIGKILL
[Wed Feb 19 17:02:33 2014] [warn] mod_fcgid: process 8460 graceful kill fail, sending SIGKILL
[Wed Feb 19 17:02:33 2014] [warn] mod_fcgid: process 27353 graceful kill fail, sending SIGKILL
[Wed Feb 19 17:02:33 2014] [warn] mod_fcgid: process 9140 graceful kill fail, sending SIGKILL
[Wed Feb 19 17:02:39 2014] [warn] mod_fcgid: process 9243 graceful kill fail, sending SIGKILL
[Wed Feb 19 17:02:39 2014] [warn] mod_fcgid: process 9241 graceful kill fail, sending SIGKILL
[Wed Feb 19 17:02:44 2014] [warn] mod_fcgid: process 9250 graceful kill fail, sending SIGKILL
[Wed Feb 19 17:02:44 2014] [warn] mod_fcgid: process 9247 graceful kill fail, sending SIGKILL
[Wed Feb 19 17:02:56 2014] [warn] mod_fcgid: process 9258 graceful kill fail, sending SIGKILL
[Wed Feb 19 17:02:56 2014] [warn] mod_fcgid: process 9254 graceful kill fail, sending SIGKILL
[Wed Feb 19 17:03:12 2014] [warn] mod_fcgid: process 9317 graceful kill fail, sending SIGKILL
[Wed Feb 19 17:03:12 2014] [warn] mod_fcgid: process 9314 graceful kill fail, sending SIGKILL
[Wed Feb 19 17:03:16 2014] [warn] mod_fcgid: process 9323 graceful kill fail, sending SIGKILL
[Wed Feb 19 17:03:22 2014] [warn] mod_fcgid: process 9337 graceful kill fail, sending SIGKILL
[Wed Feb 19 17:03:22 2014] [warn] mod_fcgid: process 9333 graceful kill fail, sending SIGKILL

 

Edited February 19, 2014 by kevin78 (see edit history)

[pankowaty]

Hello,

 

I experience a problem, which I believe is related to aforementioned one. From time to time on my website http://catofmoon.com I see a "Link to database can not be Established: SQL STATE [08004] [1040] too many connections" error displayed on a blank page. I use PS 1.6.1.5 on OVH hositing, with PHP 5.4. 

I think the problem is not related to heavy traffic, as the website is lightly loaded. 

Now I wonder what steps should I take to investigate and fix the problem. Any suggestions? I'd be thankful for any advice.

[rictools]

I had this before I upgraded my hosting package to a more expensive one.

 

Maybe there are machines heavily crawling your shop ...