Hi Support Team,
We are using XI 5.4.3 on Linux.
We moved our XI server to a new VM with exactly the same resources (i.e. mem/cpu..) When we moved to new VM we see the MySQL Open Connections double and query cache Hit Rate hit critical threshold.
Any idea why? Attached is screen shot.
Thanks
MySQL Open Connections and Query Hit Rate
MySQL Open Connections and Query Hit Rate
You do not have the required permissions to view the files attached to this post.
Re: MySQL Open Connections and Query Hit Rate
/usr/local/nagios/var/nagios.log will contain the checks that are being run.
The cache rate CRITICAL message was likely there for a while since by default it will show CRITICAL if the query cache hit rate is less than 80%. Having a query pull results from the cache is generally a good thing.
The cache rate CRITICAL message was likely there for a while since by default it will show CRITICAL if the query cache hit rate is less than 80%. Having a query pull results from the cache is generally a good thing.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.