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.

Symptoms

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.

Cause

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