Tracking CPU bottlenecks on mysql

[Leandro N. Camargo]

Does anyone knows how to find these CPU bottlenecks culprit?
From time to time I have 99.5%+ CPU consumption on dedicated server I
work on.
I need to find ways to track the reasons down and settle this thing.

[Brian Cryer]

"Leandro N. Camargo" <leand...@gmail.com> wrote in message
news:47a0f7aa-361b-490d...@p8g2000yqb.googlegroups.com...

MySQL Administrator will show you the connections and what they are doing,
or alternatly use "show processlist" to see what is currently running. This
will show you what queries are currently running and that may give you a
good starting point.

HTH.
--
Brian Cryer
www.cryer.co.uk/brian

[Peter H. Coffin]

*grin* For me, it's usually because I'm rebuilding six indexes over a
table with a few million rows in it. That only happens a couple of times
per week, though.

--
70. When my guards split up to search for intruders, they will always travel in
groups of at least two. They will be trained so that if one of them
disappears mysteriously while on patrol, the other will immediately call
for backup, instead of quizzically peering around a corner. --Overlord

[Leandro N. Camargo]

On 10 nov, 13:37, "Brian Cryer" <not.here@localhost> wrote:
> MySQL Administrator will show you the connections and what they are doing,
> or alternatly use "show processlist" to see what is currently running. This
> will show you what queries are currently running and that may give you a
> good starting point.

Thanks a ton, Brian.

[majale]

Leandro N. Camargo wrote:

google for "log slow queries mysql"
it will help you