[debian-mysql] Bug#1054112: mariadb-server-10.5: extreme query slowdown since upgrade from 10.5.19 to 10.5.21

[Otto Kekäläinen]

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 <deb at 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