MySQL Bugs: #41200: QUAN should collect qcache per-query hitrates

Bug #41200	QUAN should collect qcache per-query hitrates
Submitted:	3 Dec 2008 13:38
Reporter:	Domas Mituzas	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Enterprise Monitor: Agent	Severity:	S4 (Feature request)
Version:	2.0	OS:	Any
Assigned to:	Assigned Account	CPU Architecture:	Any
Tags:	windmill

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
QUAN currently does not show query-cache hitrate for specific query, though that would be useful feature.

How to repeat:
-

Suggested fix:
-

It also misses "I/O" information. while this is not directly available in MySQL internally there are various counters which pretty much proxy this type of information, even if they are on a per engine basis.

Making this information available to the proxy would be extremely useful.

Much of this information is hard to get at the moment but is a good fit for performance_schema support in the future.
Any current implementation would be too heavy-weight on the backend server on any somewhat server.