Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
Description
MDEV-31558 adds InnoDB engine stats into the slow query log.
It would be nice to include it into ANALYZE FORMAT=JSON output, too.
User interface: Extra info is printed in ANALYZE FORMAT=JSON output.
It is printed on per-table basis. table.r_engine_stats will is an object with member counters.
In current patch, it looks like this:
"table": { |
"table_name": "t1", |
...
|
"r_engine_stats": { |
"pages_accessed": integer, |
"pages_updated" : integer, |
"pages_read_count" : integer, |
"pages_read_time_ms" : double_val, |
"old_rows_read" : integer, |
},
|
...
|
Only non-zero members are printed.
mysql-test/include/analyze-format.inc is adjusted to mask the entire contents of r_engine_stats.
Attachments
Issue Links
- causes
-
MDEV-31764 ASAN use-after-poison in trace_engine_stats upon ANALYZE FORMAT=JSON
-
- Closed
-
- relates to
-
-
- Confirmed
-
-
-
- Closed
-
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Link |
This issue relates to |
| Assignee | Sergei Petrunia [ psergey ] |
| Fix Version/s | 10.11 [ 27614 ] |
| Description |
It would be nice to include it into ANALYZE FORMAT=JSON output, too. Tentative user interface: Extra info will be printed when one uses this syntax: {{ANALYZE FORMAT=JSON_EXT}} It will be printed on per-table basis. {{table.r_engine_stats}} will be an object with members. |
It would be nice to include it into ANALYZE FORMAT=JSON output, too. Tentative user interface: Extra info will be printed when one uses this syntax: {{ANALYZE FORMAT=JSON_EXT}} It will be printed on per-table basis. {{table.r_engine_stats}} will be an object with members. In current patch, it looks like this: {code:js} "table": { "table_name": "t1", ... "r_engine_stats": { "pages_accessed": integer, "pages_updated" : integer, "pages_read_count" : integer, "pages_read_time_ms" : double_val, "undo_records_read" : double_val, }, ... {code} |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Description |
It would be nice to include it into ANALYZE FORMAT=JSON output, too. Tentative user interface: Extra info will be printed when one uses this syntax: {{ANALYZE FORMAT=JSON_EXT}} It will be printed on per-table basis. {{table.r_engine_stats}} will be an object with members. In current patch, it looks like this: {code:js} "table": { "table_name": "t1", ... "r_engine_stats": { "pages_accessed": integer, "pages_updated" : integer, "pages_read_count" : integer, "pages_read_time_ms" : double_val, "undo_records_read" : double_val, }, ... {code} |
It would be nice to include it into ANALYZE FORMAT=JSON output, too. User interface: Extra info is printed in {{ANALYZE FORMAT=JSON}} output. It is printed on per-table basis. {{table.r_engine_stats}} will is an object with member counters. In current patch, it looks like this: {code:js} "table": { "table_name": "t1", ... "r_engine_stats": { "pages_accessed": integer, "pages_updated" : integer, "pages_read_count" : integer, "pages_read_time_ms" : double_val, "old_rows_read" : integer, }, ... {code} {{mysql-test/include/analyze-format.inc}} is adjusted |
| Description |
It would be nice to include it into ANALYZE FORMAT=JSON output, too. User interface: Extra info is printed in {{ANALYZE FORMAT=JSON}} output. It is printed on per-table basis. {{table.r_engine_stats}} will is an object with member counters. In current patch, it looks like this: {code:js} "table": { "table_name": "t1", ... "r_engine_stats": { "pages_accessed": integer, "pages_updated" : integer, "pages_read_count" : integer, "pages_read_time_ms" : double_val, "old_rows_read" : integer, }, ... {code} {{mysql-test/include/analyze-format.inc}} is adjusted |
It would be nice to include it into ANALYZE FORMAT=JSON output, too. User interface: Extra info is printed in {{ANALYZE FORMAT=JSON}} output. It is printed on per-table basis. {{table.r_engine_stats}} will is an object with member counters. In current patch, it looks like this: {code:js} "table": { "table_name": "t1", ... "r_engine_stats": { "pages_accessed": integer, "pages_updated" : integer, "pages_read_count" : integer, "pages_read_time_ms" : double_val, "old_rows_read" : integer, }, ... {code} Only non-zero members are printed. {{mysql-test/include/analyze-format.inc}} is adjusted to mask the entire contents of {{r_engine_stats}}. |
| Labels | analyze-stmt |
| Component/s | Optimizer [ 10200 ] | |
| Component/s | Storage Engine - InnoDB [ 10129 ] |
| Link | This issue is part of TODO-4054 [ TODO-4054 ] |
| Fix Version/s | 10.6 [ 24028 ] | |
| Fix Version/s | 10.9 [ 26905 ] | |
| Fix Version/s | 10.10 [ 27530 ] | |
| Fix Version/s | 11.0 [ 28320 ] | |
| Fix Version/s | 11.1 [ 28549 ] | |
| Fix Version/s | 11.2 [ 28603 ] | |
| Fix Version/s | 10.11.5 [ 29019 ] |
| Fix Version/s | 10.6.15 [ 29013 ] | |
| Fix Version/s | 10.9.8 [ 29015 ] | |
| Fix Version/s | 10.10.6 [ 29017 ] | |
| Fix Version/s | 11.0.3 [ 28920 ] | |
| Fix Version/s | 11.1.2 [ 28921 ] | |
| Fix Version/s | 11.2.1 [ 29034 ] | |
| Fix Version/s | 10.8.8 [ 28518 ] | |
| Fix Version/s | 10.6 [ 24028 ] | |
| Fix Version/s | 10.9 [ 26905 ] | |
| Fix Version/s | 10.10 [ 27530 ] | |
| Fix Version/s | 10.11 [ 27614 ] | |
| Fix Version/s | 11.0 [ 28320 ] | |
| Fix Version/s | 11.1 [ 28549 ] | |
| Fix Version/s | 11.2 [ 28603 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Link |
This issue causes |
| Link | This issue is part of TODO-4054 [ TODO-4054 ] |
| Link | This issue relates to MDEV-32286 [ MDEV-32286 ] |
| Link |
This issue relates to |