I'm Getting MySQL Error [1615] - Prepared statement needs to be re-prepared.

I'm Getting MySQL Error [1615] - Prepared statement needs to be re-prepared.

ANS:

In Real-time I was facing the issues. 

I personally suggest upping the value of table_definition_cache. it's due to executing too many large queries that this will happened.

 

Query:

SHOW VARIABLES LIKE 'table_open_cache%';

SHOW VARIABLES LIKE 'table_definition_cache%';

set global table_open_cache=8192;

set global table_definition_cache=8192;

[mysqld]

...

table_definition_cache = 8192

table_open_cache = 8192