host_summary
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| host | varchar(255) | Yes | NULL | |||
| statements | decimal(64,0) | Yes | NULL | |||
| statement_latency | varchar(11) | Yes | NULL | |||
| statement_avg_latency | varchar(11) | Yes | NULL | |||
| table_scans | decimal(65,0) | Yes | NULL | |||
| file_ios | decimal(64,0) | Yes | NULL | |||
| file_io_latency | varchar(11) | Yes | NULL | |||
| current_connections | decimal(41,0) | Yes | NULL | |||
| total_connections | decimal(41,0) | Yes | NULL | |||
| unique_users | bigint | No | 0 | |||
| current_memory | varchar(11) | Yes | NULL | |||
| total_memory_allocated | varchar(11) | Yes | NULL |
host_summary_by_file_io
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| host | varchar(255) | Yes | NULL | |||
| ios | decimal(42,0) | Yes | NULL | |||
| io_latency | varchar(11) | Yes | NULL |
host_summary_by_file_io_type
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| host | varchar(255) | Yes | NULL | |||
| event_name | varchar(128) | No | ||||
| total | bigint | No | ||||
| total_latency | varchar(11) | Yes | NULL | |||
| max_latency | varchar(11) | Yes | NULL |
host_summary_by_stages
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| host | varchar(255) | Yes | NULL | |||
| event_name | varchar(128) | No | ||||
| total | bigint | No | ||||
| total_latency | varchar(11) | Yes | NULL | |||
| avg_latency | varchar(11) | Yes | NULL |
host_summary_by_statement_latency
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| host | varchar(255) | Yes | NULL | |||
| total | decimal(42,0) | Yes | NULL | |||
| total_latency | varchar(11) | Yes | NULL | |||
| max_latency | varchar(11) | Yes | NULL | |||
| lock_latency | varchar(11) | Yes | NULL | |||
| rows_sent | decimal(42,0) | Yes | NULL | |||
| rows_examined | decimal(42,0) | Yes | NULL | |||
| rows_affected | decimal(42,0) | Yes | NULL | |||
| full_scans | decimal(43,0) | Yes | NULL |
host_summary_by_statement_type
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| host | varchar(255) | Yes | NULL | |||
| statement | varchar(128) | Yes | NULL | |||
| total | bigint | No | ||||
| total_latency | varchar(11) | Yes | NULL | |||
| max_latency | varchar(11) | Yes | NULL | |||
| lock_latency | varchar(11) | Yes | NULL | |||
| rows_sent | bigint | No | ||||
| rows_examined | bigint | No | ||||
| rows_affected | bigint | No | ||||
| full_scans | bigint | No | 0 |
innodb_buffer_stats_by_schema
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| object_schema | text | Yes | NULL | |||
| allocated | varchar(11) | Yes | NULL | |||
| data | varchar(11) | Yes | NULL | |||
| pages | bigint | No | 0 | |||
| pages_hashed | bigint | No | 0 | |||
| pages_old | bigint | No | 0 | |||
| rows_cached | decimal(44,0) | Yes | NULL |
innodb_buffer_stats_by_table
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| object_schema | text | Yes | NULL | |||
| object_name | text | Yes | NULL | |||
| allocated | varchar(11) | Yes | NULL | |||
| data | varchar(11) | Yes | NULL | |||
| pages | bigint | No | 0 | |||
| pages_hashed | bigint | No | 0 | |||
| pages_old | bigint | No | 0 | |||
| rows_cached | decimal(44,0) | Yes | NULL |
innodb_lock_waits
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| wait_started | datetime | Yes | NULL | |||
| wait_age | time | Yes | NULL | |||
| wait_age_secs | bigint | Yes | NULL | |||
| locked_table | mediumtext | Yes | NULL | |||
| locked_table_schema | varchar(64) | Yes | NULL | |||
| locked_table_name | varchar(64) | Yes | NULL | |||
| locked_table_partition | varchar(64) | Yes | NULL | |||
| locked_table_subpartition | varchar(64) | Yes | NULL | |||
| locked_index | varchar(64) | Yes | NULL | |||
| locked_type | varchar(32) | No | ||||
| waiting_trx_id | varchar(18) | No | ||||
| waiting_trx_started | datetime | No | 0000-00-00 00:00:00 | |||
| waiting_trx_age | time | Yes | NULL | |||
| waiting_trx_rows_locked | bigint | No | 0 | |||
| waiting_trx_rows_modified | bigint | No | 0 | |||
| waiting_pid | bigint | No | 0 | |||
| waiting_query | longtext | Yes | NULL | |||
| waiting_lock_id | varchar(128) | No | ||||
| waiting_lock_mode | varchar(32) | No | ||||
| blocking_trx_id | varchar(18) | No | ||||
| blocking_pid | bigint | No | 0 | |||
| blocking_query | longtext | Yes | NULL | |||
| blocking_lock_id | varchar(128) | No | ||||
| blocking_lock_mode | varchar(32) | No | ||||
| blocking_trx_started | datetime | No | 0000-00-00 00:00:00 | |||
| blocking_trx_age | time | Yes | NULL | |||
| blocking_trx_rows_locked | bigint | No | 0 | |||
| blocking_trx_rows_modified | bigint | No | 0 | |||
| sql_kill_blocking_query | varchar(32) | No | ||||
| sql_kill_blocking_connection | varchar(26) | No |
io_by_thread_by_latency
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| user | varchar(288) | Yes | NULL | |||
| total | decimal(42,0) | Yes | NULL | |||
| total_latency | varchar(11) | Yes | NULL | |||
| min_latency | varchar(11) | Yes | NULL | |||
| avg_latency | varchar(11) | Yes | NULL | |||
| max_latency | varchar(11) | Yes | NULL | |||
| thread_id | bigint | No | ||||
| processlist_id | bigint | Yes | NULL |
io_global_by_file_by_bytes
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| file | varchar(512) | Yes | NULL | |||
| count_read | bigint | No | ||||
| total_read | varchar(11) | Yes | NULL | |||
| avg_read | varchar(11) | Yes | NULL | |||
| count_write | bigint | No | ||||
| total_written | varchar(11) | Yes | NULL | |||
| avg_write | varchar(11) | Yes | NULL | |||
| total | varchar(11) | Yes | NULL | |||
| write_pct | decimal(26,2) | No | 0.00 |
io_global_by_file_by_latency
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| file | varchar(512) | Yes | NULL | |||
| total | bigint | No | ||||
| total_latency | varchar(11) | Yes | NULL | |||
| count_read | bigint | No | ||||
| read_latency | varchar(11) | Yes | NULL | |||
| count_write | bigint | No | ||||
| write_latency | varchar(11) | Yes | NULL | |||
| count_misc | bigint | No | ||||
| misc_latency | varchar(11) | Yes | NULL |
io_global_by_wait_by_bytes
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| event_name | varchar(128) | Yes | NULL | |||
| total | bigint | No | ||||
| total_latency | varchar(11) | Yes | NULL | |||
| min_latency | varchar(11) | Yes | NULL | |||
| avg_latency | varchar(11) | Yes | NULL | |||
| max_latency | varchar(11) | Yes | NULL | |||
| count_read | bigint | No | ||||
| total_read | varchar(11) | Yes | NULL | |||
| avg_read | varchar(11) | Yes | NULL | |||
| count_write | bigint | No | ||||
| total_written | varchar(11) | Yes | NULL | |||
| avg_written | varchar(11) | Yes | NULL | |||
| total_requested | varchar(11) | Yes | NULL |
io_global_by_wait_by_latency
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| event_name | varchar(128) | Yes | NULL | |||
| total | bigint | No | ||||
| total_latency | varchar(11) | Yes | NULL | |||
| avg_latency | varchar(11) | Yes | NULL | |||
| max_latency | varchar(11) | Yes | NULL | |||
| read_latency | varchar(11) | Yes | NULL | |||
| write_latency | varchar(11) | Yes | NULL | |||
| misc_latency | varchar(11) | Yes | NULL | |||
| count_read | bigint | No | ||||
| total_read | varchar(11) | Yes | NULL | |||
| avg_read | varchar(11) | Yes | NULL | |||
| count_write | bigint | No | ||||
| total_written | varchar(11) | Yes | NULL | |||
| avg_written | varchar(11) | Yes | NULL |
latest_file_io
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| thread | varchar(316) | Yes | NULL | |||
| file | varchar(512) | Yes | NULL | |||
| latency | varchar(11) | Yes | NULL | |||
| operation | varchar(32) | No | ||||
| requested | varchar(11) | Yes | NULL |
memory_by_host_by_current_bytes
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| host | varchar(255) | Yes | NULL | |||
| current_count_used | decimal(41,0) | Yes | NULL | |||
| current_allocated | varchar(11) | Yes | NULL | |||
| current_avg_alloc | varchar(11) | Yes | NULL | |||
| current_max_alloc | varchar(11) | Yes | NULL | |||
| total_allocated | varchar(11) | Yes | NULL |
memory_by_thread_by_current_bytes
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| thread_id | bigint | No | ||||
| user | varchar(288) | Yes | NULL | |||
| current_count_used | decimal(41,0) | Yes | NULL | |||
| current_allocated | varchar(11) | Yes | NULL | |||
| current_avg_alloc | varchar(11) | Yes | NULL | |||
| current_max_alloc | varchar(11) | Yes | NULL | |||
| total_allocated | varchar(11) | Yes | NULL |
memory_by_user_by_current_bytes
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| user | varchar(32) | Yes | NULL | |||
| current_count_used | decimal(41,0) | Yes | NULL | |||
| current_allocated | varchar(11) | Yes | NULL | |||
| current_avg_alloc | varchar(11) | Yes | NULL | |||
| current_max_alloc | varchar(11) | Yes | NULL | |||
| total_allocated | varchar(11) | Yes | NULL |
memory_global_by_current_bytes
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| event_name | varchar(128) | No | ||||
| current_count | bigint | No | ||||
| current_alloc | varchar(11) | Yes | NULL | |||
| current_avg_alloc | varchar(11) | Yes | NULL | |||
| high_count | bigint | No | ||||
| high_alloc | varchar(11) | Yes | NULL | |||
| high_avg_alloc | varchar(11) | Yes | NULL |
memory_global_total
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| total_allocated | varchar(11) | Yes | NULL |
metrics
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| Variable_name | varchar(193) | No | ||||
| Variable_value | text | Yes | NULL | |||
| Type | varchar(210) | No | ||||
| Enabled | varchar(7) | No |
processlist
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| thd_id | bigint | No | ||||
| conn_id | bigint | Yes | NULL | |||
| user | varchar(288) | Yes | NULL | |||
| db | varchar(64) | Yes | NULL | |||
| command | varchar(16) | Yes | NULL | |||
| state | varchar(64) | Yes | NULL | |||
| time | bigint | Yes | NULL | |||
| current_statement | longtext | Yes | NULL | |||
| statement_latency | varchar(11) | Yes | NULL | |||
| progress | decimal(26,2) | Yes | NULL | |||
| lock_latency | varchar(11) | Yes | NULL | |||
| rows_examined | bigint | Yes | NULL | |||
| rows_sent | bigint | Yes | NULL | |||
| rows_affected | bigint | Yes | NULL | |||
| tmp_tables | bigint | Yes | NULL | |||
| tmp_disk_tables | bigint | Yes | NULL | |||
| full_scan | varchar(3) | No | ||||
| last_statement | longtext | Yes | NULL | |||
| last_statement_latency | varchar(11) | Yes | NULL | |||
| current_memory | varchar(11) | Yes | NULL | |||
| last_wait | varchar(128) | Yes | NULL | |||
| last_wait_latency | varchar(13) | Yes | NULL | |||
| source | varchar(64) | Yes | NULL | |||
| trx_latency | varchar(11) | Yes | NULL | |||
| trx_state | enum('ACTIVE', 'COMMITTED', 'ROLLED BACK') | Yes | NULL | |||
| trx_autocommit | enum('YES', 'NO') | Yes | NULL | |||
| pid | varchar(1024) | Yes | NULL | |||
| program_name | varchar(1024) | Yes | NULL |
ps_check_lost_instrumentation
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| variable_name | varchar(64) | No | ||||
| variable_value | varchar(1024) | Yes | NULL |
schema_auto_increment_columns
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| table_schema | varchar(64) | Yes | NULL | |||
| table_name | varchar(64) | Yes | NULL | |||
| column_name | varchar(64) | Yes | NULL | |||
| data_type | longtext | Yes | NULL | |||
| column_type | mediumtext | No | ||||
| is_signed | int | No | 0 | |||
| is_unsigned | int | No | 0 | |||
| max_value | bigint | Yes | NULL | |||
| auto_increment | bigint | Yes | NULL | |||
| auto_increment_ratio | decimal(25,4) | Yes | NULL |
schema_index_statistics
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| table_schema | varchar(64) | Yes | NULL | |||
| table_name | varchar(64) | Yes | NULL | |||
| index_name | varchar(64) | Yes | NULL | |||
| rows_selected | bigint | No | ||||
| select_latency | varchar(11) | Yes | NULL | |||
| rows_inserted | bigint | No | ||||
| insert_latency | varchar(11) | Yes | NULL | |||
| rows_updated | bigint | No | ||||
| update_latency | varchar(11) | Yes | NULL | |||
| rows_deleted | bigint | No | ||||
| delete_latency | varchar(11) | Yes | NULL |
schema_object_overview
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| db | varchar(64) | Yes | NULL | |||
| object_type | varchar(19) | Yes | NULL | |||
| count | bigint | No | 0 |
schema_redundant_indexes
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| table_schema | varchar(64) | Yes | NULL | |||
| table_name | varchar(64) | Yes | NULL | |||
| redundant_index_name | varchar(64) | Yes | NULL | |||
| redundant_index_columns | text | Yes | NULL | |||
| redundant_index_non_unique | int | Yes | NULL | |||
| dominant_index_name | varchar(64) | Yes | NULL | |||
| dominant_index_columns | text | Yes | NULL | |||
| dominant_index_non_unique | int | Yes | NULL | |||
| subpart_exists | int | No | 0 | |||
| sql_drop_index | varchar(223) | Yes | NULL |
schema_tables_with_full_table_scans
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| object_schema | varchar(64) | Yes | NULL | |||
| object_name | varchar(64) | Yes | NULL | |||
| rows_full_scanned | bigint | No | ||||
| latency | varchar(11) | Yes | NULL |
schema_table_lock_waits
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| object_schema | varchar(64) | Yes | NULL | |||
| object_name | varchar(64) | Yes | NULL | |||
| waiting_thread_id | bigint | No | ||||
| waiting_pid | bigint | Yes | NULL | |||
| waiting_account | text | Yes | NULL | |||
| waiting_lock_type | varchar(32) | No | ||||
| waiting_lock_duration | varchar(32) | No | ||||
| waiting_query | longtext | Yes | NULL | |||
| waiting_query_secs | bigint | Yes | NULL | |||
| waiting_query_rows_affected | bigint | Yes | NULL | |||
| waiting_query_rows_examined | bigint | Yes | NULL | |||
| blocking_thread_id | bigint | No | ||||
| blocking_pid | bigint | Yes | NULL | |||
| blocking_account | text | Yes | NULL | |||
| blocking_lock_type | varchar(32) | No | ||||
| blocking_lock_duration | varchar(32) | No | ||||
| sql_kill_blocking_query | varchar(31) | Yes | NULL | |||
| sql_kill_blocking_connection | varchar(25) | Yes | NULL |
schema_table_statistics
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| table_schema | varchar(64) | Yes | NULL | |||
| table_name | varchar(64) | Yes | NULL | |||
| total_latency | varchar(11) | Yes | NULL | |||
| rows_fetched | bigint | No | ||||
| fetch_latency | varchar(11) | Yes | NULL | |||
| rows_inserted | bigint | No | ||||
| insert_latency | varchar(11) | Yes | NULL | |||
| rows_updated | bigint | No | ||||
| update_latency | varchar(11) | Yes | NULL | |||
| rows_deleted | bigint | No | ||||
| delete_latency | varchar(11) | Yes | NULL | |||
| io_read_requests | decimal(42,0) | Yes | NULL | |||
| io_read | varchar(11) | Yes | NULL | |||
| io_read_latency | varchar(11) | Yes | NULL | |||
| io_write_requests | decimal(42,0) | Yes | NULL | |||
| io_write | varchar(11) | Yes | NULL | |||
| io_write_latency | varchar(11) | Yes | NULL | |||
| io_misc_requests | decimal(42,0) | Yes | NULL | |||
| io_misc_latency | varchar(11) | Yes | NULL |
schema_table_statistics_with_buffer
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| table_schema | varchar(64) | Yes | NULL | |||
| table_name | varchar(64) | Yes | NULL | |||
| rows_fetched | bigint | No | ||||
| fetch_latency | varchar(11) | Yes | NULL | |||
| rows_inserted | bigint | No | ||||
| insert_latency | varchar(11) | Yes | NULL | |||
| rows_updated | bigint | No | ||||
| update_latency | varchar(11) | Yes | NULL | |||
| rows_deleted | bigint | No | ||||
| delete_latency | varchar(11) | Yes | NULL | |||
| io_read_requests | decimal(42,0) | Yes | NULL | |||
| io_read | varchar(11) | Yes | NULL | |||
| io_read_latency | varchar(11) | Yes | NULL | |||
| io_write_requests | decimal(42,0) | Yes | NULL | |||
| io_write | varchar(11) | Yes | NULL | |||
| io_write_latency | varchar(11) | Yes | NULL | |||
| io_misc_requests | decimal(42,0) | Yes | NULL | |||
| io_misc_latency | varchar(11) | Yes | NULL | |||
| innodb_buffer_allocated | varchar(11) | Yes | NULL | |||
| innodb_buffer_data | varchar(11) | Yes | NULL | |||
| innodb_buffer_free | varchar(11) | Yes | NULL | |||
| innodb_buffer_pages | bigint | Yes | 0 | |||
| innodb_buffer_pages_hashed | bigint | Yes | 0 | |||
| innodb_buffer_pages_old | bigint | Yes | 0 | |||
| innodb_buffer_rows_cached | decimal(44,0) | Yes | 0 |
schema_unused_indexes
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| object_schema | varchar(64) | Yes | NULL | |||
| object_name | varchar(64) | Yes | NULL | |||
| index_name | varchar(64) | Yes | NULL |
session
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| thd_id | bigint | No | ||||
| conn_id | bigint | Yes | NULL | |||
| user | varchar(288) | Yes | NULL | |||
| db | varchar(64) | Yes | NULL | |||
| command | varchar(16) | Yes | NULL | |||
| state | varchar(64) | Yes | NULL | |||
| time | bigint | Yes | NULL | |||
| current_statement | longtext | Yes | NULL | |||
| statement_latency | varchar(11) | Yes | NULL | |||
| progress | decimal(26,2) | Yes | NULL | |||
| lock_latency | varchar(11) | Yes | NULL | |||
| rows_examined | bigint | Yes | NULL | |||
| rows_sent | bigint | Yes | NULL | |||
| rows_affected | bigint | Yes | NULL | |||
| tmp_tables | bigint | Yes | NULL | |||
| tmp_disk_tables | bigint | Yes | NULL | |||
| full_scan | varchar(3) | No | ||||
| last_statement | longtext | Yes | NULL | |||
| last_statement_latency | varchar(11) | Yes | NULL | |||
| current_memory | varchar(11) | Yes | NULL | |||
| last_wait | varchar(128) | Yes | NULL | |||
| last_wait_latency | varchar(13) | Yes | NULL | |||
| source | varchar(64) | Yes | NULL | |||
| trx_latency | varchar(11) | Yes | NULL | |||
| trx_state | enum('ACTIVE', 'COMMITTED', 'ROLLED BACK') | Yes | NULL | |||
| trx_autocommit | enum('YES', 'NO') | Yes | NULL | |||
| pid | varchar(1024) | Yes | NULL | |||
| program_name | varchar(1024) | Yes | NULL |
session_ssl_status
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| thread_id | bigint | No | ||||
| ssl_version | varchar(1024) | Yes | NULL | |||
| ssl_cipher | varchar(1024) | Yes | NULL | |||
| ssl_sessions_reused | varchar(1024) | Yes | NULL |
statements_with_errors_or_warnings
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| query | longtext | Yes | NULL | |||
| db | varchar(64) | Yes | NULL | |||
| exec_count | bigint | No | ||||
| errors | bigint | No | ||||
| error_pct | decimal(27,4) | No | 0.0000 | |||
| warnings | bigint | No | ||||
| warning_pct | decimal(27,4) | No | 0.0000 | |||
| first_seen | timestamp(6) | No | 0000-00-00 00:00:00.000000 | |||
| last_seen | timestamp(6) | No | 0000-00-00 00:00:00.000000 | |||
| digest | varchar(64) | Yes | NULL |
statements_with_full_table_scans
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| query | longtext | Yes | NULL | |||
| db | varchar(64) | Yes | NULL | |||
| exec_count | bigint | No | ||||
| total_latency | varchar(11) | Yes | NULL | |||
| no_index_used_count | bigint | No | ||||
| no_good_index_used_count | bigint | No | ||||
| no_index_used_pct | decimal(24,0) | No | 0 | |||
| rows_sent | bigint | No | ||||
| rows_examined | bigint | No | ||||
| rows_sent_avg | decimal(21,0) | Yes | NULL | |||
| rows_examined_avg | decimal(21,0) | Yes | NULL | |||
| first_seen | timestamp(6) | No | 0000-00-00 00:00:00.000000 | |||
| last_seen | timestamp(6) | No | 0000-00-00 00:00:00.000000 | |||
| digest | varchar(64) | Yes | NULL |
statements_with_runtimes_in_95th_percentile
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| query | longtext | Yes | NULL | |||
| db | varchar(64) | Yes | NULL | |||
| full_scan | varchar(1) | No | ||||
| exec_count | bigint | No | ||||
| err_count | bigint | No | ||||
| warn_count | bigint | No | ||||
| total_latency | varchar(11) | Yes | NULL | |||
| max_latency | varchar(11) | Yes | NULL | |||
| avg_latency | varchar(11) | Yes | NULL | |||
| rows_sent | bigint | No | ||||
| rows_sent_avg | decimal(21,0) | No | 0 | |||
| rows_examined | bigint | No | ||||
| rows_examined_avg | decimal(21,0) | No | 0 | |||
| first_seen | timestamp(6) | No | 0000-00-00 00:00:00.000000 | |||
| last_seen | timestamp(6) | No | 0000-00-00 00:00:00.000000 | |||
| digest | varchar(64) | Yes | NULL |
statements_with_sorting
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| query | longtext | Yes | NULL | |||
| db | varchar(64) | Yes | NULL | |||
| exec_count | bigint | No | ||||
| total_latency | varchar(11) | Yes | NULL | |||
| sort_merge_passes | bigint | No | ||||
| avg_sort_merges | decimal(21,0) | No | 0 | |||
| sorts_using_scans | bigint | No | ||||
| sort_using_range | bigint | No | ||||
| rows_sorted | bigint | No | ||||
| avg_rows_sorted | decimal(21,0) | No | 0 | |||
| first_seen | timestamp(6) | No | 0000-00-00 00:00:00.000000 | |||
| last_seen | timestamp(6) | No | 0000-00-00 00:00:00.000000 | |||
| digest | varchar(64) | Yes | NULL |
statements_with_temp_tables
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| query | longtext | Yes | NULL | |||
| db | varchar(64) | Yes | NULL | |||
| exec_count | bigint | No | ||||
| total_latency | varchar(11) | Yes | NULL | |||
| memory_tmp_tables | bigint | No | ||||
| disk_tmp_tables | bigint | No | ||||
| avg_tmp_tables_per_query | decimal(21,0) | No | 0 | |||
| tmp_tables_to_disk_pct | decimal(24,0) | No | 0 | |||
| first_seen | timestamp(6) | No | 0000-00-00 00:00:00.000000 | |||
| last_seen | timestamp(6) | No | 0000-00-00 00:00:00.000000 | |||
| digest | varchar(64) | Yes | NULL |
statement_analysis
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| query | longtext | Yes | NULL | |||
| db | varchar(64) | Yes | NULL | |||
| full_scan | varchar(1) | No | ||||
| exec_count | bigint | No | ||||
| err_count | bigint | No | ||||
| warn_count | bigint | No | ||||
| total_latency | varchar(11) | Yes | NULL | |||
| max_latency | varchar(11) | Yes | NULL | |||
| avg_latency | varchar(11) | Yes | NULL | |||
| lock_latency | varchar(11) | Yes | NULL | |||
| rows_sent | bigint | No | ||||
| rows_sent_avg | decimal(21,0) | No | 0 | |||
| rows_examined | bigint | No | ||||
| rows_examined_avg | decimal(21,0) | No | 0 | |||
| rows_affected | bigint | No | ||||
| rows_affected_avg | decimal(21,0) | No | 0 | |||
| tmp_tables | bigint | No | ||||
| tmp_disk_tables | bigint | No | ||||
| rows_sorted | bigint | No | ||||
| sort_merge_passes | bigint | No | ||||
| digest | varchar(64) | Yes | NULL | |||
| first_seen | timestamp(6) | No | 0000-00-00 00:00:00.000000 | |||
| last_seen | timestamp(6) | No | 0000-00-00 00:00:00.000000 |
sys_config
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| variable (Primary) | varchar(128) | No | ||||
| value | varchar(128) | Yes | NULL | |||
| set_time | timestamp | Yes | CURRENT_TIMESTAMP | |||
| set_by | varchar(128) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | variable | 6 | A | No |
user_summary
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| user | varchar(32) | Yes | NULL | |||
| statements | decimal(64,0) | Yes | NULL | |||
| statement_latency | varchar(11) | Yes | NULL | |||
| statement_avg_latency | varchar(11) | Yes | NULL | |||
| table_scans | decimal(65,0) | Yes | NULL | |||
| file_ios | decimal(64,0) | Yes | NULL | |||
| file_io_latency | varchar(11) | Yes | NULL | |||
| current_connections | decimal(41,0) | Yes | NULL | |||
| total_connections | decimal(41,0) | Yes | NULL | |||
| unique_hosts | bigint | No | 0 | |||
| current_memory | varchar(11) | Yes | NULL | |||
| total_memory_allocated | varchar(11) | Yes | NULL |
user_summary_by_file_io
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| user | varchar(32) | Yes | NULL | |||
| ios | decimal(42,0) | Yes | NULL | |||
| io_latency | varchar(11) | Yes | NULL |
user_summary_by_file_io_type
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| user | varchar(32) | Yes | NULL | |||
| event_name | varchar(128) | No | ||||
| total | bigint | No | ||||
| latency | varchar(11) | Yes | NULL | |||
| max_latency | varchar(11) | Yes | NULL |
user_summary_by_stages
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| user | varchar(32) | Yes | NULL | |||
| event_name | varchar(128) | No | ||||
| total | bigint | No | ||||
| total_latency | varchar(11) | Yes | NULL | |||
| avg_latency | varchar(11) | Yes | NULL |
user_summary_by_statement_latency
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| user | varchar(32) | Yes | NULL | |||
| total | decimal(42,0) | Yes | NULL | |||
| total_latency | varchar(11) | Yes | NULL | |||
| max_latency | varchar(11) | Yes | NULL | |||
| lock_latency | varchar(11) | Yes | NULL | |||
| rows_sent | decimal(42,0) | Yes | NULL | |||
| rows_examined | decimal(42,0) | Yes | NULL | |||
| rows_affected | decimal(42,0) | Yes | NULL | |||
| full_scans | decimal(43,0) | Yes | NULL |
user_summary_by_statement_type
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| user | varchar(32) | Yes | NULL | |||
| statement | varchar(128) | Yes | NULL | |||
| total | bigint | No | ||||
| total_latency | varchar(11) | Yes | NULL | |||
| max_latency | varchar(11) | Yes | NULL | |||
| lock_latency | varchar(11) | Yes | NULL | |||
| rows_sent | bigint | No | ||||
| rows_examined | bigint | No | ||||
| rows_affected | bigint | No | ||||
| full_scans | bigint | No | 0 |
version
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| sys_version | varchar(5) | No | ||||
| mysql_version | varchar(6) | No |
waits_by_host_by_latency
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| host | varchar(255) | Yes | NULL | |||
| event | varchar(128) | No | ||||
| total | bigint | No | ||||
| total_latency | varchar(11) | Yes | NULL | |||
| avg_latency | varchar(11) | Yes | NULL | |||
| max_latency | varchar(11) | Yes | NULL |
waits_by_user_by_latency
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| user | varchar(32) | Yes | NULL | |||
| event | varchar(128) | No | ||||
| total | bigint | No | ||||
| total_latency | varchar(11) | Yes | NULL | |||
| avg_latency | varchar(11) | Yes | NULL | |||
| max_latency | varchar(11) | Yes | NULL |
waits_global_by_latency
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| events | varchar(128) | No | ||||
| total | bigint | No | ||||
| total_latency | varchar(11) | Yes | NULL | |||
| avg_latency | varchar(11) | Yes | NULL | |||
| max_latency | varchar(11) | Yes | NULL |
wait_classes_global_by_avg_latency
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| event_class | varchar(128) | Yes | NULL | |||
| total | decimal(42,0) | Yes | NULL | |||
| total_latency | varchar(11) | Yes | NULL | |||
| min_latency | varchar(11) | Yes | NULL | |||
| avg_latency | varchar(11) | Yes | NULL | |||
| max_latency | varchar(11) | Yes | NULL |
wait_classes_global_by_latency
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| event_class | varchar(128) | Yes | NULL | |||
| total | decimal(42,0) | Yes | NULL | |||
| total_latency | varchar(11) | Yes | NULL | |||
| min_latency | varchar(11) | Yes | NULL | |||
| avg_latency | varchar(11) | Yes | NULL | |||
| max_latency | varchar(11) | Yes | NULL |
x$host_summary
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| host | varchar(255) | Yes | NULL | |||
| statements | decimal(64,0) | Yes | NULL | |||
| statement_latency | decimal(64,0) | Yes | NULL | |||
| statement_avg_latency | decimal(65,4) | Yes | NULL | |||
| table_scans | decimal(65,0) | Yes | NULL | |||
| file_ios | decimal(64,0) | Yes | NULL | |||
| file_io_latency | decimal(64,0) | Yes | NULL | |||
| current_connections | decimal(41,0) | Yes | NULL | |||
| total_connections | decimal(41,0) | Yes | NULL | |||
| unique_users | bigint | No | 0 | |||
| current_memory | decimal(63,0) | Yes | NULL | |||
| total_memory_allocated | decimal(64,0) | Yes | NULL |
x$host_summary_by_file_io
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| host | varchar(255) | Yes | NULL | |||
| ios | decimal(42,0) | Yes | NULL | |||
| io_latency | decimal(42,0) | Yes | NULL |
x$host_summary_by_file_io_type
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| host | varchar(255) | Yes | NULL | |||
| event_name | varchar(128) | No | ||||
| total | bigint | No | ||||
| total_latency | bigint | No | ||||
| max_latency | bigint | No |
x$host_summary_by_stages
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| host | varchar(255) | Yes | NULL | |||
| event_name | varchar(128) | No | ||||
| total | bigint | No | ||||
| total_latency | bigint | No | ||||
| avg_latency | bigint | No |
x$host_summary_by_statement_latency
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| host | varchar(255) | Yes | NULL | |||
| total | decimal(42,0) | Yes | NULL | |||
| total_latency | decimal(42,0) | Yes | NULL | |||
| max_latency | bigint | Yes | NULL | |||
| lock_latency | decimal(42,0) | Yes | NULL | |||
| rows_sent | decimal(42,0) | Yes | NULL | |||
| rows_examined | decimal(42,0) | Yes | NULL | |||
| rows_affected | decimal(42,0) | Yes | NULL | |||
| full_scans | decimal(43,0) | Yes | NULL |
x$host_summary_by_statement_type
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| host | varchar(255) | Yes | NULL | |||
| statement | varchar(128) | Yes | NULL | |||
| total | bigint | No | ||||
| total_latency | bigint | No | ||||
| max_latency | bigint | No | ||||
| lock_latency | bigint | No | ||||
| rows_sent | bigint | No | ||||
| rows_examined | bigint | No | ||||
| rows_affected | bigint | No | ||||
| full_scans | bigint | No | 0 |
x$innodb_buffer_stats_by_schema
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| object_schema | text | Yes | NULL | |||
| allocated | decimal(43,0) | Yes | NULL | |||
| data | decimal(43,0) | Yes | NULL | |||
| pages | bigint | No | 0 | |||
| pages_hashed | bigint | No | 0 | |||
| pages_old | bigint | No | 0 | |||
| rows_cached | decimal(44,0) | No | 0 |
x$innodb_buffer_stats_by_table
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| object_schema | text | Yes | NULL | |||
| object_name | text | Yes | NULL | |||
| allocated | decimal(43,0) | Yes | NULL | |||
| data | decimal(43,0) | Yes | NULL | |||
| pages | bigint | No | 0 | |||
| pages_hashed | bigint | No | 0 | |||
| pages_old | bigint | No | 0 | |||
| rows_cached | decimal(44,0) | No | 0 |
x$innodb_lock_waits
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| wait_started | datetime | Yes | NULL | |||
| wait_age | time | Yes | NULL | |||
| wait_age_secs | bigint | Yes | NULL | |||
| locked_table | mediumtext | Yes | NULL | |||
| locked_table_schema | varchar(64) | Yes | NULL | |||
| locked_table_name | varchar(64) | Yes | NULL | |||
| locked_table_partition | varchar(64) | Yes | NULL | |||
| locked_table_subpartition | varchar(64) | Yes | NULL | |||
| locked_index | varchar(64) | Yes | NULL | |||
| locked_type | varchar(32) | No | ||||
| waiting_trx_id | varchar(18) | No | ||||
| waiting_trx_started | datetime | No | 0000-00-00 00:00:00 | |||
| waiting_trx_age | time | Yes | NULL | |||
| waiting_trx_rows_locked | bigint | No | 0 | |||
| waiting_trx_rows_modified | bigint | No | 0 | |||
| waiting_pid | bigint | No | 0 | |||
| waiting_query | varchar(1024) | Yes | NULL | |||
| waiting_lock_id | varchar(128) | No | ||||
| waiting_lock_mode | varchar(32) | No | ||||
| blocking_trx_id | varchar(18) | No | ||||
| blocking_pid | bigint | No | 0 | |||
| blocking_query | varchar(1024) | Yes | NULL | |||
| blocking_lock_id | varchar(128) | No | ||||
| blocking_lock_mode | varchar(32) | No | ||||
| blocking_trx_started | datetime | No | 0000-00-00 00:00:00 | |||
| blocking_trx_age | time | Yes | NULL | |||
| blocking_trx_rows_locked | bigint | No | 0 | |||
| blocking_trx_rows_modified | bigint | No | 0 | |||
| sql_kill_blocking_query | varchar(32) | No | ||||
| sql_kill_blocking_connection | varchar(26) | No |
x$io_by_thread_by_latency
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| user | varchar(288) | Yes | NULL | |||
| total | decimal(42,0) | Yes | NULL | |||
| total_latency | decimal(42,0) | Yes | NULL | |||
| min_latency | bigint | Yes | NULL | |||
| avg_latency | decimal(24,4) | Yes | NULL | |||
| max_latency | bigint | Yes | NULL | |||
| thread_id | bigint | No | ||||
| processlist_id | bigint | Yes | NULL |
x$io_global_by_file_by_bytes
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| file | varchar(512) | No | ||||
| count_read | bigint | No | ||||
| total_read | bigint | No | ||||
| avg_read | decimal(23,4) | No | 0.0000 | |||
| count_write | bigint | No | ||||
| total_written | bigint | No | ||||
| avg_write | decimal(23,4) | No | 0.0000 | |||
| total | bigint | No | 0 | |||
| write_pct | decimal(26,2) | No | 0.00 |
x$io_global_by_file_by_latency
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| file | varchar(512) | No | ||||
| total | bigint | No | ||||
| total_latency | bigint | No | ||||
| count_read | bigint | No | ||||
| read_latency | bigint | No | ||||
| count_write | bigint | No | ||||
| write_latency | bigint | No | ||||
| count_misc | bigint | No | ||||
| misc_latency | bigint | No |
x$io_global_by_wait_by_bytes
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| event_name | varchar(128) | Yes | NULL | |||
| total | bigint | No | ||||
| total_latency | bigint | No | ||||
| min_latency | bigint | No | ||||
| avg_latency | bigint | No | ||||
| max_latency | bigint | No | ||||
| count_read | bigint | No | ||||
| total_read | bigint | No | ||||
| avg_read | decimal(23,4) | No | 0.0000 | |||
| count_write | bigint | No | ||||
| total_written | bigint | No | ||||
| avg_written | decimal(23,4) | No | 0.0000 | |||
| total_requested | bigint | No | 0 |
x$io_global_by_wait_by_latency
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| event_name | varchar(128) | Yes | NULL | |||
| total | bigint | No | ||||
| total_latency | bigint | No | ||||
| avg_latency | bigint | No | ||||
| max_latency | bigint | No | ||||
| read_latency | bigint | No | ||||
| write_latency | bigint | No | ||||
| misc_latency | bigint | No | ||||
| count_read | bigint | No | ||||
| total_read | bigint | No | ||||
| avg_read | decimal(23,4) | No | 0.0000 | |||
| count_write | bigint | No | ||||
| total_written | bigint | No | ||||
| avg_written | decimal(23,4) | No | 0.0000 |
x$latest_file_io
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| thread | varchar(316) | Yes | NULL | |||
| file | varchar(512) | Yes | NULL | |||
| latency | bigint | Yes | NULL | |||
| operation | varchar(32) | No | ||||
| requested | bigint | Yes | NULL |
x$memory_by_host_by_current_bytes
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| host | varchar(255) | Yes | NULL | |||
| current_count_used | decimal(41,0) | Yes | NULL | |||
| current_allocated | decimal(41,0) | Yes | NULL | |||
| current_avg_alloc | decimal(45,4) | No | 0.0000 | |||
| current_max_alloc | bigint | Yes | NULL | |||
| total_allocated | decimal(42,0) | Yes | NULL |
x$memory_by_thread_by_current_bytes
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| thread_id | bigint | No | ||||
| user | varchar(288) | Yes | NULL | |||
| current_count_used | decimal(41,0) | Yes | NULL | |||
| current_allocated | decimal(41,0) | Yes | NULL | |||
| current_avg_alloc | decimal(45,4) | No | 0.0000 | |||
| current_max_alloc | bigint | Yes | NULL | |||
| total_allocated | decimal(42,0) | Yes | NULL |
x$memory_by_user_by_current_bytes
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| user | varchar(32) | Yes | NULL | |||
| current_count_used | decimal(41,0) | Yes | NULL | |||
| current_allocated | decimal(41,0) | Yes | NULL | |||
| current_avg_alloc | decimal(45,4) | No | 0.0000 | |||
| current_max_alloc | bigint | Yes | NULL | |||
| total_allocated | decimal(42,0) | Yes | NULL |
x$memory_global_by_current_bytes
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| event_name | varchar(128) | No | ||||
| current_count | bigint | No | ||||
| current_alloc | bigint | No | ||||
| current_avg_alloc | decimal(23,4) | No | 0.0000 | |||
| high_count | bigint | No | ||||
| high_alloc | bigint | No | ||||
| high_avg_alloc | decimal(23,4) | No | 0.0000 |
x$memory_global_total
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| total_allocated | decimal(41,0) | Yes | NULL |
x$processlist
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| thd_id | bigint | No | ||||
| conn_id | bigint | Yes | NULL | |||
| user | varchar(288) | Yes | NULL | |||
| db | varchar(64) | Yes | NULL | |||
| command | varchar(16) | Yes | NULL | |||
| state | varchar(64) | Yes | NULL | |||
| time | bigint | Yes | NULL | |||
| current_statement | longtext | Yes | NULL | |||
| statement_latency | bigint | Yes | NULL | |||
| progress | decimal(26,2) | Yes | NULL | |||
| lock_latency | bigint | Yes | NULL | |||
| rows_examined | bigint | Yes | NULL | |||
| rows_sent | bigint | Yes | NULL | |||
| rows_affected | bigint | Yes | NULL | |||
| tmp_tables | bigint | Yes | NULL | |||
| tmp_disk_tables | bigint | Yes | NULL | |||
| full_scan | varchar(3) | No | ||||
| last_statement | longtext | Yes | NULL | |||
| last_statement_latency | bigint | Yes | NULL | |||
| current_memory | decimal(41,0) | Yes | NULL | |||
| last_wait | varchar(128) | Yes | NULL | |||
| last_wait_latency | varchar(20) | Yes | NULL | |||
| source | varchar(64) | Yes | NULL | |||
| trx_latency | bigint | Yes | NULL | |||
| trx_state | enum('ACTIVE', 'COMMITTED', 'ROLLED BACK') | Yes | NULL | |||
| trx_autocommit | enum('YES', 'NO') | Yes | NULL | |||
| pid | varchar(1024) | Yes | NULL | |||
| program_name | varchar(1024) | Yes | NULL |
x$ps_digest_95th_percentile_by_avg_us
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| avg_us | decimal(21,0) | Yes | NULL | |||
| percentile | decimal(46,4) | No | 0.0000 |
x$ps_digest_avg_latency_distribution
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| cnt | bigint | No | 0 | |||
| avg_us | decimal(21,0) | Yes | NULL |
x$ps_schema_table_statistics_io
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| table_schema | varchar(64) | Yes | NULL | |||
| table_name | varchar(64) | Yes | NULL | |||
| count_read | decimal(42,0) | Yes | NULL | |||
| sum_number_of_bytes_read | decimal(41,0) | Yes | NULL | |||
| sum_timer_read | decimal(42,0) | Yes | NULL | |||
| count_write | decimal(42,0) | Yes | NULL | |||
| sum_number_of_bytes_write | decimal(41,0) | Yes | NULL | |||
| sum_timer_write | decimal(42,0) | Yes | NULL | |||
| count_misc | decimal(42,0) | Yes | NULL | |||
| sum_timer_misc | decimal(42,0) | Yes | NULL |
x$schema_flattened_keys
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| table_schema | varchar(64) | Yes | NULL | |||
| table_name | varchar(64) | Yes | NULL | |||
| index_name | varchar(64) | Yes | NULL | |||
| non_unique | int | Yes | NULL | |||
| subpart_exists | bigint | Yes | NULL | |||
| index_columns | text | Yes | NULL |
x$schema_index_statistics
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| table_schema | varchar(64) | Yes | NULL | |||
| table_name | varchar(64) | Yes | NULL | |||
| index_name | varchar(64) | Yes | NULL | |||
| rows_selected | bigint | No | ||||
| select_latency | bigint | No | ||||
| rows_inserted | bigint | No | ||||
| insert_latency | bigint | No | ||||
| rows_updated | bigint | No | ||||
| update_latency | bigint | No | ||||
| rows_deleted | bigint | No | ||||
| delete_latency | bigint | No |
x$schema_tables_with_full_table_scans
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| object_schema | varchar(64) | Yes | NULL | |||
| object_name | varchar(64) | Yes | NULL | |||
| rows_full_scanned | bigint | No | ||||
| latency | bigint | No |
x$schema_table_lock_waits
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| object_schema | varchar(64) | Yes | NULL | |||
| object_name | varchar(64) | Yes | NULL | |||
| waiting_thread_id | bigint | No | ||||
| waiting_pid | bigint | Yes | NULL | |||
| waiting_account | text | Yes | NULL | |||
| waiting_lock_type | varchar(32) | No | ||||
| waiting_lock_duration | varchar(32) | No | ||||
| waiting_query | longtext | Yes | NULL | |||
| waiting_query_secs | bigint | Yes | NULL | |||
| waiting_query_rows_affected | bigint | Yes | NULL | |||
| waiting_query_rows_examined | bigint | Yes | NULL | |||
| blocking_thread_id | bigint | No | ||||
| blocking_pid | bigint | Yes | NULL | |||
| blocking_account | text | Yes | NULL | |||
| blocking_lock_type | varchar(32) | No | ||||
| blocking_lock_duration | varchar(32) | No | ||||
| sql_kill_blocking_query | varchar(31) | Yes | NULL | |||
| sql_kill_blocking_connection | varchar(25) | Yes | NULL |
x$schema_table_statistics
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| table_schema | varchar(64) | Yes | NULL | |||
| table_name | varchar(64) | Yes | NULL | |||
| total_latency | bigint | No | ||||
| rows_fetched | bigint | No | ||||
| fetch_latency | bigint | No | ||||
| rows_inserted | bigint | No | ||||
| insert_latency | bigint | No | ||||
| rows_updated | bigint | No | ||||
| update_latency | bigint | No | ||||
| rows_deleted | bigint | No | ||||
| delete_latency | bigint | No | ||||
| io_read_requests | decimal(42,0) | Yes | NULL | |||
| io_read | decimal(41,0) | Yes | NULL | |||
| io_read_latency | decimal(42,0) | Yes | NULL | |||
| io_write_requests | decimal(42,0) | Yes | NULL | |||
| io_write | decimal(41,0) | Yes | NULL | |||
| io_write_latency | decimal(42,0) | Yes | NULL | |||
| io_misc_requests | decimal(42,0) | Yes | NULL | |||
| io_misc_latency | decimal(42,0) | Yes | NULL |
x$schema_table_statistics_with_buffer
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| table_schema | varchar(64) | Yes | NULL | |||
| table_name | varchar(64) | Yes | NULL | |||
| rows_fetched | bigint | No | ||||
| fetch_latency | bigint | No | ||||
| rows_inserted | bigint | No | ||||
| insert_latency | bigint | No | ||||
| rows_updated | bigint | No | ||||
| update_latency | bigint | No | ||||
| rows_deleted | bigint | No | ||||
| delete_latency | bigint | No | ||||
| io_read_requests | decimal(42,0) | Yes | NULL | |||
| io_read | decimal(41,0) | Yes | NULL | |||
| io_read_latency | decimal(42,0) | Yes | NULL | |||
| io_write_requests | decimal(42,0) | Yes | NULL | |||
| io_write | decimal(41,0) | Yes | NULL | |||
| io_write_latency | decimal(42,0) | Yes | NULL | |||
| io_misc_requests | decimal(42,0) | Yes | NULL | |||
| io_misc_latency | decimal(42,0) | Yes | NULL | |||
| innodb_buffer_allocated | decimal(43,0) | Yes | NULL | |||
| innodb_buffer_data | decimal(43,0) | Yes | NULL | |||
| innodb_buffer_free | decimal(44,0) | Yes | NULL | |||
| innodb_buffer_pages | bigint | Yes | 0 | |||
| innodb_buffer_pages_hashed | bigint | Yes | 0 | |||
| innodb_buffer_pages_old | bigint | Yes | 0 | |||
| innodb_buffer_rows_cached | decimal(44,0) | Yes | 0 |
x$session
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| thd_id | bigint | No | ||||
| conn_id | bigint | Yes | NULL | |||
| user | varchar(288) | Yes | NULL | |||
| db | varchar(64) | Yes | NULL | |||
| command | varchar(16) | Yes | NULL | |||
| state | varchar(64) | Yes | NULL | |||
| time | bigint | Yes | NULL | |||
| current_statement | longtext | Yes | NULL | |||
| statement_latency | bigint | Yes | NULL | |||
| progress | decimal(26,2) | Yes | NULL | |||
| lock_latency | bigint | Yes | NULL | |||
| rows_examined | bigint | Yes | NULL | |||
| rows_sent | bigint | Yes | NULL | |||
| rows_affected | bigint | Yes | NULL | |||
| tmp_tables | bigint | Yes | NULL | |||
| tmp_disk_tables | bigint | Yes | NULL | |||
| full_scan | varchar(3) | No | ||||
| last_statement | longtext | Yes | NULL | |||
| last_statement_latency | bigint | Yes | NULL | |||
| current_memory | decimal(41,0) | Yes | NULL | |||
| last_wait | varchar(128) | Yes | NULL | |||
| last_wait_latency | varchar(20) | Yes | NULL | |||
| source | varchar(64) | Yes | NULL | |||
| trx_latency | bigint | Yes | NULL | |||
| trx_state | enum('ACTIVE', 'COMMITTED', 'ROLLED BACK') | Yes | NULL | |||
| trx_autocommit | enum('YES', 'NO') | Yes | NULL | |||
| pid | varchar(1024) | Yes | NULL | |||
| program_name | varchar(1024) | Yes | NULL |
x$statements_with_errors_or_warnings
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| query | longtext | Yes | NULL | |||
| db | varchar(64) | Yes | NULL | |||
| exec_count | bigint | No | ||||
| errors | bigint | No | ||||
| error_pct | decimal(27,4) | No | 0.0000 | |||
| warnings | bigint | No | ||||
| warning_pct | decimal(27,4) | No | 0.0000 | |||
| first_seen | timestamp(6) | No | 0000-00-00 00:00:00.000000 | |||
| last_seen | timestamp(6) | No | 0000-00-00 00:00:00.000000 | |||
| digest | varchar(64) | Yes | NULL |
x$statements_with_full_table_scans
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| query | longtext | Yes | NULL | |||
| db | varchar(64) | Yes | NULL | |||
| exec_count | bigint | No | ||||
| total_latency | bigint | No | ||||
| no_index_used_count | bigint | No | ||||
| no_good_index_used_count | bigint | No | ||||
| no_index_used_pct | decimal(24,0) | No | 0 | |||
| rows_sent | bigint | No | ||||
| rows_examined | bigint | No | ||||
| rows_sent_avg | decimal(21,0) | Yes | NULL | |||
| rows_examined_avg | decimal(21,0) | Yes | NULL | |||
| first_seen | timestamp(6) | No | 0000-00-00 00:00:00.000000 | |||
| last_seen | timestamp(6) | No | 0000-00-00 00:00:00.000000 | |||
| digest | varchar(64) | Yes | NULL |
x$statements_with_runtimes_in_95th_percentile
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| query | longtext | Yes | NULL | |||
| db | varchar(64) | Yes | NULL | |||
| full_scan | varchar(1) | No | ||||
| exec_count | bigint | No | ||||
| err_count | bigint | No | ||||
| warn_count | bigint | No | ||||
| total_latency | bigint | No | ||||
| max_latency | bigint | No | ||||
| avg_latency | bigint | No | ||||
| rows_sent | bigint | No | ||||
| rows_sent_avg | decimal(21,0) | No | 0 | |||
| rows_examined | bigint | No | ||||
| rows_examined_avg | decimal(21,0) | No | 0 | |||
| first_seen | timestamp(6) | No | 0000-00-00 00:00:00.000000 | |||
| last_seen | timestamp(6) | No | 0000-00-00 00:00:00.000000 | |||
| digest | varchar(64) | Yes | NULL |
x$statements_with_sorting
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| query | longtext | Yes | NULL | |||
| db | varchar(64) | Yes | NULL | |||
| exec_count | bigint | No | ||||
| total_latency | bigint | No | ||||
| sort_merge_passes | bigint | No | ||||
| avg_sort_merges | decimal(21,0) | No | 0 | |||
| sorts_using_scans | bigint | No | ||||
| sort_using_range | bigint | No | ||||
| rows_sorted | bigint | No | ||||
| avg_rows_sorted | decimal(21,0) | No | 0 | |||
| first_seen | timestamp(6) | No | 0000-00-00 00:00:00.000000 | |||
| last_seen | timestamp(6) | No | 0000-00-00 00:00:00.000000 | |||
| digest | varchar(64) | Yes | NULL |
x$statements_with_temp_tables
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| query | longtext | Yes | NULL | |||
| db | varchar(64) | Yes | NULL | |||
| exec_count | bigint | No | ||||
| total_latency | bigint | No | ||||
| memory_tmp_tables | bigint | No | ||||
| disk_tmp_tables | bigint | No | ||||
| avg_tmp_tables_per_query | decimal(21,0) | No | 0 | |||
| tmp_tables_to_disk_pct | decimal(24,0) | No | 0 | |||
| first_seen | timestamp(6) | No | 0000-00-00 00:00:00.000000 | |||
| last_seen | timestamp(6) | No | 0000-00-00 00:00:00.000000 | |||
| digest | varchar(64) | Yes | NULL |
x$statement_analysis
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| query | longtext | Yes | NULL | |||
| db | varchar(64) | Yes | NULL | |||
| full_scan | varchar(1) | No | ||||
| exec_count | bigint | No | ||||
| err_count | bigint | No | ||||
| warn_count | bigint | No | ||||
| total_latency | bigint | No | ||||
| max_latency | bigint | No | ||||
| avg_latency | bigint | No | ||||
| lock_latency | bigint | No | ||||
| rows_sent | bigint | No | ||||
| rows_sent_avg | decimal(21,0) | No | 0 | |||
| rows_examined | bigint | No | ||||
| rows_examined_avg | decimal(21,0) | No | 0 | |||
| rows_affected | bigint | No | ||||
| rows_affected_avg | decimal(21,0) | No | 0 | |||
| tmp_tables | bigint | No | ||||
| tmp_disk_tables | bigint | No | ||||
| rows_sorted | bigint | No | ||||
| sort_merge_passes | bigint | No | ||||
| digest | varchar(64) | Yes | NULL | |||
| first_seen | timestamp(6) | No | 0000-00-00 00:00:00.000000 | |||
| last_seen | timestamp(6) | No | 0000-00-00 00:00:00.000000 |
x$user_summary
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| user | varchar(32) | Yes | NULL | |||
| statements | decimal(64,0) | Yes | NULL | |||
| statement_latency | decimal(64,0) | Yes | NULL | |||
| statement_avg_latency | decimal(65,4) | No | 0.0000 | |||
| table_scans | decimal(65,0) | Yes | NULL | |||
| file_ios | decimal(64,0) | Yes | NULL | |||
| file_io_latency | decimal(64,0) | Yes | NULL | |||
| current_connections | decimal(41,0) | Yes | NULL | |||
| total_connections | decimal(41,0) | Yes | NULL | |||
| unique_hosts | bigint | No | 0 | |||
| current_memory | decimal(63,0) | Yes | NULL | |||
| total_memory_allocated | decimal(64,0) | Yes | NULL |
x$user_summary_by_file_io
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| user | varchar(32) | Yes | NULL | |||
| ios | decimal(42,0) | Yes | NULL | |||
| io_latency | decimal(42,0) | Yes | NULL |
x$user_summary_by_file_io_type
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| user | varchar(32) | Yes | NULL | |||
| event_name | varchar(128) | No | ||||
| total | bigint | No | ||||
| latency | bigint | No | ||||
| max_latency | bigint | No |
x$user_summary_by_stages
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| user | varchar(32) | Yes | NULL | |||
| event_name | varchar(128) | No | ||||
| total | bigint | No | ||||
| total_latency | bigint | No | ||||
| avg_latency | bigint | No |
x$user_summary_by_statement_latency
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| user | varchar(32) | Yes | NULL | |||
| total | decimal(42,0) | Yes | NULL | |||
| total_latency | decimal(42,0) | Yes | NULL | |||
| max_latency | decimal(42,0) | Yes | NULL | |||
| lock_latency | decimal(42,0) | Yes | NULL | |||
| rows_sent | decimal(42,0) | Yes | NULL | |||
| rows_examined | decimal(42,0) | Yes | NULL | |||
| rows_affected | decimal(42,0) | Yes | NULL | |||
| full_scans | decimal(43,0) | Yes | NULL |
x$user_summary_by_statement_type
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| user | varchar(32) | Yes | NULL | |||
| statement | varchar(128) | Yes | NULL | |||
| total | bigint | No | ||||
| total_latency | bigint | No | ||||
| max_latency | bigint | No | ||||
| lock_latency | bigint | No | ||||
| rows_sent | bigint | No | ||||
| rows_examined | bigint | No | ||||
| rows_affected | bigint | No | ||||
| full_scans | bigint | No | 0 |
x$waits_by_host_by_latency
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| host | varchar(255) | Yes | NULL | |||
| event | varchar(128) | No | ||||
| total | bigint | No | ||||
| total_latency | bigint | No | ||||
| avg_latency | bigint | No | ||||
| max_latency | bigint | No |
x$waits_by_user_by_latency
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| user | varchar(32) | Yes | NULL | |||
| event | varchar(128) | No | ||||
| total | bigint | No | ||||
| total_latency | bigint | No | ||||
| avg_latency | bigint | No | ||||
| max_latency | bigint | No |
x$waits_global_by_latency
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| events | varchar(128) | No | ||||
| total | bigint | No | ||||
| total_latency | bigint | No | ||||
| avg_latency | bigint | No | ||||
| max_latency | bigint | No |
x$wait_classes_global_by_avg_latency
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| event_class | varchar(128) | Yes | NULL | |||
| total | decimal(42,0) | Yes | NULL | |||
| total_latency | decimal(42,0) | Yes | NULL | |||
| min_latency | bigint | Yes | NULL | |||
| avg_latency | decimal(46,4) | No | 0.0000 | |||
| max_latency | bigint | Yes | NULL |
x$wait_classes_global_by_latency
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| event_class | varchar(128) | Yes | NULL | |||
| total | decimal(42,0) | Yes | NULL | |||
| total_latency | decimal(42,0) | Yes | NULL | |||
| min_latency | bigint | Yes | NULL | |||
| avg_latency | decimal(46,4) | No | 0.0000 | |||
| max_latency | bigint | Yes | NULL |