If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > MyISAM Table corrupt because a simple reboot?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-15-07, 12:16
fischermx fischermx is offline
Registered User
 
Join Date: Dec 2006
Posts: 15
MyISAM Table corrupt because a simple reboot?

Is this normal?
Yesterday, I rebooted my server, it was a restart from windows, a planned one, not a hardware failure or nothing.
I have a MyISAM table that records log information from other services, basically receiving a few inserts by second. But they are short, small transactions.
After the reboot, I found my table marked as corrupt ?
Is this normal? What was I supposed to do before the restart?
Is there a configuration option that helps on avoid this situation?

Last edited by fischermx; 03-15-07 at 12:28.
Reply With Quote
  #2 (permalink)  
Old 03-26-07, 07:35
aschk aschk is offline
Registered User
 
Join Date: Mar 2007
Location: 636f6d7075746572
Posts: 770
In theory the server should shutdown all services correctly which should halt MySQL correctly after the last insert/table lock. If you find your answer to this please post it. I'm sure others will come across this.
Reply With Quote
  #3 (permalink)  
Old 03-26-07, 11:28
fischermx fischermx is offline
Registered User
 
Join Date: Dec 2006
Posts: 15
My server is not a standalone server, but one of the so called "VPS" a virtual server inside other, in Windows. May be it handle the shutdown differently.
Reply With Quote
  #4 (permalink)  
Old 03-27-07, 05:48
aschk aschk is offline
Registered User
 
Join Date: Mar 2007
Location: 636f6d7075746572
Posts: 770
Ah, VPS reboots/shutdown are dealt with in a different way I believe. I wouldn't like to point the finger, however if the windows machine itself shutdown it may well have halted and terminated the running process associated with your MySQL server possibly causing corruption. There is a myisamchk function I believe that you can run, and also REPAIR TABLE <tablename> which ought to help recover such occurences.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On