Under review

Heavy join rate value

Alexandre Plennevaux 6 years ago updated by pixeline 6 years ago 2

I keep getting this signal from my mysql monitor : "Threshold check on (server). Heavy join rate value 110.0 % should be less than 20.0 % . Expression is 1.67". I don't find much info on the internet about it. Can you help me understand what it means and what should I do to address it?
Under review

It's a percent of heavy (full join, range check and scan) operations
Thanks Ilya, can I improve on this by tweaking the mysql configuration variables in my.cnf ?