My Oracle Support Banner

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.