MySQL ERROR 1615 solution, mysql ERROR error1615

MySQL ERROR 1615 solution, mysql ERROR error1615

When I tested the server combination script today, I encountered a very strange problem. Mysql reports ERROR:

ERROR 1615 (HY000): Prepared statement needs to be re-prepared

After testing, it was found that it was not a combination of server scripts. After some searches. If it turns out that the mysql variable value is not properly set, adjust the following values:

Table_open_cache 64 => 16384
Table_definition_cache 256 => 16384
Mysql & gt; set global table_open_cache = 16384;

Mysql & gt; set global table_definition_cache = 16384;

Repeat the server combination script. Everything is OK. Finally, we found that there were too many databases on this db machine. It is estimated that there were too many lock tables caused by too many open tables.