MySQL 5.7 --> MariaDB 10.8 switch: mysqlcheck --check --extended hangs on table
1
vote
1
answer
281
views
Recently I switched from MySQL 5.7 to MariaDB 10.8 and it's been generally great as a drop-in replacement, but I've run into a problem: the process for a cron job that daily runs
/usr/bin/nice /usr/bin/ionice -c3 \
/usr/bin/mysqlcheck \
--all-databases --check --extended --check-only-changed --silent 2>&1
hangs indefinitely on one of the larger tables (981 MB). Here's the relevant output from showing the process list after four days since server restart (there's one process for each day the cron job runs):
MariaDB [(none)]> show full processlist;
+-------+--------------+-----------------+-----------+---------+--------+-----------+----------------------------------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+-------+--------------+-----------------+-----------+---------+--------+-----------+----------------------------------------------+----------+
| 7719 | | localhost | | Query | 305690 | Executing | CHECK TABLE `` EXTENDED CHANGED | 0.000 |
| 23567 | | localhost | | Query | 219929 | Executing | CHECK TABLE `` EXTENDED CHANGED | 0.000 |
| 38185 | | localhost | | Query | 133529 | Executing | CHECK TABLE `` EXTENDED CHANGED | 0.000 |
| 57790 | | localhost | | Query | 47127 | Executing | CHECK TABLE `` EXTENDED CHANGED | 0.000 |
Nothing about this appears in /var/log/mysql/
error logs.
## What next?
I'm hoping someone can point me to other things I can check to help diagnose the problem. If someone is kind enough to do so I'll update the question. Thanks!
#### OS and mariadb info
$ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 18.04.6 LTS
Release: 18.04
Codename: bionic
$ mariadb --version
mariadb Ver 15.1 Distrib 10.8.6-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
Asked by AJ Livingston
(13 rep)
Nov 22, 2022, 09:02 PM
Last activity: Feb 22, 2023, 10:09 PM
Last activity: Feb 22, 2023, 10:09 PM