CPU usage of mysql on windows 2000.

Hi,
I'd like to know about mysql...

I have a web application that use windows mysql on Windows2000.
When I query something from Web application, CPU usage of mysql daemon
goes up to 90% and go down when query has done.
(it's normal state... )

Sometimes it goes up to 90% and nerver go down again...it stay at 90%..
even if querey had done.


I'd like to heare about CPU usage of mysql daemon.
Is there any bug reporting about cpu usage of mysql?

A.there is problem with mysql itself?
B.there is problem with Windows 2000 between mysql?

Any opinion will help me!!!

Have a day.

somez72 wrote:
> Hi,
> I'd like to know about mysql...
>
> I have a web application that use windows mysql on Windows2000.
> When I query something from Web application, CPU usage of mysql daemon
> goes up to 90% and go down when query has done.
> (it's normal state... )
>
> Sometimes it goes up to 90% and nerver go down again...it stay at 90%..
> even if querey had done.
>
>
> I'd like to heare about CPU usage of mysql daemon.
> Is there any bug reporting about cpu usage of mysql?
>
> A.there is problem with mysql itself?
> B.there is problem with Windows 2000 between mysql?
>
> Any opinion will help me!!!
>
> Have a day.
>
>

1. Did you check the bugs list on www.mysql.com?
2. Not here.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

somez72 wrote:
> Hi,
> I'd like to know about mysql...
>
> I have a web application that use windows mysql on Windows2000.
> When I query something from Web application, CPU usage of mysql daemon
> goes up to 90% and go down when query has done.
> (it's normal state... )
>
> Sometimes it goes up to 90% and nerver go down again...it stay at 90%..
> even if querey had done.
>
>
> I'd like to heare about CPU usage of mysql daemon.
> Is there any bug reporting about cpu usage of mysql?
>
> A.there is problem with mysql itself?
> B.there is problem with Windows 2000 between mysql?
>
> Any opinion will help me!!!
>
> Have a day.

Some of the following questions would help to diagnose this problem.

What version of MySQL are you using?
What is the SQL query executing at the time of high CPU load?
What is the DDL of tables used in that SQL query? Indexes?
What does EXPLAIN tell you about the SQL query?
If you are using MySQL 5.0+, do you have any triggers executing because
of the query?
What does SHOW PROCESSLIST and SHOW INNODB STATUS tell you during the
time of high CPU load?
What information can you get from the MySQL error log, or the Windows
Event viewer?
Is the MySQL system tray application running?
Is the MySQL instance manager application running?
What web application technology are you using (PHP/ASP/Java/etc.)
Does this CPU usage behavior happen when running the same query against
the same data on other operating systems?

Regards,
Bill K.

What do expect - after all it is "windows". :)