0
Answered

How do I troubleshoot?

folioguru 7 years ago updated by Konstantin (Here to help) 7 years ago 1
I finally set up mysql database monitor and got first report back.  It is full of errors and warnings.  At the bottom of the page it says: "Please visit Anturis Console to troubleshoot.".  How do I begin to troubleshoot this items? 

Examples:

Error : On-disk temporary table rate value 44.0 % should be less than 20.0 % . Expression is 12
Error: Query cache miss rate value 100.0 % should be less than 20.0 % . Expression is 12
Error : Innodb buffer pool miss rate value None % should be less than 20.0 % . Expression is 12


Hi!

Looks like you are running MySQL v4.* (you can check this with mysql --version). We mainly support v5.*. So in the Monitor configuration you can uncheck all the variables for which the value is 'none'.

Regarding other variables it depends on how you use the DB. Those values may be normal for you or you may need to optimize. Typical advices can be found in the Internet. E.g. herehere or here.

Thanks.