[Sysadmin] Fwd: WARNING: mysqlcheck has found corrupt tables
David Kaufman
david at gigawatt.com
Wed Apr 25 13:51:11 CDT 2012
-------- Original Message --------
Subject: WARNING: mysqlcheck has found corrupt tables
Date: Wed, 25 Apr 2012 13:49:53 -0500 (CDT)
From: root at tron.evolt.org (root)
To: root at tron.evolt.org
www_evolt_org.cache
warning : Table is marked as crashed
warning : 2 clients are using or haven't closed the table properly
error : Record at pos: 33963960 is not remove-marked
error : record delete-link-chain corrupted
error : Corrupt
www_evolt_org.node_counter
warning : Table is marked as crashed
error : Checksum for key: 2 doesn't match checksum for records
error : Checksum for key: 3 doesn't match checksum for records
error : Checksum for key: 4 doesn't match checksum for records
error : Corrupt
www_evolt_org.sessions
warning : Table is marked as crashed
warning : 3 clients are using or haven't closed the table properly
error : Found 26935 keys of 26936
error : Corrupt
www_evolt_org.watchdog
warning : Table is marked as crashed
warning : 2 clients are using or haven't closed the table properly
error : Found 703104 keys of 703106
error : Corrupt
Improperly closed tables are also reported if clients are accessing
the tables *now*. A list of current connections is below.
+----+------------------+-----------+----+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info
|
+----+------------------+-----------+----+---------+------+-------+------------------+
| 7 | debian-sys-maint | localhost | | Query | 0 | | show
processlist |
+----+------------------+-----------+----+---------+------+-------+------------------+
Uptime: 18 Threads: 1 Questions: 298 Slow queries: 0 Opens: 276
Flush tables: 1 Open tables: 64 Queries per second avg: 16.556
More information about the Sysadmin
mailing list