[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