Bug #78907 need a metric to check if range_optimizer_max_mem_size was exceeded
Submitted: 21 Oct 2015 19:23
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S4 (Feature request)
Version:5.7.9 OS:Any
Assigned to: CPU Architecture:Any

[21 Oct 2015 19:23] Shane Bester
Description:
We'd like some status variable or performance_schema instrument to count occurrences of when this happens:

| Warning | 3170 | Memory capacity of 1536000 bytes for 'range_optimizer_max_mem_size' exceeded. Range optimization was not done for this query.

How to repeat:
read http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_range_optimizer...

and

http://bugs.mysql.com/bug.php?id=78752
(Provide documentation on how to estimate range_optimizer memory usage)