Add a new thread status for the query cache mutex

Bug #589484 reported by Baron Schwartz on 2010-06-04
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to
Fix Released
Oleg Tsarev

Bug Description

One of the reasons people don't realize that the query cache is causing them serious trouble is that they don't see a SHOW PROCESSLIST full of queries in status "Waiting on query cache mutex." As long as we're building the server with the query cache enabled, I believe we should at least ship it with a way to see if something is waiting for the mutex. I suggest setting thd->status to "Waiting on query cache mutex" just before all operations on that mutex. Then it will be blindingly obvious that the query cache is the problem, and people can solve their own performance issues instead of having to hire expert help.

affects: percona-patches → percona-server
Changed in percona-server:
assignee: nobody → Oleg Tsarev (tsarev)
importance: Undecided → Wishlist
status: New → Triaged
milestone: none → 5.1-11.1
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:
importance: Wishlist → High
Oleg Tsarev (tsarev) on 2010-07-20
Changed in percona-server:
status: Triaged → In Progress
Baron Schwartz (baron-xaprb) wrote :

I don't mean Status, I mean State. Sorry ;-( So, I'd like to see something like this:

*************************** 1. row ***************************
     Id: 16838
   User: webuser
     db: website
Command: Query
   Time: 0
  State: Waiting on query cache mutex
   Info: SELECT id FROM users WHERE username="john"

Oleg Tsarev (tsarev) wrote :

I need debug build for complete this feature. After fix source code for debug build, i wiil complete.

Oleg Tsarev (tsarev) on 2010-07-22
Changed in percona-server:
status: In Progress → Triaged
status: Triaged → Fix Committed
Changed in percona-server:
status: Fix Committed → Fix Released

Percona now uses JIRA for bug reports so this bug report is migrated to:

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

Other bug subscribers