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:
Category:MySQL Server: mysqldump Command-line Client Severity:S4 (Feature request)
Version:5.0.51 OS:Any
Assigned to: CPU Architecture:Any

[18 Dec 2007 1:20] J Rabbit
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:

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
[19 Dec 2007 18:11] Susanne Ebrecht
Many thanks for writing a bug report.