High CPU --> Find the worst query and let's optimize it.
SHOW CREATE TABLE
SHOW TABLE STATUS
EXPLAIN SELECT ...
It may be as simple as adding a 'compound' index. Or rewriting a WHERE clause.
There are literally hundreds of possible issues and answers. The 3 things
above are probably e
Hey Simon,
You just performed the classic, "I have an issue, but I won't provide any
info."
Please elaborate on the issue. Provide hardware spec, config information.
Tell us why you suspect the mysqld is consuming too much resource?
We can attempt to assist with more info as there are no silver
