MySQL Bugs: #33307: mysqldump should allow custom setting of long_query

Bug #33307	mysqldump should allow custom setting of long_query_time
Submitted:	18 Dec 2007 1:20	Modified:	19 Dec 2007 18:11
Reporter:	J Rabbit	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: mysqldump Command-line Client	Severity:	S4 (Feature request)
Version:	5.0.51	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Currently every time I backup my server, it adds records to the slow query log for the backup SELECT statements. I know these take a long time and don't expect that to change - I'd rather they didn't polute the log every night.

How to repeat:
n/a

Suggested fix:
Support a --long-query-time option on mysqldump that set the corresponding session variable, so that the threshold for slow queries during a backup can be set much higher than the server default. Also support this option in the [mysqldump] section of my.cnf

Many thanks for writing a bug report.