[Gllug] MySQL question: "WARNING: mysqlcheck has found corrupt tables"
Richard Jones
rich at annexia.org
Mon Jun 12 14:02:36 UTC 2006
I just got this warning message (below) from the only one of our
servers which is running MySQL -- unfortunately it has to because
Wordpress requires it. Is this something I should worry about?
Rich.
----- Forwarded message -----
Subject: WARNING: mysqlcheck has found corrupt tables
wordpress.wp_categories
warning : 1 client is using or hasn't closed the table properly
wordpress.wp_comments
warning : 1 client is using or hasn't closed the table properly
wordpress.wp_options
warning : 1 client is using or hasn't closed the table properly
wordpress.wp_post2cat
warning : 1 client is using or hasn't closed the table properly
wordpress.wp_postmeta
warning : 1 client is using or hasn't closed the table properly
wordpress.wp_posts
warning : 1 client is using or hasn't closed the table properly
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 |
+----+------------------+-----------+----+---------+------+-------+------------------+
| 5 | debian-sys-maint | localhost | | Query | 0 | | show processlist |
+----+------------------+-----------+----+---------+------+-------+------------------+
Uptime: 1 Threads: 1 Questions: 30 Slow queries: 0 Opens: 22 Flush tables: 1 Open tables: 16 Queries per second avg: 30.000
----- End forwarded message -----
--
Richard Jones, CTO Merjis Ltd.
Merjis - web marketing and technology - http://merjis.com
Team Notepad - intranets and extranets for business - http://team-notepad.com
--
Gllug mailing list - Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug
More information about the GLLUG
mailing list