Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. MySQL tables crashed

MySQL tables crashed

Scheduled Pinned Locked Moved Database
helpdatabasemysqlquestioncareer
4 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • K Offline
    K Offline
    khurram_shahzad
    wrote on last edited by
    #1

    Hi everyone, I'm a software developer and just started my professional career life, question here i want to ask is ... that few days ago i was at client site to resolve some issue in application deployed by a company that uses MySQL for database, what i was found that there are four MySQL tables were crashed due to low harddisk space issue (I've searched on net that this is a usual problem with MySQL) that then i repaired by using myisamchk command. Error shown by MySQL when these were accessing is [table name] marked as crashed and should be repaired. ok so this was the background scenario, now what i want to know/ask here is ... as described in above details that these 4 four tables were not accessible becuase they are crashed but I took a backup of this database and restore it to MySQL at another machine then i can access these table easily with no issue/error by MySQL, SO WHY THIS HAPPENS THAT AT ONE SIDE THESE ARE AS CRASHED AND ON ANOTHER THE BACKUP OF SAME DATABASE THAT WAS TAKEN WHEN THESE TABLES ARE CRASHED ARE THEN WORKING FINE. I really will appreciate any kind of help on this topic Im just asking this for knowlegde and second thing is my boss also asked me the same question ;P

    J L 2 Replies Last reply
    0
    • K khurram_shahzad

      Hi everyone, I'm a software developer and just started my professional career life, question here i want to ask is ... that few days ago i was at client site to resolve some issue in application deployed by a company that uses MySQL for database, what i was found that there are four MySQL tables were crashed due to low harddisk space issue (I've searched on net that this is a usual problem with MySQL) that then i repaired by using myisamchk command. Error shown by MySQL when these were accessing is [table name] marked as crashed and should be repaired. ok so this was the background scenario, now what i want to know/ask here is ... as described in above details that these 4 four tables were not accessible becuase they are crashed but I took a backup of this database and restore it to MySQL at another machine then i can access these table easily with no issue/error by MySQL, SO WHY THIS HAPPENS THAT AT ONE SIDE THESE ARE AS CRASHED AND ON ANOTHER THE BACKUP OF SAME DATABASE THAT WAS TAKEN WHEN THESE TABLES ARE CRASHED ARE THEN WORKING FINE. I really will appreciate any kind of help on this topic Im just asking this for knowlegde and second thing is my boss also asked me the same question ;P

      J Offline
      J Offline
      jschell
      wrote on last edited by
      #2

      khurram_shahzad wrote:

      ..were crashed due to low harddisk space issue...SO WHY THIS HAPPENS

      If I had to guess - because of low hard disk space. By the way...really, really bad idea to let a database server run out of hard drive space. Doesn't matter what type of database either.

      1 Reply Last reply
      0
      • K khurram_shahzad

        Hi everyone, I'm a software developer and just started my professional career life, question here i want to ask is ... that few days ago i was at client site to resolve some issue in application deployed by a company that uses MySQL for database, what i was found that there are four MySQL tables were crashed due to low harddisk space issue (I've searched on net that this is a usual problem with MySQL) that then i repaired by using myisamchk command. Error shown by MySQL when these were accessing is [table name] marked as crashed and should be repaired. ok so this was the background scenario, now what i want to know/ask here is ... as described in above details that these 4 four tables were not accessible becuase they are crashed but I took a backup of this database and restore it to MySQL at another machine then i can access these table easily with no issue/error by MySQL, SO WHY THIS HAPPENS THAT AT ONE SIDE THESE ARE AS CRASHED AND ON ANOTHER THE BACKUP OF SAME DATABASE THAT WAS TAKEN WHEN THESE TABLES ARE CRASHED ARE THEN WORKING FINE. I really will appreciate any kind of help on this topic Im just asking this for knowlegde and second thing is my boss also asked me the same question ;P

        L Offline
        L Offline
        Lost User
        wrote on last edited by
        #3

        The message might be a bit misleading. Crashed does not mean your tables are goofed up, it only means that the database engine has set an internal flag on those tables that indicate that the tables can no longer take new rows because of lack of space. Once you move your database to a new server, your database engine is smart enough to recalculate the new space and removes the flag.

        K 1 Reply Last reply
        0
        • L Lost User

          The message might be a bit misleading. Crashed does not mean your tables are goofed up, it only means that the database engine has set an internal flag on those tables that indicate that the tables can no longer take new rows because of lack of space. Once you move your database to a new server, your database engine is smart enough to recalculate the new space and removes the flag.

          K Offline
          K Offline
          khurram_shahzad
          wrote on last edited by
          #4

          Yes thanks .. I'm also thinking the same.

          1 Reply Last reply
          0
          Reply
          • Reply as topic
          Log in to reply
          • Oldest to Newest
          • Newest to Oldest
          • Most Votes


          • Login

          • Don't have an account? Register

          • Login or register to search.
          • First post
            Last post
          0
          • Categories
          • Recent
          • Tags
          • Popular
          • World
          • Users
          • Groups