Jump to content

80 second Queries use very little CPU?


anon_login_001

Recommended Posts

I have a particular query running 80 - 120 seconds, but uses very little CPU (10% or less) the whole time.

 

Is this common, or does anyone have some direction on where to start looking to resolve this?

 

With CPU this low, I get the feeling that it could be made much faster if MySQL would take more processor power.

 

Any ideas?

Link to comment
https://forums.phpfreaks.com/topic/124961-80-second-queries-use-very-little-cpu/
Share on other sites

Well, explain tells me it's looking at a lot of records, and I it seems like it's lagging in the sort.

 

My workplace is moving to a Windows Only environment, even on servers, so my dev box is windows right now - know of any good disk I/O tools that run on Windows?

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.