...

View Full Version : what causes slow queries



jeromepelletier
03-14-2007, 12:12 AM
What causes periodic slow queries? I have checked my slow query logs and for some reason everyonce in awhile, a query thats never slow might be for example, one took 3 seconds to execute and every once in awhile a chat might take 10 seconds of cpu time while rest of the time 0.09...why is it it flexuates so much?

thesavior
03-16-2007, 02:39 AM
it could have to do with server load, number of queries being run at that time, what else is being run from the server, etc. Obviously your query isnt really changing, but the server is constantly. Its called a server because it has to serve all the requests it gets, sometimes people have to wait.

jeromepelletier
03-17-2007, 06:07 AM
it could have to do with server load, number of queries being run at that time, what else is being run from the server, etc. Obviously your query isnt really changing, but the server is constantly. Its called a server because it has to serve all the requests it gets, sometimes people have to wait.



it is a shared server...we will see when i get my dedicated! :)



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum