Chat ID:10015715. Question: site down again
(6:12:22pm)System:Customer has entered chat and is waiting for an agent. 
(6:12:35pm)System:Thank you for verifying your billing account marcello.dippolito@gmail.com! 
(6:20:25pm)support helpdesk.:Welcome to hosting Live Chat, my name is Jon, I will be assisting you today. Please allow me a moment to review your initial question. 
(6:20:27pm)support helpdesk.:I'll be happy to help. May I have a URL where you are seeing this error? 
(6:21:01pm)masterunix:hello, all our domains with SQL connections are down ... it happen many hours ago i rebooted the server it was good for 1 hour then same problem 
(6:21:23pm)masterunix:i contacted Hosting 2 hours ago one of your colegues changed the SQL max connections setting from 25 to 100 
(6:21:34pm)masterunix:but it didnt help ... same problem again 
(6:21:47pm)masterunix:dedicated server: vivi-clothes.com 
(6:22:17pm)masterunix:please investigate asap 
(6:23:48pm)support helpdesk.:One moment please while I look into this. 
(6:25:35pm)masterunix:ok 
(6:27:09pm)support helpdesk.:I must temporarily reset the password for your WHM; once I have completed the necessary investigation, will change the password back to what it was previously. Do I have your permission to change the password for your WHM? 
(6:27:19pm)masterunix:yes 
(6:27:36pm)support helpdesk.:Thank you. One moment please while I look into this. 
(6:28:57pm)support helpdesk.:Are you getting an error of too many connections on your sites at this time? 
(6:30:01pm)masterunix:yes i have 
(6:33:11pm)support helpdesk.:It appears that your accounts have exceeded the max_connections on the server. One moment please while I look into this. 
(6:33:58pm)masterunix:yes your colleague also told me this and changed it from 25 to 100 then 2 hours later same problem ... i need you to make sure that its this problem 
(6:34:31pm)masterunix:i think its strange ... we always survived with max connection 25 and our servers are not that busy at this moment ... 
(6:35:57pm)support helpdesk.:I agree. It is likely an issue with another user on the server. One moment please while I look into this. 
(6:38:54pm)masterunix:another user? we are the only admin so i am not sure who this user is ... can you find out the ip address of the country? maybe the server is hacked 
(6:39:26pm)masterunix:unless its an internal user from your side you is working on it 
(6:41:10pm)support helpdesk.:That is not what I mean; by user, I would other domain names and cPanel under your server; when a cPanel is created, a user is created on the server; likewise, MySQL, FTP, HTTPD are all users unto themselves. 
(6:41:43pm)masterunix:i see 
(6:42:09pm)masterunix:strange thing is we didnt change or update anything on the server ... it just came to this situation since yesterday until now 
(6:43:07pm)support helpdesk.:I understand; this can be caused by a spike in traffic, depreciation of a MySQL database, or the locking of a process socket; however, I am still investigating this for you at this time. 
(6:47:14pm)support helpdesk.:I apologize for the delay, I'm still working on this. Thank you for your patience. 
(6:48:56pm)support helpdesk.:It appears that the connection limit has been hit by the database user: viviclot_cc tied to the appropriate site; that site will need to be optimized to minimize MySQL connections to avoid this error. 
(6:50:20pm)masterunix:can you tell me how 
(6:52:13pm)support helpdesk.:This will depend on the way this site was built; you will also want to contact your developer of this site directly to assist with its optimization as well. 
(6:53:36pm)masterunix:the problem is we run more websites and those are different software 
(6:58:15pm)support helpdesk.:I understand this; however, the issue here is that the site itself, vivi-clothes.com, produced more connections than your server was configured to take. 
(6:58:38pm)support helpdesk.:To fix this you will need to have that site optimized to minimize the MySQL connections. 
(6:59:20pm)masterunix:the site is already optimized to minimize the mysql connections 
(6:59:53pm)masterunix:its easy to blame the software but when i follow the forums support the solution was to change hosting company ... 
(7:00:31pm)masterunix:lot of users was helped by that ... the problem is somewhere at the hosting 
(7:00:52pm)masterunix:we never had this problem until yesterday and software didnt change also traffic didnt change 
(7:03:43pm)support helpdesk.:Unfortunately, this is not case; however, I can understand your frustration. The only thing governing your MySQL connections are two things: 
the connections listed in the.y.cnf file and the site's ability to close those connections when no longer needed 
(7:04:09pm)support helpdesk.:As you see here: 

viviclom@vivi-clothes.com [~/public_html]# cat /etc/my.cnf | grep "connections" 
max_connections=100 
max_user_connections=100 
(7:04:18pm)support helpdesk.:The max connections are already at 100 on your server. 
(7:04:28pm)masterunix:the software is already closting them accordingly .. 
(7:04:40pm)support helpdesk.:This means that the likely and only probable culprit would be the site. 
(7:05:04pm)masterunix:there is a thread about it at the forums and when hosting companies tell them this case they say the software is already closing connections immeatily when not needed anymore 
(7:05:12pm)masterunix:so i am sure its not the software 
(7:05:25pm)masterunix:other hosting knows how to solve 
(7:08:01pm)support helpdesk.:I do apologize; however, the information I have provided you is correct; if you do not believe this, this there is little that can be done; the connection can be increased but this won't solve any problem as there should not be more than 100 single user connections on a properly designed site. Again, you will need to have your software investigated. If you do not believe my recommendation, you are welcome to submit a ticket through http://hosting.com/billing >> create a ticket for our admins to investigate for you. 
(7:08:05pm)support helpdesk.:May I help with anything else today, while I've got you in LiveChat? 
(7:08:50pm)masterunix:what can a ticket do for me? you mean checking at higher level? 
(7:09:44pm)support helpdesk.:In all honesty, a ticket will likely confirm; we cannot optimize the site for you, however. Again, you will solve the connection issues that are caused by the site. 
(7:12:31pm)support helpdesk.:May I help with anything else today, while I've got you in LiveChat? 
(7:14:18pm)support helpdesk.:Are we still connected? Are there any other issues I can assist you with today? 
(7:15:42pm)masterunix:i am done thanks i will talk to the developer, but i think the result is changing hosting sadly you guys didnt give support and are to mainstream with your answeers