MySQL Bugs: #78907: need a metric to check if range_optimizer_max_mem

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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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)