修正laravel中Prepared statement needs to be re-prepared

最近一個案子將對方的整個DB匯出，重新匯入自己的DB後，啟動網站一直出現底下訊息
General error: 1615 Prepared statement needs to be re-prepared

看起來跟msyql本身的設定有關，在.my.cnf下加入底下設定，重新啟動即可

table_open_cache_instances=2 #http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_table_open_cache_instances
table_open_cache=16384       #http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_table_open_cache
table_definition_cache=16384 #http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_table_definition_cache
tmp_table_size=64M           #http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_tmp_table_size

join_buffer_size=512k        #http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_join_buffer_size

參考網址：
http://bugs.mysql.com/bug.php?id=42041
The Abstracts of My Brain
MySQL優化（mysql ERROR 1040 (00000): Too many connections）