Slackware-current + MariaDB 10.6.0 = High CPU load
by Lucifer4o from LinuxQuestions.org on (#5HC7D)
Hello all,
I'm facing very big issue - just upgraded to current and to MariaDB 10.6 aaand I'm having MariaDB processes using 100%.
This is what I'have in processlist
+-----+----------+-----------------+------------+---------+------+----------+------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+-----+----------+-----------------+------------+---------+------+----------+------------------+----------+
| 27 | ejabberd | 127.0.0.1:39899 | ejabberd | Sleep | 215 | | | 0.000 |
| 28 | ejabberd | 127.0.0.1:34365 | ejabberd | Sleep | 216 | | | 0.000 |
| 29 | ejabberd | 127.0.0.1:47621 | ejabberd | Sleep | 216 | | | 0.000 |
| 30 | ejabberd | 127.0.0.1:59875 | ejabberd | Sleep | 216 | | | 0.000 |
| 31 | ejabberd | 127.0.0.1:41625 | ejabberd | Sleep | 215 | | | 0.000 |
| 32 | ejabberd | 127.0.0.1:45739 | ejabberd | Sleep | 216 | | | 0.000 |
| 33 | ejabberd | 127.0.0.1:59347 | ejabberd | Sleep | 216 | | | 0.000 |
| 34 | ejabberd | 127.0.0.1:43263 | ejabberd | Sleep | 216 | | | 0.000 |
| 36 | ejabberd | 127.0.0.1:54617 | ejabberd | Sleep | 216 | | | 0.000 |
| 35 | ejabberd | 127.0.0.1:57479 | ejabberd | Sleep | 216 | | | 0.000 |
| 139 | ossec | 127.0.0.1:47846 | ossec | Sleep | 7 | | | 0.000 |
| 140 | ossec | 127.0.0.1:47850 | ossec | Sleep | 7 | | | 0.000 |
| 495 | fbgorg | 127.0.0.1:48424 | fbgorg2015 | Sleep | 259 | | | 0.000 |
| 936 | root | localhost | | Query | 0 | starting | show processlist | 0.000 |
+-----+----------+-----------------+------------+---------+------+----------+------------------+----------+
So no extra activity, but there are 5 MariaDB instances (Master holding 168% to 220% and 4 children holding around 25% to 50% CPU each).
I will try reverting to the last 10.5 but I want to upgrade to latest packages.
If you have any ideas ... please share.
I'm facing very big issue - just upgraded to current and to MariaDB 10.6 aaand I'm having MariaDB processes using 100%.
This is what I'have in processlist
+-----+----------+-----------------+------------+---------+------+----------+------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+-----+----------+-----------------+------------+---------+------+----------+------------------+----------+
| 27 | ejabberd | 127.0.0.1:39899 | ejabberd | Sleep | 215 | | | 0.000 |
| 28 | ejabberd | 127.0.0.1:34365 | ejabberd | Sleep | 216 | | | 0.000 |
| 29 | ejabberd | 127.0.0.1:47621 | ejabberd | Sleep | 216 | | | 0.000 |
| 30 | ejabberd | 127.0.0.1:59875 | ejabberd | Sleep | 216 | | | 0.000 |
| 31 | ejabberd | 127.0.0.1:41625 | ejabberd | Sleep | 215 | | | 0.000 |
| 32 | ejabberd | 127.0.0.1:45739 | ejabberd | Sleep | 216 | | | 0.000 |
| 33 | ejabberd | 127.0.0.1:59347 | ejabberd | Sleep | 216 | | | 0.000 |
| 34 | ejabberd | 127.0.0.1:43263 | ejabberd | Sleep | 216 | | | 0.000 |
| 36 | ejabberd | 127.0.0.1:54617 | ejabberd | Sleep | 216 | | | 0.000 |
| 35 | ejabberd | 127.0.0.1:57479 | ejabberd | Sleep | 216 | | | 0.000 |
| 139 | ossec | 127.0.0.1:47846 | ossec | Sleep | 7 | | | 0.000 |
| 140 | ossec | 127.0.0.1:47850 | ossec | Sleep | 7 | | | 0.000 |
| 495 | fbgorg | 127.0.0.1:48424 | fbgorg2015 | Sleep | 259 | | | 0.000 |
| 936 | root | localhost | | Query | 0 | starting | show processlist | 0.000 |
+-----+----------+-----------------+------------+---------+------+----------+------------------+----------+
So no extra activity, but there are 5 MariaDB instances (Master holding 168% to 220% and 4 children holding around 25% to 50% CPU each).
I will try reverting to the last 10.5 but I want to upgrade to latest packages.
If you have any ideas ... please share.