MySQL consume cpu

[dimsum]

Hi,

I have run an XI it's smoothly when the last 2days I got a MySQL to consume a CPU too hight. no error log in MariaDB but I saw some of file in /var/lib/mysql/nagiosxi/xi_meta.ibd is looking abnormal. please find the pictures.

Also, I use ramdisk but no luck.

Any idea please let me know.

Thank you.

[scottwilkerson]

this definitely doesn't look correct.

Lets run the following to clear some of these tables that should be pulling temp data:

Code: Select all

killall -9 php
systemctl restart mariadb
echo "truncate table xi_events; truncate table xi_meta; truncate table xi_eventqueue;" | mysql -u root -pnagiosxi nagiosxi

[dimsum]

It worked.

Thanks!

[scottwilkerson]

It worked.

Thanks!

Great!

Locking thread