Portal Home > Knowledgebase > Articles Database > Server Load & MySQL Connection Error?
Server Load & MySQL Connection Error?
| Posted by Jamie911, 11-22-2014, 11:04 PM |
| I have a VPS and was hoping to get some advice from the experts
About once every day or so I get an error on my website saying that it failed connecting to the MySQL database. At about these same times, it looks like the server load is spiking.
MySQL shows that it's online so I'm not sure if the server load could cause issues with the database connection.
This is a VPS running the latest version of cPanel.
Can anyone provide me with some advice on how to check what's causing the issues connecting to MySQL and what's causing the load to spike?
Thanks in advance for any help you guys can provide!
|
| Posted by net, 11-22-2014, 11:20 PM |
| Move > Hosting Security and Technology.
|
| Posted by xlightwaverx, 11-22-2014, 11:27 PM |
| What do the HTTP and php logs tell you?
|
| Posted by gendjik, 11-23-2014, 03:06 AM |
| was it suddenly spiking or it went flat high for some time? what's your memory usage? did you often get %st high. please post your top result here and any error in mysql log when it happen
|
| Posted by Srv24x7, 11-25-2014, 01:51 AM |
| Hi,
Check the MySQL connections. Use the below command to see if any specific DB is causing this.
mysqladmin proc
|
Add to Favourites 
Print this Article
Also Read
