MySQL Performance on Nagios Server

[Fred Kroeger]

Thanks - have implemented the changes & will see how it goes.
First thing I noticed is that Nagios restarts a lot faster now.

OK so now back to the original question about the MySQL monitor thresholds. Refer to the screen shot at the start of this thread. Most of the "Red" relate to cache hit rates.
Am what I'm seeing "normal" for Nagios ?

[tgriep]

It is hard to determine what is normal, every system is different.
I ran the MYSQL wizard on my system and without changing the threshold setting, I am receiving critical alerts also.
My system is function just fine. The thresholds that are arbitrary and are just a starting point and they will need to be adjusted for every system as every system is different.

I did a little searching on some of the hit rates and what they mean.
http://www.fromdual.com/innodb-variable ... -explained
https://www.percona.com/blog/2010/02/28 ... hit-ratio/
https://www.percona.com/blog/2006/06/29 ... ou-target/

[Fred Kroeger]

Thanks - I guess that's re-assuring that the default thresholds in the MySQL Wizard give you the same results.
Not being a DBA I just need to know what values are "normal" for a Nagios d/base and can then work from there if the results my system deviates dramatically from the norm.
Would appreciate if you could share what your results are as a comparison ?

[tgriep]

Some if the Hit Rates are the higher the number, the more efficient MYSQL is running and that is a good thing.
Best thing to do is get a base line after running and adjust the thresholds to what you like.
I am not a DBA either so I go on what I can find on the internet.

[Fred Kroeger]

Is there anyone at Nagios with some MySQL skills who can look at the results I posted initially and say how to improve the d/base performance?

[tgriep]

I found this link for some performance tips for MYSQL.
https://www.percona.com/blog/2014/01/28 ... tallation/
Remember, the thresholds that were selected does not mean that the performance of the database is wrong, they are just a starting point ans they will need to be adjusted.