Hi Pavel! This is very unlikely due to any packaging changes in Debian. I recommend you serach jira.mariadb.org if somebody has identified this upstream.
On Tue, 17 Oct 2023 at 02:18, Pavel Krejca <d...@ratliff.cz> wrote: > > Package: mariadb-server-10.5 > Version: 1:10.5.21-0+deb11u1 > Severity: normal > > Dear Maintainer, > > after upgrading from 10.5.19-0+deb11u2 to 10.5.21-0+deb11u1, execution > of one particular SELECT query became extremely slow (approx 1000 to > 10000 times). > > The configuration (server, client) remained the same. > > Before upgrade (expected): > > MariaDB [test]> SELECT ... > ... > 4 rows in set (1.014 sec) > > After upgrade (actual): > > MariaDB [test]> SELECT ... > ... > 4 rows in set (25 min 54.964 sec) > > SHOW CREATE statements of tables included in query (these are standard > WordPress tables), ANALYZE SELECT for both versions and full server > config are attached. > > All tables have ~50k to 400k rows. > > FYI, the same problem appears in latest version of MariaDB 10.11 (probably). > > Best regards, > Pavel > > -- System Information: > Debian Release: 11.8 > APT prefers oldstable-updates > APT policy: (500, 'oldstable-updates'), (500, 'oldstable-security'), > (500, 'oldstable') > Architecture: amd64 (x86_64) > > Kernel: Linux 5.10.0-25-amd64 (SMP w/4 CPU threads) > Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), > LANGUAGE=en_US:en > Shell: /bin/sh linked to /usr/bin/dash > Init: systemd (via /run/systemd/system) > > Versions of packages mariadb-server-10.5 depends on: > ii adduser 3.118+deb11u1 > ii debconf [debconf-2.0] 1.5.77 > ii galera-4 26.4.11-0+deb11u1 > ii gawk 1:5.1.0-1 > ii iproute2 5.10.0-4 > ii libc6 2.31-13+deb11u7 > ii libdbi-perl 1.643-3+b1 > ii libpam0g 1.4.0-9+deb11u1 > ii libssl1.1 1.1.1w-0+deb11u1 > ii libstdc++6 10.2.1-6 > ii lsb-base 11.1.0 > ii lsof 4.93.2+dfsg-1.1 > ii mariadb-client-10.5 1:10.5.21-0+deb11u1 > ii mariadb-common 1:10.5.21-0+deb11u1 > ii mariadb-server-core-10.5 1:10.5.21-0+deb11u1 > ii passwd 1:4.8.1-1 > ii perl 5.32.1-4+deb11u2 > ii procps 2:3.3.17-5 > ii psmisc 23.4-2 > ii rsync 3.2.3-4+deb11u1 > ii socat 1.7.4.1-3 > ii zlib1g 1:1.2.11.dfsg-2+deb11u2 > > Versions of packages mariadb-server-10.5 recommends: > ii libhtml-template-perl 2.97-1.1 > > Versions of packages mariadb-server-10.5 suggests: > pn mailx <none> > pn mariadb-test <none> > pn netcat-openbsd <none> > > -- debconf information: > mariadb-server-10.5/old_data_directory_saved: > mariadb-server-10.5/nis_warning: > mariadb-server-10.5/postrm_remove_databases: false
