Correction: - with MariaDB 10.3 - 10.6 it never seems to complete at all. + with MariaDB 10.4 - 11.4 it never seems to complete at all.
On Sun, Nov 17, 2024 at 6:44 PM Gordan Bobic <[email protected]> wrote: > > I've been doing some testing with various versions of MySQL and > MariaDB regarding slow log rotation. And it looks like MariaDB (tested > 10.4, 10.5, 10.6 so far) suffers from a bug. > > Setup: > sloq_query_log=1 > long_query_time=0 > > # sysbench oltp_read_write --threads=$(nproc) > > Action: > mv slow.log slow.log.1 > > MariaDB [(none)]> flush slow logs; > > ^^ This never returns (never as in I haven't tried waiting for > 10 minutes). > > On MySQL 5.5 this is instantaneous. On 5.6 - 8.0 it takes a few > seconds, worst case I measured over the weekend is 77s, which is > pretty terrible, but with MariaDB 10.3 - 10.6 it never seems to > complete at all. > > If I kill sysbench, it completes immediately. > > On 10.3 it works, in line with MySQL 5.6 - 8.0. > > This seems like a rather significant bug. _______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]
