tmpdir Fills Up With Deleted Binary Log Cache Files Such As : "/tmp/MLvgBNsI (deleted)"
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.
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 1630u REG 8,4 3868622848 49161 /tmp/MLbx9Zsu (deleted)
mysqld 11438 mysql 1644u REG 8,4 3665526784 49160 /tmp/MLyOdU7o (deleted)
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