-----------------------------------------------------------------------
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)
_______________________________________________
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help : https://help.launchpad.net/ListHelp
