Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    Regular Coder
    Join Date
    Jul 2005
    Posts
    216
    Thanks
    0
    Thanked 0 Times in 0 Posts

    what causes slow queries

    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?

  • #2
    Senior Coder
    Join Date
    Aug 2005
    Posts
    1,119
    Thanks
    2
    Thanked 1 Time in 1 Post
    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.

  • #3
    Regular Coder
    Join Date
    Jul 2005
    Posts
    216
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by thesavior View Post
    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!


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •