Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

My Root Server is currently warning me that the cpu usage by mysql services is approximatelly higher than 300 % (quad-core)

Also the mysql tracking tells me that there are ~2,000 queries per second. Well, compared to my experience of visitors per second + queries per page, it shouldn't be more than 200. Normally even less than 50/sec.

I disabled persistent connections on my MySQL system, but it didn't help. Is there anything I could do to find out what's causing this high cpu usage and also this high amount of queries?

I also tried

SHOW FULL PROCESSLIST;

but it didn't return more than 5-8 on-going queries.

P.S.: I might try to enable log slow queries; but I don't really know how. I guess I have to put it somewhere in my /etc/my.cnf-file, but... Is there any well-explaining article regarding that?

Thanks in advance!

share|improve this question
    
Try an app like 'mytop' to see if you can spot who is so active –  ethrbunny Dec 23 '13 at 15:20
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.