Bug #72418 More details on tmpdir for mysqlbinlog needed
Submitted: 22 Apr 2014 7:10 Modified: 21 Nov 2014 11:47
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.6.16 OS:Any
Assigned to: David Moss CPU Architecture:Any

[22 Apr 2014 7:10] Daniël van Eeden 
Description:
When running "mysqlbinlog -v" against a large binlog (fully row-based) the /tmp filesystem reached 100%.

The mysqlbinlog utility doesn't seem to have a --tmpdir= option. The tmpdir can be specified by the TMPDIR environment variable.

I found this solution in the comments on:
http://dev.mysql.com/doc/refman/5.6/en/recovery-from-backups.html

I found documentation about TMPDIR on this page, but it's windows specific and I'm using Linux. It also seems to be about the server, not about clients.
https://dev.mysql.com/doc/refman/5.6/en/temporary-files.html

How to repeat:
Try to find information about which tmpdir is used and how to specify an different and/or additional tmpdir for mysqlbinlog
[22 Apr 2014 9:19] MySQL Verification Team 
Hello Daniel,

Thank you for the report.

Thanks,
Umesh
[18 Sep 2014 13:19] Jon Stephens 
David volunteered to take this one. :)
[21 Nov 2014 11:47] David Moss 
Thanks for your feedback. The mysqlbinlog documentation for versions 5.0 through 5.7 has been updated with the following addition:
When running mysqlbinlog against a large binary log, be careful that the filesystem has enough space for the resulting files. To configure the directory that mysqlbinlog uses for temporary files, use the TMPDIR environment variable.
[21 Nov 2014 11:49] David Moss 
Posted by developer:
 
Thanks for your feedback. The mysqlbinlog documentation for versions 5.0 through 5.7 has been updated with the following addition:
When running mysqlbinlog against a large binary log, be careful that the filesystem has enough space for the resulting files. To configure the directory that mysqlbinlog uses for temporary files, use the TMPDIR environment variable.
[1 Jan 2016 12:12] MySQL Verification Team 
doesn't this work?
 -l, --local-load=name
                     Prepare local temporary files for LOAD DATA INFILE in the
                     specified directory.