MySQL is using a lot of CPU

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
neodg
Posts: 31
Joined: Wed Jul 10, 2013 11:56 am

MySQL is using a lot of CPU

Post by neodg »

Hi Experts,

MySQL is using a lot of CPU and also Could you please share, what maintenance activity needs to be performed on Nagios for effective performance.
abrist
Red Shirt
Posts: 8334
Joined: Thu Nov 15, 2012 1:20 pm

Re: MySQL is using a lot of CPU

Post by abrist »

First and foremost, run a repair on both of your mysql dbs:

Code: Select all

/usr/local/nagiosxi/scripts/repairmysql.sh nagios
/usr/local/nagiosxi/scripts/repairmysql.sh nagiosql
Former Nagios employee
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
neodg
Posts: 31
Joined: Wed Jul 10, 2013 11:56 am

Re: MySQL is using a lot of CPU

Post by neodg »

Hi Experts,

1. Have done with the basic level troubleshooting and executed the commands, but still its utilizing high memory and CPU.
2. Could you share information, how many people can access/login to the system at the same time ?

Its bit urgent

Sharath
User avatar
lmiltchev
Bugs find me
Posts: 13589
Joined: Mon May 23, 2011 12:15 pm

Re: MySQL is using a lot of CPU

Post by lmiltchev »

You have opened a new support ticket in our system. We will continue communicating via email. I am locking this topic.
Be sure to check out our Knowledgebase for helpful articles and solutions!
Locked