修复.MYI'; try to repair it

来源：互联网发布：网络上很污的词语编辑：程序博客网时间：2024/06/09 23:12

1. 数据接收报错，数据引擎支持不好，需要优化mysql配置：

问题如下：

SQLException: Incorrect key file for table './bd_jrdb/Bond_CreditGrading.MYI'; try to repair it
SQLException: Incorrect key file for table './bd_jrdb/LC_IPODeclaration.MYI'; try to repair it

需要修复下

问题如下：

表：LC_SMAttendInfo。Could not commit JDBC transaction; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communications link failure during commit(). Transaction resolutionunknown.
表：Bond_RedemptionBBn。Could not commit JDBC transaction; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communications link failure during commit(). Transaction resolution unknown.

另外Mysql配置文件需要优化，例如my.cnf关键配置如下
innodb_log_file_size=512M
innodb_log_buffer_size=16M
max_connections = 2000
table_open_cache = 8000
max_connect_errors = 1844674407370954751
max_allowed_packet = 1G
wait_timeout = 86400

修复完以后，重启：service myqld restart.使之生效！

0 0