Article 5HC7D Slackware-current + MariaDB 10.6.0 = High CPU load

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.latest?d=yIl2AUoC8zA latest?i=XI-lYc64yAA:t1YntroYqfg:F7zBnMy latest?i=XI-lYc64yAA:t1YntroYqfg:V_sGLiP latest?d=qj6IDK7rITs latest?i=XI-lYc64yAA:t1YntroYqfg:gIN9vFwXI-lYc64yAA
External Content
Source RSS or Atom Feed
Feed Location https://feeds.feedburner.com/linuxquestions/latest
Feed Title LinuxQuestions.org
Feed Link https://www.linuxquestions.org/questions/
Reply 0 comments