Issue with "Table Definition Cache Hit Rate" Dropping to 0%

[drupaladmin]

I’m reaching out regarding an issue we’re experiencing with Releem’s agent monitoring. Specifically, the "Table Definition Cache Hit Rate" parameter randomly drops to 0%. This behavior persists until we reboot the system, after which the hit rate returns to normal. However, the issue reappears within a day or so after the reboot.

I’ve investigated this issue, and I strongly suspect the problem lies within the Releem agent rather than MariaDB itself. Could you please provide insights into what might be causing this behavior? Are there any known issues or updates related to this parameter or the agent?

Your assistance in diagnosing and resolving this would be greatly appreciated. Please let me know if there’s any additional information or logs I can provide to help troubleshoot.

Looking forward to your response.

[drupaladmin]

We've found the issue with this health check.
The root cause of the issue is Open Table Definitions and Opened Table Definitions are calculated for the 1 day. And when MySQL opened all table definitions, Open Table Definitions for the 1 day might be 0.

We'll fix it soon.