does it make sense to flush all open tables in scheduled times? (maybe crontab)
our database got much statements from our CMS portal every 10min. the open_tables value (512) inreases very fast in a few days finally until to the limit. so mysql starting to use tmp. tables.
I understand the mysql “open_table_cache” as follows:
mysql try to hold tables which are opened by any statement in the cache to save time by reopen it, right? so tehe open_table value normally is increasing an mysql keep the tables in cache for lifetime or until reboot…
but maybe this isnt´n nessecary. for an application (intranet) and CMS (database-syncs) which are sending a lot queries on different tables with differnt users, the table cache will reach the limit very fast. so what is better, to increase the open table limit or sending a flush table ever week?
thanks for every idea!!!
i hope you understand my english - its not the best confused: