Bug #45166 Query Cache invalidated row count should show in 'show status'

• Submitted: 28 May 2009 18:35
• Modified: 4 Jul 2010 21:02
• Reporter: Andrew Hutchings
• Status: Patch pending
• Category: MySQL Server: General
• Severity: S4 (Feature request)
• OS: Any
• Assigned to: Geir Høydalsvik
• CPU Architecture: Any
• Tags: Contribution

[28 May 2009 18:35] Andrew Hutchings

Description:
SHOW STATUS does not have a count for invalidated queries.  This could be useful to help diagnose problems related to poor query cache usage.

How to repeat:
SHOW STATUS

Suggested fix:
Patch to be attached shortly

[28 May 2009 18:36] Andrew Hutchings

Patch to give status variable + tests

Attachment: mysql-5.1.34-qcache-invalid-status.patch (text/x-patch), 9.44 KiB.

[27 Mar 2010 10:03] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/104498

3128 Andrew Hutchings	2010-03-27
      Bug #45166	Query Cache invalidated row count should show in 'show status'
      
      Add status variable Qcache_queries_invalidated which contains a count of queries invalidate from query cache

[4 Jul 2010 20:32] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/112849

[4 Jul 2010 21:02] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/112850

3098 Andrew Hutchings	2010-07-04
      Bug #45166	Query Cache invalidated row count should show in 'show status'
      
      Add Qcache_queries_removed counter which contains a count of queries removed from the query cache