Aikesheng Open Source Community
Mar 12, 2024 · Databases
Resolving MySQL OOM Caused by Triggers and table_open_cache_instances
This article analyzes a MySQL replica that repeatedly ran out of memory due to large triggers and a high table_open_cache_instances setting, demonstrates how to reproduce the issue with test scripts, and provides a practical fix by reducing the parameter to mitigate OOM.
DatabasePerformance TuningTriggers
0 likes · 9 min read