Mysql---SQLException: Prepared statement needs to be re-prepared raised in Connection_executeQuery

在使用Mysql的过程中,出现一下问题:SQLException: Prepared statement needs to be re-prepared
 raised in Connection_executeQuery at src/db/Connection.c:319

通过分析和查阅资料,最终定位原因是mysql的table_open_cache太小导致,实际的table_open_cahce如下如,mysql默认的table_open_cache=64,可以通过设置:mysql> set global table_open_cache=2048

Mysql---SQLException: Prepared statement needs to be re-prepared raised in Connection_executeQuery