Thanks for the advise.
The package you show gives the same output as the 'SHOW PROCESSLIST'
output, which I included in my previous email :)
The problem I have is that the process list, by 'mytop' or 'SHOW
PROCESSLIST' shows the server doing noting.
Yet 'top' and other tools show MySQL using 100% CPU....
I really need any kind MySQL guru who can give me some advise on how to
track down and stop my four MySQL servers doing what ever they doing...
I think it might be something to do with replication, as it's only my
severs which are replication slaves and masters at the same time who
tend to do this 100% CPU thing for hours on end...
Kevin Hunter wrote:
> At 3:25a -0500 on 17 Jan 2008, Ben Clewett wrote:
>> I need to know why MySql does this. If any person knows how I an
>> identify the problem, please let me know!
> I think this package helped another person out on this list a couple
> days ago: