Page 1 of 1

MySQL Open Connections and Query Hit Rate

Posted: Wed Jun 21, 2017 9:00 am
by brdr
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

Re: MySQL Open Connections and Query Hit Rate

Posted: Wed Jun 21, 2017 12:03 pm
by cdienger
/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.