Details
-
Task
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
None
Description
Percona server has some useful InnoDB status information in the slow query log.
The Percona Performance Monitor can provide useful graphs from these
This task is to add some of the most useful ones, but with less code.
The code should also be engine independent, so that it is easy to add
monitoring of other engines!
The current task will add the following new information to the slow query log if enabled with
--log-slow-verbosity=innodb
# Pages_accessed: 184 Pages_read: 95 Pages_updated: 0 Undo_rows_read: 1 |
# Pages_read_time: 17.0204 Engine_time: 248.1297 |
Engine_time is how many milliseconds is spent inside engine calls (similar as with analyze).
Page_* variables are for now only for InnoDB.
Attachments
Issue Links
- causes
-
MDEV-30875 main.analyze_stmt_orderby/rowid_filter_innodb/explain_json_format_partitions (+ 7 more) fails on Launchpad armhf builders
-
- Closed
-
-
-
- Closed
-
-
-
- Stalled
-
-
-
- Closed
-
- relates to
-
-
- Closed
-
-
-
- Stalled
-
-
-
- Closed
-
(2 relates to)
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description |
Percona server has some useful InnoDB status information in the slow query log.
The Percona Performance Monitor can provide useful graphs from these This task is to add some of the most useful ones, but with less code. The code should also be engine independent, so that it is easy to add monitoring of other engines! The current task will add the following new information to the slow query log if enabled with --log-slow-verbosity=innodb # Pages_accessed: 17 Pages_reads: 10 Pages_updated 0 # Pages_io_time 1.2767 Engine_time: 34.0872 Engine_time is how many milliseconds is spent inside engine calls (similar as with analyze). Page_* variables are for now only for InnoDB. |
Percona server has some useful InnoDB status information in the slow query log.
The Percona Performance Monitor can provide useful graphs from these This task is to add some of the most useful ones, but with less code. The code should also be engine independent, so that it is easy to add monitoring of other engines! The current task will add the following new information to the slow query log if enabled with --log-slow-verbosity=innodb {code:java} # Pages_accessed: 17 Pages_reads: 10 Pages_updated 0 # Pages_io_time 1.2767 Engine_time: 34.0872 {code} Engine_time is how many milliseconds is spent inside engine calls (similar as with analyze). Page_* variables are for now only for InnoDB. |
| Description |
Percona server has some useful InnoDB status information in the slow query log.
The Percona Performance Monitor can provide useful graphs from these This task is to add some of the most useful ones, but with less code. The code should also be engine independent, so that it is easy to add monitoring of other engines! The current task will add the following new information to the slow query log if enabled with --log-slow-verbosity=innodb {code:java} # Pages_accessed: 17 Pages_reads: 10 Pages_updated 0 # Pages_io_time 1.2767 Engine_time: 34.0872 {code} Engine_time is how many milliseconds is spent inside engine calls (similar as with analyze). Page_* variables are for now only for InnoDB. |
Percona server has some useful InnoDB status information in the slow query log.
The Percona Performance Monitor can provide useful graphs from these This task is to add some of the most useful ones, but with less code. The code should also be engine independent, so that it is easy to add monitoring of other engines! The current task will add the following new information to the slow query log if enabled with --log-slow-verbosity=innodb {code:java} # Pages_accessed: 17 Pages_reads: 10 Pages_updated: 0 # Pages_read_time 1.2767 Engine_time: 34.0872 {code} Engine_time is how many milliseconds is spent inside engine calls (similar as with analyze). Page_* variables are for now only for InnoDB. |
| Description |
Percona server has some useful InnoDB status information in the slow query log.
The Percona Performance Monitor can provide useful graphs from these This task is to add some of the most useful ones, but with less code. The code should also be engine independent, so that it is easy to add monitoring of other engines! The current task will add the following new information to the slow query log if enabled with --log-slow-verbosity=innodb {code:java} # Pages_accessed: 17 Pages_reads: 10 Pages_updated: 0 # Pages_read_time 1.2767 Engine_time: 34.0872 {code} Engine_time is how many milliseconds is spent inside engine calls (similar as with analyze). Page_* variables are for now only for InnoDB. |
Percona server has some useful InnoDB status information in the slow query log.
The Percona Performance Monitor can provide useful graphs from these This task is to add some of the most useful ones, but with less code. The code should also be engine independent, so that it is easy to add monitoring of other engines! The current task will add the following new information to the slow query log if enabled with --log-slow-verbosity=innodb {code:java} # Pages_accessed: 184 Pages_read: 95 Pages_updated: 0 Undo_rows_read: 1 # Pages_read_time: 17.0204 Engine_time: 248.1297 {code} Engine_time is how many milliseconds is spent inside engine calls (similar as with analyze). Page_* variables are for now only for InnoDB. |
| Description |
Percona server has some useful InnoDB status information in the slow query log.
The Percona Performance Monitor can provide useful graphs from these This task is to add some of the most useful ones, but with less code. The code should also be engine independent, so that it is easy to add monitoring of other engines! The current task will add the following new information to the slow query log if enabled with --log-slow-verbosity=innodb {code:java} # Pages_accessed: 184 Pages_read: 95 Pages_updated: 0 Undo_rows_read: 1 # Pages_read_time: 17.0204 Engine_time: 248.1297 {code} Engine_time is how many milliseconds is spent inside engine calls (similar as with analyze). Page_* variables are for now only for InnoDB. |
Percona server has some useful InnoDB status information in the slow query log.
The Percona Performance Monitor can provide useful graphs from these This task is to add some of the most useful ones, but with less code. The code should also be engine independent, so that it is easy to add monitoring of other engines! The current task will add the following new information to the slow query log if enabled with --log-slow-verbosity=innodb {code:java} # Pages_accessed: 184 Pages_read: 95 Pages_updated: 0 Undo_rows_read: 1 # Pages_read_time: 17.0204 Engine_time: 248.1297 {code} Engine_time is how many milliseconds is spent inside engine calls (similar as with analyze). Page_* variables are for now only for InnoDB. |
| Priority | Major [ 3 ] | Critical [ 2 ] |
| Link |
This issue relates to |
| Link | This issue relates to MDEV-31589 [ MDEV-31589 ] |
| Fix Version/s | 10.11 [ 27614 ] | |
| Fix Version/s | 11.0 [ 28320 ] | |
| Fix Version/s | 10.11.5 [ 29019 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Fix Version/s | 10.6.15 [ 29013 ] | |
| Fix Version/s | 10.11 [ 27614 ] | |
| Fix Version/s | 11.0 [ 28320 ] |
| issue.field.resolutiondate | 2023-07-07 11:45:38.0 | 2023-07-07 11:45:38.761 |
| Fix Version/s | 10.9.8 [ 29015 ] | |
| Fix Version/s | 10.10.6 [ 29017 ] | |
| Fix Version/s | 10.11.5 [ 29019 ] | |
| Fix Version/s | 10.8.8 [ 28518 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Fix Version/s | 10.8.8 [ 28518 ] |
| Link | This issue is part of TODO-4054 [ TODO-4054 ] |
| Link | This issue is part of TODO-4054 [ TODO-4054 ] |
| Link |
This issue causes |
| Link |
This issue causes |
| Link | This issue causes MDEV-32910 [ MDEV-32910 ] |
| Link |
This issue relates to |
| Link |
This issue causes |
| Link | This issue relates to MENT-2066 [ MENT-2066 ] |