今天生产环境遇到一个很奇怪的问题。PHP调用存储过程的时候Mysql报1615 ERROR:
ERROR 1615 (HY000): Prepared statement needs to be re-prepared
The SQLbeing executed was : call get_object2project2('00098987-8d29-01e1-449d-8b0394443086')
经过一番搜索。发现原来是mysql的变量值设置不合理引起的,调整以下值:
table_definition_cache 256=>16384
mysql> set global table_definition_cache=16384;