----------------------------------------------------------------------- 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)