[ERROR] 1 client is using or hasn't closed the table properly

zxf5420

mysql服务器出现了load值过高,内存使用率也很高，查看下原因，mysql 错误日志报出了一大堆错误，但之后我也没去做任何处理，又恢复正常了，第二天又出现同一问题了，请大家来帮忙看下这问题。
121207  3:00:06 [ERROR] /app/mysql/bin/mysqld: Table './resource/t_driver_rom' is marked as crashed and should be repaired
121207  3:00:06 [Warning] Checking table:   './resource/t_driver_rom'
121207  3:00:06 [ERROR] 1 client is using or hasn't closed the table properly
121207  3:00:06 [ERROR] /app/mysql/bin/mysqld: Table './resource/t_driver_mobile_leak' is marked as crashed and should be repaired
121207  3:00:06 [Warning] Checking table:   './resource/t_driver_mobile_leak'
121207  3:00:06 [ERROR] 1 client is using or hasn't closed the table properly
121207  3:00:07 [ERROR] /app/mysql/bin/mysqld: Table './resource/t_android_info' is marked as crashed and should be repaired
121207  3:00:07 [Warning] Checking table:   './resource/t_android_info'
121207  3:00:07 [Warning] Recovering table: './resource/t_android_info'
121207  3:00:08 [ERROR] /app/mysql/bin/mysqld: Table './resource/SoftContent' is marked as crashed and should be repaired
121207  3:00:08 [Warning] Checking table:   './resource/SoftContent'
121207  3:00:08 [Warning] Recovering table: './resource/SoftContent'
121207  3:00:10 [ERROR] /app/mysql/bin/mysqld: Table './resource/SoftAdviser' is marked as crashed and should be repaired
121207  3:00:10 [Warning] Checking table:   './resource/SoftAdviser'
121207  3:00:10 [Warning] Recovering table: './resource/SoftAdviser'
121207  3:00:10 [ERROR] /app/mysql/bin/mysqld: Table './resource/GameInfo' is marked as crashed and should be repaired
121207  3:00:10 [Warning] Checking table:   './resource/GameInfo'
121207  3:00:10 [Warning] Recovering table: './resource/GameInfo'
121207  3:00:11 [ERROR] /app/mysql/bin/mysqld: Table './resource/GameAdapt' is marked as crashed and should be repaired
121207  3:00:11 [Warning] Checking table:   './resource/GameAdapt'
121207  3:00:13 [ERROR] /app/mysql/bin/mysqld: Table './resource/t_search_keyword' is marked as crashed and should be repaired
121207  3:00:13 [Warning] Checking table:   './resource/t_search_keyword'
121207  3:00:13 [ERROR] 1 client is using or hasn't closed the table properly
121207  3:00:13 [ERROR] /app/mysql/bin/mysqld: Table './resource/ArticleInfo' is marked as crashed and should be repaired
121207  3:00:13 [Warning] Checking table:   './resource/ArticleInfo'
121207  3:00:13 [ERROR] 1 client is using or hasn't closed the table properly
121207  3:00:14 [ERROR] /app/mysql/bin/mysqld: Table './resource/t_net_game_info' is marked as crashed and should be repaired
121207  3:00:14 [Warning] Checking table:   './resource/t_net_game_info'
121207  3:00:14 [ERROR] 1 client is using or hasn't closed the table properly
121207  3:00:14 [ERROR] /app/mysql/bin/mysqld: Table './resource/softcompanys' is marked as crashed and should be repaired
121207  3:00:14 [Warning] Checking table:   './resource/softcompanys'

chenyx

数据表有问题了,mysql应该有工具,你检查下吧

zxf5420

那工具是值什么？

chenyx

不知道你的数据库引擎是 MyISAM还是innodb, MyISAM的话,可以用myisamchk来修复数据表

zxf5420

我的是myisam数据引擎的，我修复试试看，多谢你的指点。