Nagios Support Forum

Posted: **Wed Jan 30, 2019 9:59 am**

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.

Posted: **Wed Jan 30, 2019 11:46 am**

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

Posted: **Sat Feb 02, 2019 7:43 pm**

It worked.

Thanks!

Posted: **Mon Feb 04, 2019 8:30 am**

dimsum wrote:It worked.

Thanks!

Great!

Locking thread

Nagios Support Forum

MySQL consume cpu

MySQL consume cpu

Re: MySQL consume cpu

Re: MySQL consume cpu

Re: MySQL consume cpu