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 | <cron user> | localhost | <db name> | Query | 305690 | Executing | CHECK TABLE `<table name>` EXTENDED CHANGED | 0.000 |
| 23567 | <cron user> | localhost | <db name> | Query | 219929 | Executing | CHECK TABLE `<table name>` EXTENDED CHANGED | 0.000 |
| 38185 | <cron user> | localhost | <db name> | Query | 133529 | Executing | CHECK TABLE `<table name>` EXTENDED CHANGED | 0.000 |
| 57790 | <cron user> | localhost | <db name> | Query | 47127 | Executing | CHECK TABLE `<table name>` 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
