Yesterday I have 5 minutes downtime on my server. Of course I contacted soon with my hosting to clarify this. At first, as usual, wanted me bought a few GB of RAM which of course now I don`t need (I have 4GB RAM).
Writing a few more messages, I received a message of support hosting, it might be something with MySQL. Here's part of the message:
If I had to point out something that I think is responsible, I would first look to the sleeping MySQL queries. Your my.cnf is configured to kill queries that sit longer than 40 seconds, but your mysql process seems to always have about 10 sleeping queries. When old ones are killed, new ones come in. I'm not a MySQL expert, but I'd imagine that there is a portion of code that is connecting to the database when no queries are needed, and/or not closing the connection at the end.
Please check your code to see if there are connections being opened and not closed, or being opened when no queries need to run.
What are they exactly they mean and how to find out exactly what the code? Please help
