Store the last query executed on each connection
Bug #732565 reported by
Baron Schwartz
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Percona Server moved to https://jira.percona.com/projects/PS |
Triaged
|
Wishlist
|
Unassigned | ||
Bug Description
It would often be very helpful to know what the last thing a connection did was. A sleeping thread that is holding a transaction, for example, is very hard to debug unless you have full logging enabled. I'd like an I_S table that holds the last query each connection executed, along with the types of things the processlist shows (user, host, time, query timestamp, ...) When a connection closes, the query should be deleted.
Or, should we make this as a feature of our ring-buffer idea?
| Changed in percona-server: | |
| importance: | Undecided → Wishlist |
| status: | New → Confirmed |
Revision history for this message
| Baron Schwartz (baron-xaprb) wrote Re: [Bug 732565] Re: Store the last query executed on each connection | #1 |
| Changed in percona-server: | |
| status: | Confirmed → Triaged |
Revision history for this message
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #2 |
To post a comment you must log in.
I had another idea about this one. It would be enough to be able to see the
last write query, and even better to see all of them. And the use case is
debugging long running txns so we only care about ones that have not
committed. So maybe just being able to view the binlog cache in an IS table
would be enough.