Bug #37545 Reduce size of the blob field logged in slow query log
Submitted: 20 Jun 2008 13:02
Reporter: Bogdan Kecman Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Logging Severity:S4 (Feature request)
Version:5.0, 5.1, 6.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: BLOB, slow query log

[20 Jun 2008 13:02] Bogdan Kecman
Slow query log stores full query hence if query was used to insert a large  content, the whole content of the blob field will be stored in the log (many MB per query)

How to repeat:
turn on slow query log
insert a big blob field into table
look at the log

Suggested fix:
limit the size of the blob field displayed in the log (1-10K) or add possibility to control behaviour (variable that will define how much of the blob will be stored in slow log)