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

Bug #41200	QUAN should collect qcache per-query hitrates
Submitted:	3 Dec 2008 14:38
Reporter:	Domas Mituzas
Status:	Verified
Category:	Monitoring: Agent	Severity:	S4 (Feature request)
Version:	2.0	OS:	Any
Assigned to:	Kay Roepke	Target Version:
Tags:	windmill

View
Add Comment
Files
Developer
Edit Submission
View Progress Log

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.