← Back to team overview

maria-developers team mailing list archive

WL#135 New (by Dreas): Expose marked as crashed in table status

 

-----------------------------------------------------------------------
                              WORKLOG TASK
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
TASK...........: Expose marked as crashed in table status
CREATION DATE..: Tue, 31 Aug 2010, 14:59
SUPERVISOR.....: 
IMPLEMENTOR....: 
COPIES TO......: 
CATEGORY.......: Server-RawIdeaBin
TASK ID........: 135 (http://askmonty.org/worklog/?tid=135)
VERSION........: WorkLog-4.0
STATUS.........: Un-Assigned
PRIORITY.......: 10
WORKED HOURS...: 0
ESTIMATE.......: 0 (hours remain)
ORIG. ESTIMATE.: 0

PROGRESS NOTES:



DESCRIPTION:

We regularly run into tables that are marked as crashed (shown in syslog). If 
MySQL is marking the table as crashed, why is there no way to get a list of tables 
marked as such? That would make it much faster to check/repair such tables 
automatically without the need to run a check on ALL tables.

>From IRC:
(04:04:58 PM) montywi: myisamchk -d */*.MYI  ; search for 'marked'
(04:05:09 PM) montywi: -d (--describe) is safe to do
(04:05:59 PM) montywi: best thing would probably would be to add an option ' 
IF_CRASHED' to CHECK TABLE
(04:06:48 PM) montywi: in that case one could trivially use mysqlcheck to find out 
crashed tables and then automaticly, if so desired, run repair on them


ESTIMATED WORK TIME

ESTIMATED COMPLETION DATE
-----------------------------------------------------------------------
WorkLog (v4.0.0)