MySQL Server is running out of memory when mysqldump is backing up stored procedures
(Doc ID 1667987.1)
Last updated on JULY 24, 2016
Applies to:MySQL Server - Version 5.6 and later
Information in this document applies to any platform.
Linux server with MySQL 5.6 instance was running out of memory when mysqldump was run 2 consecutive nights in a row.
Upon review of the General Query log and /var/log/messages, it was found that when mysqldump ran, the server would kill mysqld as a result of an OOM condition.
Analysis of a top output run every 10 seconds found that during mysqldump, the memory usage would spike 12-13GB in 20 seconds.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document