Loading feed…
Percona Blog0 Hot0 comments6 min read
Stored Procedures memory consumption in Percona Server for MySQL
An investigation into unexpected memory growth in Percona Server for MySQL reveals that cursor metadata in stored procedures is never freed during repeated calls within long-lived connections. Under heavy TPC-C benchmark load (HammerDB), RSS grew from ~80GB to over 180GB over 24 hours, eventually triggering OOM kills. Memory profiling pinpointed MEM_ROOT allocations for cursor metadata as the culprit. Two practical mitigations are identified: limiting connection lifetime (with connection pooling to minimize overhead) and adding brief pauses between transactions. A bug has been filed against Percona Server. The root cause exists in both MySQL 8.4 and 9.x codebases.
Source: https://www.percona.com/blog/stored-procedures-memory-consumption-in-percona-server-for-mysql. 8sync News only summarizes and links out; content copyright belongs to the authors and original sources.
