Under review

Heavy join rate value

9 years ago • updated by 9 years ago • 2

Hello,

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?

Vote

Replies 2
Oldest first
- Newest first
- Oldest first

Under review

9 years ago

Hi,

It's a percent of heavy (full join, range check and scan) operations

9 years ago

Thanks Ilya, can I improve on this by tweaking the mysql configuration variables in my.cnf ?

Customer support service by UserEcho