Comments - Aggregating data with help tables will raise open table cache - solution?
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
The problem isn't explained clearly. table_open_cache is a system variable that you can set. It will not change. opened_tables is the status variable that will increase over time, but preferably slowly - see Optimizing table_open_cache. But you don't indicate if it's just this that is the problem, or if you are experiencing performance problems, and if so, where exactly.