anon_login_001 Posted September 19, 2008 Share Posted September 19, 2008 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? Quote Link to comment https://forums.phpfreaks.com/topic/124961-80-second-queries-use-very-little-cpu/ Share on other sites More sharing options...
Mchl Posted September 19, 2008 Share Posted September 19, 2008 Perhaps its using a hard disk a lot Use EXPLAIN to analyze this query Quote Link to comment https://forums.phpfreaks.com/topic/124961-80-second-queries-use-very-little-cpu/#findComment-645678 Share on other sites More sharing options...
anon_login_001 Posted September 19, 2008 Author Share Posted September 19, 2008 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? Quote Link to comment https://forums.phpfreaks.com/topic/124961-80-second-queries-use-very-little-cpu/#findComment-645757 Share on other sites More sharing options...
corbin Posted September 19, 2008 Share Posted September 19, 2008 Want to tell us the query and table schema? Quote Link to comment https://forums.phpfreaks.com/topic/124961-80-second-queries-use-very-little-cpu/#findComment-645944 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.