Add Qcache_purged status variable

Bug #376492 reported by Baron Schwartz
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Triaged
Wishlist
Unassigned

Bug Description

Add a variable (global + session) to count the number of queries purged from the cache after a data modification.

With the stock MySQL build, you can sort of calculate this by subtracting other variables from each other. But you can't see it per-query or per-session.

Then, this information should go into the slow query log, so we can see which queries result in a lot of cache turnover.

Changed in percona-patches:
importance: Undecided → Wishlist
affects: percona-patches → percona-server
Changed in percona-server:
assignee: nobody → Oleg Tsarev (tsarev)
status: New → Won't Fix
milestone: none → 5.1-11.1
status: Won't Fix → Triaged
Changed in percona-server:
milestone: 5.1-11.1 → 5.1-12.0
Changed in percona-server:
milestone: 5.1.47-12.0 → 5.1-12.0
Changed in percona-server:
milestone: 5.1-12.0 → 5.1-13.0
Changed in percona-server:
milestone: 5.1-13.0 → none
Stewart Smith (stewart)
Changed in percona-server:
assignee: Oleg Tsarev (tsarev) → nobody
Stewart Smith (stewart)
tags: added: slow-extended
tags: added: query-cache-extended
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2294

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.