MySQL Bugs: #37545: Reduce size of the blob field logged in slow query log

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:	None
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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
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)