Mariadb keeps burning 1 CPU core

mariadb keeps burning 1 CPU core

Since my last update of Arch Linux, there’s one running mysqld process consuming one CPU core silently. I downgraded mariadb from 11.0.2 to 10.11.4, deleted $HOME/.local/share/akonadi and recreated the akonadi database, all these to no avail.

Running :

Operating System: Arch Linux
KDE Plasma Version: 5.27.6
KDE Frameworks Version: 5.108.0
Qt Version: 5.15.10
Kernel Version: 6.4.6-arch1-1 (64-bit)

Can someone else confirm this ? Any idea for a resolution ?

Thank you.

HI,

no issue here, I’m on stable branch.

?
https://bbs.archlinux.org/viewtopic.php?id=287343

or

https://lore.kernel.org/lkml/11ded843-ac08-2306-ad0f-586978d038b1@kernel.dk/
?

[nls@h2 ~]$ sudo mariadb -v
[sudo] password for nls: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 261
Server version: 11.0.2-MariaDB Arch Linux
KDE Plasma Version: 5.27.6
KDE Frameworks Version: 5.108.0
Qt Version: 5.15.10
Kernel Version: 6.1.41-1 (64-bit)
Graphics Platform: X11
Processors: 4 × Intel® Celeron® J4115 CPU @ 1.80GHz
Memory: 7,6 GiB of RAM
Graphics Processor: Mesa Intel® UHD Graphics 600
Manufacturer: HARDKERNEL
Product Name: ODROID-H2
System Version: 1.0

Thanks for your reply.

The problem occurs on 2 machines. In the picture below, we see that one CPU core is near 100% usage in the ‘wait’ column, while the global ‘%CPU’ column reports 0. If the mysqld process receives a STOP signal, the red underlined usage drops down to 0%, and blows up to 100% again when the mysqld process receives a CONT signal.

Since this observation is repeatable on 2 machines, there’s probably a root cause since the upgrade.

I have just looked at your links, they seem to mean that the problem is not directly related to KDE. So I’ll wait for the next significant upgrades hoping it might be solved. (I should have visited your links first, sorry.)

1 Like

Thanks for your feedback, on my Web server the problem occur with obs.
I’m waiting on the next kernel update.

It’s fixed in kernel 6.4.8-arch1-1 on Arch.

2 Likes

no more one cpu on use 100%, kernel (6.1.49) or mariadb (mariadb-11.1.2-1) updates ?

Old kernels were not affected by this. It was one transient event in the 6.4.x iterations.

1 Like