Add support for config: table_definition_cache and table_open_cache
Tomáš Badáň
We have more than 2000 databases with more than 500000 tables combined and we are starting to get SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared due to limitations of table_definition_cache parameter as it can only be maximum of 2000 in default mysql configuration. Can you add support to increase this value along with table_open_cache value?
As a temporary fix we have implemented application level preparations but this is not as secure as mysql preparations. This is serious security risk and it should be fixed by configuring mysql not adding workarounds.
Thank you very much!