Bug #60084 add an option to mysqlbinlog to skip writing LOAD DATA temporary files
Submitted: 10 Feb 2011 10:51
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Replication Severity:S4 (Feature request)
Version:5.5 OS:Any
Assigned to: Assigned Account CPU Architecture:Any

[10 Feb 2011 10:51] Shane Bester 
Description:
currently mysqlbinlog has an option that lets you specific the --local-load directory input to place load data infile files.

this is a feature request to have an option that will disable creating those SQL_LOAD_MB* files completely.  if one is simply preprocessing or auditing the binary logs, just the statements are needed, and not the actual data files.

How to repeat:
.

Suggested fix:
add an option to disable the creating of SQL_LOAD_MB* files when a load data event is seen.
[28 Feb 2011 7:18] MySQL Verification Team 
this option would be useful for folks doing this such as this:
http://ronaldbradford.com/blog/part-2-simple-lessons-in-improving-scalability-2011-02-24/
[28 Feb 2011 7:42] Simon Mudd 
See also: http://blog.wl0.org/2010/10/how-analysing-your-binlogs-can-be-quite-informative/