0
Answered

Where can I find help on fixing these MySQL Errors?

antion 10 years ago updated by Ilya (Here to help) 10 years ago 2
I'm getting reports from my Mysql agent of some errors. When I click on details, I can see what the errors are.. However, I don't know how to go about fixing them.

Is there any documentation to point me to? any other help? Perhaps there is something in the Anturis dashboard that would recommend things I can do to fix?

Here is an example of the errors Anturis is telling me

  • Heavy join rate value 13.4377038487 % should be less than 10.0 %
  • On-disk temporary table rate value 20.987654321 % should be less than 20.0 %
  • On-disk temporary table rate value 20.987654321 % should be less than 10.0 %
  • Query cache miss rate value 100.0 % should be less than 20.0 %
  • Query cache miss rate value 100.0 % should be less than 10.0 %
  • Thread cache miss rate value 100.0 % should be less than 20.0 %
  • Thread cache miss rate value 100.0 % should be less than 10.0 %
  • Innodb buffer pool usage value 99.8046875 % should be less than 90.0 %
  • Innodb buffer pool usage value 99.8046875 % should be less than 80.0 %

Any help is appreciated. Thank you

-Travis

Under review
Hello,
Heavy join rate -  it's a percent of heavy (full join, range check and scan) operations
On-disk temporary table rate - it's a percent of temporary tables that was placed on disk instead of memory
Query cache miss rate - it's a percent of select operations which missed query cache
Innodb buffer pool usage - it's a percent of innodb pool usage

Values in error description may be normal for your DB configuration and load or you may need to optimize. You can find advice for your configuration in the Internet. Example, to optimize Query Cache read this atricle http://www.databasejournal.com/features/mysql/article.php/3808841/Optimizing-the-MySQL-Query-Cache.htm