MySQL Bugs: #97301: Statistics for Hash Join

Bug #97301	Statistics for Hash Join
Submitted:	20 Oct 2019 17:11	Modified:	21 Oct 2019 6:22
Reporter:	Tibor Korocz	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Information schema	Severity:	S4 (Feature request)
Version:	8.0	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Hi, 

Performance Schemas has some memory information about Hash Joins but ,would be nice to have some session/global statistics for Hash Joins, like:

show global status like `%hash%`:
Select_Hash_Join = 123;

Would make it easier to monitor how many queries are using hash joins after upgrading to MySQL 8.0.18+

How to repeat:
feature request.

Suggested fix:
Add a new status metrics for Hash Joins.

Hello Tibor Korocz,

Thank you for the feature request!

regards,
Umesh