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.