views:

15

answers:

0

Hi,

Im recording slow queries longer than 2 seconds. That is running fine except, the daily backups also get recorded in slow log because 1) mysqldump calls select * from xyz (big table); and 2) when inserting the backup into a new db (yesterday's backup, sundays backup, etc). How to prevent mysqldump from logging slow queries? Is there a temporary way to switch off slow logging when backup is in progress? Please suggest.

Thanks, Vikas