Sample Header Ad - 728x90

mysqldump select queries appearing in slow query log after upgrade

4 votes
2 answers
1374 views
We recently upgraded from MariaDB 5.5 to MariaDB 10.5 Since doing so, we have a couple of select queries appearing in the slow query log when we backup databases using mysqldump. One of the tables is an InnoDB table with 125,000 records. The other is a MyISAM table with 220,000 records. I guess this might not seem like any great concern, however for many years we never had anything in the slow query log related to mysqldump. So I am wondering if we should be worried? Did the behaviour of mysqldump change between versions 5.5 and 10.5, or could there be some other local setting that we perhaps had optimsied previously, that now isn't? Our slow query time is set to 5 seconds, which is what it was previously. The offending queries are taking just under 6 seconds.
Asked by MrCarrot (141 rep)
Feb 2, 2021, 07:45 PM
Last activity: Nov 1, 2023, 01:50 PM