Add Rows_examined into SHOW PROCESSLIST
Bug #589491 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 |
Fix Released
|
Undecided
|
Unassigned | ||
| 5.5 |
Fix Released
|
Medium
|
Oleg Tsarev | ||
Bug Description
Add counters into SHOW PROCESSLIST for Rows_examined, Rows_sent, Rows_read -- I'm not sure what counters are available. But I know these counters are kept for each query locally, because they are written to the slow query log. It would be very helpful to expose them in SHOW PROCESSLIST so they could be used for estimating things such as the progress and estimated completion time of a query.
Related branches
lp:~percona-dev/percona-server/bug589491
- Valentine Gostev (community): Approve (qa)
- Fred Linhoss (community): Approve (documentation)
- Alexey Kopytov (community): Approve
-
Diff: 436 lines (+353/-10)7 files modifiedmysql-test.diff (+82/-4)
mysql-test/processlist_row_stats.patch/percona_processlist_row_stats.result (+72/-0)
mysql-test/processlist_row_stats.patch/percona_processlist_row_stats.test (+88/-0)
mysql-test/query_cache_enhance.patch/percona_status_wait_query_cache_mutex.result (+5/-5)
mysql-test/query_cache_enhance.patch/percona_status_wait_query_cache_mutex.test (+1/-1)
processlist_row_stats.patch (+104/-0)
series (+1/-0)
lp:~percona-dev/percona-server/5.5.9
(Merged)
Revision history for this message
| Vadim Tkachenko (vadim-tk) wrote | #1 |
| 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: | |
| milestone: | 5.1-12.0 → 5.1-13.0 |
Revision history for this message
| Vadim Tkachenko (vadim-tk) wrote | #2 |
Revision history for this message
| Vadim Tkachenko (vadim-tk) wrote | #3 |
| Changed in percona-server: | |
| status: | Triaged → Won't Fix |
| importance: | Medium → Undecided |
| assignee: | Oleg Tsarev (tsarev) → nobody |
| milestone: | 5.5-20.1rc → none |
Revision history for this message
| Stewart Smith (stewart) wrote | #4 |
Revision history for this message
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #5 |
To post a comment you must log in.
The same for INFORMATION_