Web Analytics Made Easy -
StatCounter Frequently Crashing MySQL Table - CodingForum


No announcement yet.

Frequently Crashing MySQL Table

  • Filter
  • Time
  • Show
Clear All
new posts

  • Frequently Crashing MySQL Table

    Hey guys, first time posting in this forum, but I've been lurking for a while, hah.

    I have a table that keeps crashing, about 2-3 times a day. It starts returning crazy results from queries (ie, only 1 result for a simple select query, when there should be about 100), and I have to run a repair to fix it.

    It's handling about 5 queries a second, non-stop, but that shouldn't be a problem, should it?

    Any ideas on what could cause frequent crashes like this?


    It's getting worse, requiring a repair about every hour now.
    I've had to halt all my operations until I get this issue resolved, because it's creating bad data.
    Last edited by komodo; Oct 13, 2006, 06:04 PM. Reason: Added edit
    Harry Maugans | Wallpapers | Car Wallpapers