MySQL Server is running out of memory when mysqldump is backing up stored procedures
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms