View Single Post
  #1  
Old 18th August 2005, 00:05
m u r m u r is offline
Senior Member
 
Join Date: Jul 2005
Posts: 152
Thanks: 13
Thanked 1 Time in 1 Post
Send a message via AIM to m u r Send a message via MSN to m u r
Default mysqlcheck has found corrupt tables

I had the following errors emailed to me, can anyone translate?

ERROR EMAIL 1:

ispconfigdb.session
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: 2 Threads: 1 Questions: 65 Slow queries: 0 Opens: 57 Flush tables: 1 Open tables: 51 Queries per second avg: 32.500

ERROR EMAIL 2:

ispconfigdb.dns_nodes
warning : 1 client is using or hasn't closed the table properly
ispconfigdb.groups
warning : 1 client is using or hasn't closed the table properly
ispconfigdb.isp_dep
warning : 1 client is using or hasn't closed the table properly
ispconfigdb.isp_isp_domain
warning : 1 client is using or hasn't closed the table properly
ispconfigdb.isp_isp_kunde
warning : 1 client is using or hasn't closed the table properly
ispconfigdb.isp_isp_reseller
warning : 1 client is using or hasn't closed the table properly
ispconfigdb.isp_isp_user
warning : 1 client is using or hasn't closed the table properly
ispconfigdb.isp_isp_web
warning : 1 client is using or hasn't closed the table properly
ispconfigdb.isp_nodes
warning : 1 client is using or hasn't closed the table properly
ispconfigdb.isp_server
warning : 1 client is using or hasn't closed the table properly
ispconfigdb.isp_server_ip
warning : 1 client is using or hasn't closed the table properly
ispconfigdb.isp_traffic
warning : 1 client is using or hasn't closed the table properly
ispconfigdb.session
warning : 1 client is using or hasn't closed the table properly
ispconfigdb.sys_nodes
warning : 1 client is using or hasn't closed the table properly
ispconfigdb.sys_user
warning : 1 client is using or hasn't closed the table properly
ispconfigdb.user_groups
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: 2 Threads: 1 Questions: 65 Slow queries: 0 Opens: 57 Flush tables: 1 Open tables: 51 Queries per second avg: 32.500
Reply With Quote
Sponsored Links