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)