Re: 100% CPU load problem

2009-09-22 Thread Lawrence Robertson
;m looking at it. - Original Message From: Kyong Kim To: Lawrence Robertson Cc: mysql@lists.mysql.com Sent: Monday, September 21, 2009 4:25:34 PM Subject: Re: 100% CPU load problem Is the status information correct? > mysql Ver 14.12 Distrib 5.0.27, for Win32 (ia32) Are you using

Re: 100% CPU load problem

2009-09-21 Thread Lawrence Robertson
>Is the status information correct? >> mysql Ver 14.12 Distrib 5.0.27, for Win32 (ia32) >Are you using some sort of vm? I'm not using a VM at all. It's a simple PC with CentOS 4 and MySql. Don't know why is that Ver 14.12 Distrib 5.0.27, for Win32 (ia32). But the > | version_compile_os

100% CPU load problem

2009-09-21 Thread Lawrence Robertson
Hi. We have some MySql servers in a circular replication, and one of the servers is having some performance issues for some weeks. I tried with mysqlcheck and nothing is wrong. I'm logging the slow queries and there's nothing wrong. The complete database in this server is like 1GB when it's G