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 7 of 7
  1. #1
    Regular Coder
    Join Date
    Jan 2005
    Posts
    470
    Thanks
    3
    Thanked 0 Times in 0 Posts

    MySQL timing out on simple queries

    I have been working on a site for the past few of hours and everything has been running smoothly. About an hour ago every single page load suddenly started taking so long that most of them time out. I haven't changed anything with the queries or the database so I can't figure what is causing this. These queries are ridiculously simple and used to require upwards of 5 seconds to load the whole page at most.

    When I look at MySQL in the Windows task manager I see that it isn't using much CPU power, nor is anything else. However, my hard drive light is going non-stop when I try to load a page and whenever the page times out it is always on a line of code fetching a query result from the database.

    What could MySQL have suddenly started doing that even simple queries require vast amounts of hard drive usage?

  • #2
    raf
    raf is offline
    Master Coder
    Join Date
    Jul 2002
    Posts
    6,589
    Thanks
    0
    Thanked 0 Times in 0 Posts
    that is realy not enough information to let us help you.
    Posting guidelines I use to see if I will spend time to answer your question : http://www.catb.org/~esr/faqs/smart-questions.html

  • #3
    Regular Coder
    Join Date
    Jan 2005
    Posts
    470
    Thanks
    3
    Thanked 0 Times in 0 Posts
    This happens on Windows XP SP2 with MySQL 5.0.18, PHP 5.1.2, and Apache 2.0.55.

    Sadly these occurances also happen at random intervals and then spontaneously clear up at a random point.

  • #4
    New Coder
    Join Date
    Jul 2005
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by bauhsoj
    This happens on Windows XP SP2 with MySQL 5.0.18, PHP 5.1.2, and Apache 2.0.55.

    Sadly these occurances also happen at random intervals and then spontaneously clear up at a random point.
    You sound like you speak from personal experience

  • #5
    Regular Coder
    Join Date
    Jan 2005
    Posts
    470
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by yonni
    You sound like you speak from personal experience
    I have had the productivity of whole work days go down the tube many times before due to this sort of thing happening repeatedly.

  • #6
    Regular Coder
    Join Date
    Jan 2003
    Posts
    867
    Thanks
    4
    Thanked 8 Times in 8 Posts
    I'm grasping at straws, but it could be something seemingly unrelated. Perhaps a virus, spyware, or a p2p client hogging resources.

  • #7
    Regular Coder
    Join Date
    Jan 2005
    Posts
    470
    Thanks
    3
    Thanked 0 Times in 0 Posts
    I am suspecting that Windows is dipping into VM to supply MySQL with the memory it needs. I have 2 GB of RAM so I can't figure why that would be happening when I only have enough apps open to use at max half of the available RAM.


  •  

    Posting Permissions

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