Server mysql overload

[The_cobra666]

Sometimes, I see alot of connection's to the apache and mysql and the load way past 15 in 3/4 of the time. Since this is random I don't realy know where to search. I'll post a screenshot of what da looked like when the server was almost not responsive anymore. The memory is also always @ 100 % (512 MB) and the swap file @ 50 % when mysql crashes.

 

[Aspegic]

Just out of curiocity, have you checked if maybe the googlebot (or some other searchengine bot) is busy scanning a site on your server with lots of html pages using a mysql database?

 

[The_cobra666]

Nope not googlebot, there are however some bots from picsearch.com on the site. But that was also before, when we where on a shared server. That worked perfect before, even with 50 bots on it.

 

[nobaloney]

Usually just restarting apache will drop your numbers significantly.

On RHL/RHEL/CentOS:

# service httpd restart

Jeff

 

[The_cobra666]

Well if I shut down mysql, the load is gone in a second. Tis isn't very normal. And it's frequently happening.