-1
votes
1answer
123 views

MySQL settings for MAXIMUM performance / can be specific to particular DB or user? [closed]

We have a dedicated server, a very powerful one, and I don't believe we are getting the most out of MySQL. Even when running ultra-heavy processes that take a very long time to complete, I'm showing ...
0
votes
2answers
357 views

Mysql killing the CPU with gettimeofday

I have a problem with mysql killing the CPU on a Debian Squeeze 64. This is a development machine on a VPS so I stopped all the other services, including apache2. The mysql version is 5.1.49. This is ...
2
votes
1answer
363 views

MySQL started to consume about 40% of system CPU time and got unresponsive suddenly

I use Debian 6.0.3 x86_64 and MySQL 5.5.20-1~dotdeb.0-log from the Dotdeb repository. MySQL process started to consume a lot of "sy" CPU time serveral hours ago according to this graph. I was not able ...
0
votes
1answer
529 views

Webserver max CPU when apache and MYSQL are ran together

This website has been running fine without issues, Recently it went down. After some investigation it looks like the combo of MYSQL and Apache bring the box to its knees. Apache can run find serving ...
2
votes
1answer
929 views

mysqld_safe at 100% CPU

I've seen this discussed in several places on the web, never with a clear answer. What does mysqld_safe do? What would cause it to go to 100% CPU and stay there? How can I make sure it doesn't happen ...