Hi,
I am integrating SNMP traps to icinga2 using snmptrapd and snmptt. It's working
perfectly fine for one host.
Icinga2 configuration files look as below:
==commands.conf file content
object Service "cmc_traps" {
import "generic-service"
host_name = "10.206.41.16"
Have you tried to usual MySQL tuning advisors?
http://mysqltuner.pl
https://github.com/RootService/tuning-primer
Is it possible to upgrade to a more recent MySQL version? Maybe 5.5 or
better 5.6 or even 5.7?
What about Disk I/O on the host? do you have I/O waits?
2016-07-01 15:45 GMT+02:00 Dia
Hello Antony,
so this is interesting… I stopped icinga2 service and mysqld, I added in the
[mysqld] section of /etc/my.cnf the following two lines
slow-query-log = 1
slow-query-log-file = /var/log/mysql-slow-query.log
Then I touched /var/log/mysql-slow-query.log and change the ownership to my
Hello Antony,
so both the machines (they are identical) have 2 CPU (CPU E5-2620 v3 @ 2.40GHz)
with 6 core per processor, so a total of 12 CPU cores.
I assumed that the test machine is swapping a lot due to MySQL not able to cope.
The majority of the process are run by root and they are on both nod