tmpdir Fills Up With Deleted Binary Log Cache Files Such As : "/tmp/MLvgBNsI (deleted)"

(Doc ID 1637863.1)

Last updated on OCTOBER 02, 2017

Applies to:

MySQL Server - Version 5.5 to 5.7 [Release 5.5 to 5.7]
Information in this document applies to any platform.

Symptoms

A Replication Slave that replicates LOAD DATA INFILE statements can run of out disk space in the slave-load-tmpdir or tmpdir directories.

Running lsof command will reveal files like this:

mysqld    11438  mysql 1618u      REG                8,4  4070178816      49159 /tmp/MLvgBNsI (deleted)
mysqld    11438  mysql 1630u      REG                8,4  3868622848      49161 /tmp/MLbx9Zsu (deleted)
mysqld    11438  mysql 1644u      REG                8,4  3665526784      49160 /tmp/MLyOdU7o (deleted)

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