Results 1 to 10 of 10
  1. #1
    Join Date
    Apr 2006

    Why MySQL tables crash?


    This is something i was wondering about and never found any answers.
    Based on your experience, what are the most common reasons mysql tables crash?


  2. #2
    Join Date
    Nov 2003
    New Jersey, USA
    High server load, unoptimized tables/queries.
    Web Hosting - Reseller Hosting - VPS - Dedicated Servers - Cloud Hosting - Email Marketing
    BuyHTTP, LLC - R1Soft CDP backup and RVsitebuilder included with all shared/reseller plans
    Cloud Hosting Truly redundant high available cloud from a trusted name.

  3. #3
    MySQL database is known for its stability but as any other software application, there may be sometimes bugs that could crash the Mysql tables.
    Support Facility | 24/7 web hosting technical support services
    Technical support | Server management | Data migration

    Technical Articles

  4. #4
    Join Date
    Apr 2009
    mysqldump running while table is being highly used

  5. #5
    Join Date
    Nov 2003
    Lynnwood, WA
    Bad SQL being sent to it, very high server load (especially if RAM runs out and you're eating into swap, and even more especially if swap fills and the kernel starts killing stuff, like mysqld), faulty hardware (in order of responsibility for mysql problems: RAM, hard drive, everything else).

  6. #6
    Incorrect shutdown, lack of free space (RAM/HDD), server load

  7. #7
    Join Date
    Dec 2006
    I'd say there are four causes -

    1. incorrect shutdown (which can be caused by power failure, killing the process, ram exhaustion, hitting a mysql bug that crashes the process, etc.)
    2. hardware failure (disk errors, ram parity errors, cpu errors)
    3. disk full.
    4. mysql bug in the code that writes to the table.

    I'm surprised so many say "server load". How does that crash tables without it being one of the other issues such as RAM exhaustion occurring while under heavy load? Similarly for badly written SQL/bad index design - you can corrupt that data within the table that way, and it can contribute to resource usage which then causes on of the other problems, but I can't see how a bad query can actually crash a table unless it hits a mysql bug, which isn't really the fault of the SQL.

  8. #8
    Join Date
    May 2009
    On a Speck!!!!!
    This is too little information to work with.

    1) What is the Mysql version in the server?
    2) Is it Mysql 5.x?
    3) Does the table stem from versions < 4.1?
    4) Do you have characters < blank in your columns?
    5) Do you run heavy concurrency (multiple connections) with high load?
    6) What is the error message you get?
    7) How do your insert, update, delete statements look like?
    8) What is the result of SHOW CREATE TABLE?

  9. #9
    Join Date
    Sep 2007

  10. #10
    Join Date
    May 2009
    On a Speck!!!!!
    mysql> SHOW CREATE TABLE example;
    | Table | Create Table |
    | example | CREATE TABLE `example` (
    `id` int(11) default NULL,
    `data` varchar(100) default NULL
    1 row in set (0.00 sec)

    (this example from MySQL 4.1)

Similar Threads

  1. Two MySQL Tables
    By Rob83 in forum Programming Discussion
    Replies: 7
    Last Post: 07-10-2005, 11:03 AM
  2. MySQL tables inside tables
    By Lem0nHead in forum Hosting Security and Technology
    Replies: 3
    Last Post: 09-25-2004, 09:05 PM
  3. mysql and server crash
    By yohance in forum Hosting Security and Technology
    Replies: 4
    Last Post: 01-17-2003, 07:48 PM
  4. Why does this crash MySQL?
    By kreativ in forum Hosting Security and Technology
    Replies: 9
    Last Post: 06-21-2002, 07:33 AM
  5. MySQL tables
    By MarieQ in forum Web Hosting
    Replies: 3
    Last Post: 11-16-2000, 04:41 PM

Posting Permissions

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