tag:blogger.com,1999:blog-4186074565961060437.post2311992565856596124..comments2024-01-30T19:03:09.916-07:00Comments on The Abstracts of My Brain: MySQL: Prepared statement needs to be re-preparedUnknownnoreply@blogger.comBlogger1125tag:blogger.com,1999:blog-4186074565961060437.post-32415772086607305732015-01-15T14:28:08.511-07:002015-01-15T14:28:08.511-07:00From my guru:
Too high values might crash the ser...From my guru:<br /><br />Too high values might crash the server, so before changing the cache try the following.<br /><br />Open /etc/my.cnf and add<br /><br />table_open_cache_instances = 2<br />Restart Mysql.. If you still get the error, than add<br /><br />table_open_cache = 16384<br />table_definition_cache = 16384<br /><br />and again restart Mysql<br /><br />my actual values are 912 & 1024 and first solution is working.Césarhttps://www.blogger.com/profile/18322264564143805790noreply@blogger.com