mysql [Warning] max_join_size报错问题解决办法

文章介绍了关于mysql [Warning] max_join_size报错问题解决办法,有需要的同学看看.

1. 10071606:32:45mysqldstarted
2. 1007166:32:45[Warning]option'max_join_size':unsignedvalue18446744073709551615adjustedto4294967295
3. 1007166:32:45[Warning]option'max_join_size':unsignedvalue18446744073709551615adjustedto4294967295
4. InnoDB:Thelogsequencenumberinibdatafilesdoesnotmatch
5. InnoDB:thelogsequencenumberintheib_logfiles!
6. 1007166:32:45InnoDB:Databasewasnotshutdownnormally!
7. InnoDB:Startingcrashrecovery.
8. InnoDB:Readingtablespaceinformationfromthe.ibdfiles...
9. 10071606:36:23mysqldended --phpfensi.com

服务器上mysql 启动,报错不能启动,如上面日志.

解决办法:etc下的my.cnf配置文件里添加上如下代码:

max_join_size=4294967295,反正我是这样解决了问题.