Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
host | varchar(255) | Yes | NULL | |
statements | decimal(64,0) | Yes | NULL | |
statement_latency | text | Yes | NULL | |
statement_avg_latency | text | Yes | NULL | |
table_scans | decimal(65,0) | Yes | NULL | |
file_ios | decimal(64,0) | Yes | NULL | |
file_io_latency | text | Yes | NULL | |
current_connections | decimal(41,0) | Yes | NULL | |
total_connections | decimal(41,0) | Yes | NULL | |
unique_users | bigint(21) | No | 0 | |
current_memory | text | Yes | NULL | |
total_memory_allocated | text | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
host | varchar(255) | Yes | NULL | |
ios | decimal(42,0) | Yes | NULL | |
io_latency | text | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
host | varchar(255) | Yes | NULL | |
event_name | varchar(128) | No | ||
total | bigint(20) | No | ||
total_latency | text | Yes | NULL | |
max_latency | text | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
host | varchar(255) | Yes | NULL | |
event_name | varchar(128) | No | ||
total | bigint(20) | No | ||
total_latency | text | Yes | NULL | |
avg_latency | text | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
host | varchar(255) | Yes | NULL | |
total | decimal(42,0) | Yes | NULL | |
total_latency | text | Yes | NULL | |
max_latency | text | Yes | NULL | |
lock_latency | text | 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 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
host | varchar(255) | Yes | NULL | |
statement | varchar(128) | Yes | NULL | |
total | bigint(20) | No | ||
total_latency | text | Yes | NULL | |
max_latency | text | Yes | NULL | |
lock_latency | text | Yes | NULL | |
rows_sent | bigint(20) | No | ||
rows_examined | bigint(20) | No | ||
rows_affected | bigint(20) | No | ||
full_scans | bigint(21) | No | 0 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
object_schema | text | Yes | NULL | |
allocated | text | Yes | NULL | |
data | text | Yes | NULL | |
pages | bigint(21) | No | 0 | |
pages_hashed | bigint(21) | No | 0 | |
pages_old | bigint(21) | No | 0 | |
rows_cached | decimal(44,0) | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
object_schema | text | Yes | NULL | |
object_name | text | Yes | NULL | |
allocated | text | Yes | NULL | |
data | text | Yes | NULL | |
pages | bigint(21) | No | 0 | |
pages_hashed | bigint(21) | No | 0 | |
pages_old | bigint(21) | No | 0 | |
rows_cached | decimal(44,0) | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
wait_started | datetime | Yes | NULL | |
wait_age | time | Yes | NULL | |
wait_age_secs | bigint(21) | 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(21) | No | 0 | |
waiting_trx_rows_modified | bigint(21) | No | 0 | |
waiting_pid | bigint(21) | 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(21) | 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(21) | No | 0 | |
blocking_trx_rows_modified | bigint(21) | No | 0 | |
sql_kill_blocking_query | varchar(32) | No | ||
sql_kill_blocking_connection | varchar(26) | No |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
user | varchar(288) | Yes | NULL | |
total | decimal(42,0) | Yes | NULL | |
total_latency | text | Yes | NULL | |
min_latency | text | Yes | NULL | |
avg_latency | text | Yes | NULL | |
max_latency | text | Yes | NULL | |
thread_id | bigint(20) | No | ||
processlist_id | bigint(20) | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
file | varchar(512) | Yes | NULL | |
count_read | bigint(20) | No | ||
total_read | text | Yes | NULL | |
avg_read | text | Yes | NULL | |
count_write | bigint(20) | No | ||
total_written | text | Yes | NULL | |
avg_write | text | Yes | NULL | |
total | text | Yes | NULL | |
write_pct | decimal(26,2) | No | 0.00 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
file | varchar(512) | Yes | NULL | |
total | bigint(20) | No | ||
total_latency | text | Yes | NULL | |
count_read | bigint(20) | No | ||
read_latency | text | Yes | NULL | |
count_write | bigint(20) | No | ||
write_latency | text | Yes | NULL | |
count_misc | bigint(20) | No | ||
misc_latency | text | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
event_name | varchar(128) | Yes | NULL | |
total | bigint(20) | No | ||
total_latency | text | Yes | NULL | |
min_latency | text | Yes | NULL | |
avg_latency | text | Yes | NULL | |
max_latency | text | Yes | NULL | |
count_read | bigint(20) | No | ||
total_read | text | Yes | NULL | |
avg_read | text | Yes | NULL | |
count_write | bigint(20) | No | ||
total_written | text | Yes | NULL | |
avg_written | text | Yes | NULL | |
total_requested | text | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
event_name | varchar(128) | Yes | NULL | |
total | bigint(20) | No | ||
total_latency | text | Yes | NULL | |
avg_latency | text | Yes | NULL | |
max_latency | text | Yes | NULL | |
read_latency | text | Yes | NULL | |
write_latency | text | Yes | NULL | |
misc_latency | text | Yes | NULL | |
count_read | bigint(20) | No | ||
total_read | text | Yes | NULL | |
avg_read | text | Yes | NULL | |
count_write | bigint(20) | No | ||
total_written | text | Yes | NULL | |
avg_written | text | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
thread | varchar(316) | Yes | NULL | |
file | varchar(512) | Yes | NULL | |
latency | text | Yes | NULL | |
operation | varchar(32) | No | ||
requested | text | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
host | varchar(255) | Yes | NULL | |
current_count_used | decimal(41,0) | Yes | NULL | |
current_allocated | text | Yes | NULL | |
current_avg_alloc | text | Yes | NULL | |
current_max_alloc | text | Yes | NULL | |
total_allocated | text | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
thread_id | bigint(20) | No | ||
user | varchar(288) | Yes | NULL | |
current_count_used | decimal(41,0) | Yes | NULL | |
current_allocated | text | Yes | NULL | |
current_avg_alloc | text | Yes | NULL | |
current_max_alloc | text | Yes | NULL | |
total_allocated | text | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
user | varchar(32) | Yes | NULL | |
current_count_used | decimal(41,0) | Yes | NULL | |
current_allocated | text | Yes | NULL | |
current_avg_alloc | text | Yes | NULL | |
current_max_alloc | text | Yes | NULL | |
total_allocated | text | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
event_name | varchar(128) | No | ||
current_count | bigint(20) | No | ||
current_alloc | text | Yes | NULL | |
current_avg_alloc | text | Yes | NULL | |
high_count | bigint(20) | No | ||
high_alloc | text | Yes | NULL | |
high_avg_alloc | text | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
total_allocated | text | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
Variable_name | varchar(193) | No | ||
Variable_value | text | Yes | NULL | |
Type | varchar(210) | No | ||
Enabled | varchar(7) | No |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
thd_id | bigint(20) | No | ||
conn_id | bigint(20) | Yes | NULL | |
user | varchar(288) | Yes | NULL | |
db | varchar(64) | Yes | NULL | |
command | varchar(16) | Yes | NULL | |
state | varchar(64) | Yes | NULL | |
time | bigint(20) | Yes | NULL | |
current_statement | longtext | Yes | NULL | |
statement_latency | text | Yes | NULL | |
progress | decimal(26,2) | Yes | NULL | |
lock_latency | text | Yes | NULL | |
rows_examined | bigint(20) | Yes | NULL | |
rows_sent | bigint(20) | Yes | NULL | |
rows_affected | bigint(20) | Yes | NULL | |
tmp_tables | bigint(20) | Yes | NULL | |
tmp_disk_tables | bigint(20) | Yes | NULL | |
full_scan | varchar(3) | No | ||
last_statement | longtext | Yes | NULL | |
last_statement_latency | text | Yes | NULL | |
current_memory | text | Yes | NULL | |
last_wait | varchar(128) | Yes | NULL | |
last_wait_latency | text | Yes | NULL | |
source | varchar(64) | Yes | NULL | |
trx_latency | text | 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 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
variable_name | varchar(64) | No | ||
variable_value | varchar(1024) | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
table_schema | varchar(64) | No | ||
table_name | varchar(64) | No | ||
column_name | varchar(64) | Yes | NULL | |
data_type | longtext | Yes | NULL | |
column_type | mediumtext | No | ||
is_signed | int(1) | No | 0 | |
is_unsigned | int(1) | No | 0 | |
max_value | bigint(21) | Yes | NULL | |
auto_increment | bigint(21) | Yes | NULL | |
auto_increment_ratio | decimal(25,4) | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
table_schema | varchar(64) | Yes | NULL | |
table_name | varchar(64) | Yes | NULL | |
index_name | varchar(64) | Yes | NULL | |
rows_selected | bigint(20) | No | ||
select_latency | text | Yes | NULL | |
rows_inserted | bigint(20) | No | ||
insert_latency | text | Yes | NULL | |
rows_updated | bigint(20) | No | ||
update_latency | text | Yes | NULL | |
rows_deleted | bigint(20) | No | ||
delete_latency | text | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
db | varchar(64) | No | ||
object_type | varchar(19) | Yes | NULL | |
count | bigint(21) | No | 0 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
table_schema | varchar(64) | No | ||
table_name | varchar(64) | No | ||
redundant_index_name | varchar(64) | Yes | NULL | |
redundant_index_columns | text | Yes | NULL | |
redundant_index_non_unique | int(1) | Yes | NULL | |
dominant_index_name | varchar(64) | Yes | NULL | |
dominant_index_columns | text | Yes | NULL | |
dominant_index_non_unique | int(1) | Yes | NULL | |
subpart_exists | int(1) | No | 0 | |
sql_drop_index | varchar(223) | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
object_schema | varchar(64) | Yes | NULL | |
object_name | varchar(64) | Yes | NULL | |
rows_full_scanned | bigint(20) | No | ||
latency | text | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
object_schema | varchar(64) | Yes | NULL | |
object_name | varchar(64) | Yes | NULL | |
waiting_thread_id | bigint(20) | No | ||
waiting_pid | bigint(20) | 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(20) | Yes | NULL | |
waiting_query_rows_affected | bigint(20) | Yes | NULL | |
waiting_query_rows_examined | bigint(20) | Yes | NULL | |
blocking_thread_id | bigint(20) | No | ||
blocking_pid | bigint(20) | 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 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
table_schema | varchar(64) | Yes | NULL | |
table_name | varchar(64) | Yes | NULL | |
total_latency | text | Yes | NULL | |
rows_fetched | bigint(20) | No | ||
fetch_latency | text | Yes | NULL | |
rows_inserted | bigint(20) | No | ||
insert_latency | text | Yes | NULL | |
rows_updated | bigint(20) | No | ||
update_latency | text | Yes | NULL | |
rows_deleted | bigint(20) | No | ||
delete_latency | text | Yes | NULL | |
io_read_requests | decimal(42,0) | Yes | NULL | |
io_read | text | Yes | NULL | |
io_read_latency | text | Yes | NULL | |
io_write_requests | decimal(42,0) | Yes | NULL | |
io_write | text | Yes | NULL | |
io_write_latency | text | Yes | NULL | |
io_misc_requests | decimal(42,0) | Yes | NULL | |
io_misc_latency | text | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
table_schema | varchar(64) | Yes | NULL | |
table_name | varchar(64) | Yes | NULL | |
rows_fetched | bigint(20) | No | ||
fetch_latency | text | Yes | NULL | |
rows_inserted | bigint(20) | No | ||
insert_latency | text | Yes | NULL | |
rows_updated | bigint(20) | No | ||
update_latency | text | Yes | NULL | |
rows_deleted | bigint(20) | No | ||
delete_latency | text | Yes | NULL | |
io_read_requests | decimal(42,0) | Yes | NULL | |
io_read | text | Yes | NULL | |
io_read_latency | text | Yes | NULL | |
io_write_requests | decimal(42,0) | Yes | NULL | |
io_write | text | Yes | NULL | |
io_write_latency | text | Yes | NULL | |
io_misc_requests | decimal(42,0) | Yes | NULL | |
io_misc_latency | text | Yes | NULL | |
innodb_buffer_allocated | text | Yes | NULL | |
innodb_buffer_data | text | Yes | NULL | |
innodb_buffer_free | text | Yes | NULL | |
innodb_buffer_pages | bigint(21) | Yes | 0 | |
innodb_buffer_pages_hashed | bigint(21) | Yes | 0 | |
innodb_buffer_pages_old | bigint(21) | Yes | 0 | |
innodb_buffer_rows_cached | decimal(44,0) | Yes | 0 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
object_schema | varchar(64) | Yes | NULL | |
object_name | varchar(64) | Yes | NULL | |
index_name | varchar(64) | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
thd_id | bigint(20) | No | ||
conn_id | bigint(20) | Yes | NULL | |
user | varchar(288) | Yes | NULL | |
db | varchar(64) | Yes | NULL | |
command | varchar(16) | Yes | NULL | |
state | varchar(64) | Yes | NULL | |
time | bigint(20) | Yes | NULL | |
current_statement | longtext | Yes | NULL | |
statement_latency | text | Yes | NULL | |
progress | decimal(26,2) | Yes | NULL | |
lock_latency | text | Yes | NULL | |
rows_examined | bigint(20) | Yes | NULL | |
rows_sent | bigint(20) | Yes | NULL | |
rows_affected | bigint(20) | Yes | NULL | |
tmp_tables | bigint(20) | Yes | NULL | |
tmp_disk_tables | bigint(20) | Yes | NULL | |
full_scan | varchar(3) | No | ||
last_statement | longtext | Yes | NULL | |
last_statement_latency | text | Yes | NULL | |
current_memory | text | Yes | NULL | |
last_wait | varchar(128) | Yes | NULL | |
last_wait_latency | text | Yes | NULL | |
source | varchar(64) | Yes | NULL | |
trx_latency | text | 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 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
thread_id | bigint(20) | No | ||
ssl_version | varchar(1024) | Yes | NULL | |
ssl_cipher | varchar(1024) | Yes | NULL | |
ssl_sessions_reused | varchar(1024) | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
query | longtext | Yes | NULL | |
db | varchar(64) | Yes | NULL | |
exec_count | bigint(20) | No | ||
errors | bigint(20) | No | ||
error_pct | decimal(27,4) | No | 0.0000 | |
warnings | bigint(20) | 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 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
query | longtext | Yes | NULL | |
db | varchar(64) | Yes | NULL | |
exec_count | bigint(20) | No | ||
total_latency | text | Yes | NULL | |
no_index_used_count | bigint(20) | No | ||
no_good_index_used_count | bigint(20) | No | ||
no_index_used_pct | decimal(24,0) | No | 0 | |
rows_sent | bigint(20) | No | ||
rows_examined | bigint(20) | 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 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
query | longtext | Yes | NULL | |
db | varchar(64) | Yes | NULL | |
full_scan | varchar(1) | No | ||
exec_count | bigint(20) | No | ||
err_count | bigint(20) | No | ||
warn_count | bigint(20) | No | ||
total_latency | text | Yes | NULL | |
max_latency | text | Yes | NULL | |
avg_latency | text | Yes | NULL | |
rows_sent | bigint(20) | No | ||
rows_sent_avg | decimal(21,0) | No | 0 | |
rows_examined | bigint(20) | 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 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
query | longtext | Yes | NULL | |
db | varchar(64) | Yes | NULL | |
exec_count | bigint(20) | No | ||
total_latency | text | Yes | NULL | |
sort_merge_passes | bigint(20) | No | ||
avg_sort_merges | decimal(21,0) | No | 0 | |
sorts_using_scans | bigint(20) | No | ||
sort_using_range | bigint(20) | No | ||
rows_sorted | bigint(20) | 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 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
query | longtext | Yes | NULL | |
db | varchar(64) | Yes | NULL | |
exec_count | bigint(20) | No | ||
total_latency | text | Yes | NULL | |
memory_tmp_tables | bigint(20) | No | ||
disk_tmp_tables | bigint(20) | 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 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
query | longtext | Yes | NULL | |
db | varchar(64) | Yes | NULL | |
full_scan | varchar(1) | No | ||
exec_count | bigint(20) | No | ||
err_count | bigint(20) | No | ||
warn_count | bigint(20) | No | ||
total_latency | text | Yes | NULL | |
max_latency | text | Yes | NULL | |
avg_latency | text | Yes | NULL | |
lock_latency | text | Yes | NULL | |
rows_sent | bigint(20) | No | ||
rows_sent_avg | decimal(21,0) | No | 0 | |
rows_examined | bigint(20) | No | ||
rows_examined_avg | decimal(21,0) | No | 0 | |
rows_affected | bigint(20) | No | ||
rows_affected_avg | decimal(21,0) | No | 0 | |
tmp_tables | bigint(20) | No | ||
tmp_disk_tables | bigint(20) | No | ||
rows_sorted | bigint(20) | No | ||
sort_merge_passes | bigint(20) | 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 |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
variable (Primary) | varchar(128) | No | ||
value | varchar(128) | Yes | NULL | |
set_time | timestamp | Yes | CURRENT_TIMESTAMP | |
set_by | varchar(128) | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | variable | 2 | A | No |
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
user | varchar(32) | Yes | NULL | |
statements | decimal(64,0) | Yes | NULL | |
statement_latency | text | Yes | NULL | |
statement_avg_latency | text | Yes | NULL | |
table_scans | decimal(65,0) | Yes | NULL | |
file_ios | decimal(64,0) | Yes | NULL | |
file_io_latency | text | Yes | NULL | |
current_connections | decimal(41,0) | Yes | NULL | |
total_connections | decimal(41,0) | Yes | NULL | |
unique_hosts | bigint(21) | No | 0 | |
current_memory | text | Yes | NULL | |
total_memory_allocated | text | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
user | varchar(32) | Yes | NULL | |
ios | decimal(42,0) | Yes | NULL | |
io_latency | text | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
user | varchar(32) | Yes | NULL | |
event_name | varchar(128) | No | ||
total | bigint(20) | No | ||
latency | text | Yes | NULL | |
max_latency | text | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
user | varchar(32) | Yes | NULL | |
event_name | varchar(128) | No | ||
total | bigint(20) | No | ||
total_latency | text | Yes | NULL | |
avg_latency | text | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
user | varchar(32) | Yes | NULL | |
total | decimal(42,0) | Yes | NULL | |
total_latency | text | Yes | NULL | |
max_latency | text | Yes | NULL | |
lock_latency | text | 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 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
user | varchar(32) | Yes | NULL | |
statement | varchar(128) | Yes | NULL | |
total | bigint(20) | No | ||
total_latency | text | Yes | NULL | |
max_latency | text | Yes | NULL | |
lock_latency | text | Yes | NULL | |
rows_sent | bigint(20) | No | ||
rows_examined | bigint(20) | No | ||
rows_affected | bigint(20) | No | ||
full_scans | bigint(21) | No | 0 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
sys_version | varchar(5) | No | ||
mysql_version | varchar(6) | No |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
host | varchar(255) | Yes | NULL | |
event | varchar(128) | No | ||
total | bigint(20) | No | ||
total_latency | text | Yes | NULL | |
avg_latency | text | Yes | NULL | |
max_latency | text | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
user | varchar(32) | Yes | NULL | |
event | varchar(128) | No | ||
total | bigint(20) | No | ||
total_latency | text | Yes | NULL | |
avg_latency | text | Yes | NULL | |
max_latency | text | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
events | varchar(128) | No | ||
total | bigint(20) | No | ||
total_latency | text | Yes | NULL | |
avg_latency | text | Yes | NULL | |
max_latency | text | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
event_class | varchar(128) | Yes | NULL | |
total | decimal(42,0) | Yes | NULL | |
total_latency | text | Yes | NULL | |
min_latency | text | Yes | NULL | |
avg_latency | text | Yes | NULL | |
max_latency | text | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
event_class | varchar(128) | Yes | NULL | |
total | decimal(42,0) | Yes | NULL | |
total_latency | text | Yes | NULL | |
min_latency | text | Yes | NULL | |
avg_latency | text | Yes | NULL | |
max_latency | text | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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(21) | No | 0 | |
current_memory | decimal(63,0) | Yes | NULL | |
total_memory_allocated | decimal(64,0) | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
host | varchar(255) | Yes | NULL | |
ios | decimal(42,0) | Yes | NULL | |
io_latency | decimal(42,0) | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
host | varchar(255) | Yes | NULL | |
event_name | varchar(128) | No | ||
total | bigint(20) | No | ||
total_latency | bigint(20) | No | ||
max_latency | bigint(20) | No |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
host | varchar(255) | Yes | NULL | |
event_name | varchar(128) | No | ||
total | bigint(20) | No | ||
total_latency | bigint(20) | No | ||
avg_latency | bigint(20) | No |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
host | varchar(255) | Yes | NULL | |
total | decimal(42,0) | Yes | NULL | |
total_latency | decimal(42,0) | Yes | NULL | |
max_latency | bigint(20) | 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 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
host | varchar(255) | Yes | NULL | |
statement | varchar(128) | Yes | NULL | |
total | bigint(20) | No | ||
total_latency | bigint(20) | No | ||
max_latency | bigint(20) | No | ||
lock_latency | bigint(20) | No | ||
rows_sent | bigint(20) | No | ||
rows_examined | bigint(20) | No | ||
rows_affected | bigint(20) | No | ||
full_scans | bigint(21) | No | 0 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
object_schema | text | Yes | NULL | |
allocated | decimal(43,0) | Yes | NULL | |
data | decimal(43,0) | Yes | NULL | |
pages | bigint(21) | No | 0 | |
pages_hashed | bigint(21) | No | 0 | |
pages_old | bigint(21) | No | 0 | |
rows_cached | decimal(44,0) | No | 0 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
object_schema | text | Yes | NULL | |
object_name | text | Yes | NULL | |
allocated | decimal(43,0) | Yes | NULL | |
data | decimal(43,0) | Yes | NULL | |
pages | bigint(21) | No | 0 | |
pages_hashed | bigint(21) | No | 0 | |
pages_old | bigint(21) | No | 0 | |
rows_cached | decimal(44,0) | No | 0 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
wait_started | datetime | Yes | NULL | |
wait_age | time | Yes | NULL | |
wait_age_secs | bigint(21) | 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(21) | No | 0 | |
waiting_trx_rows_modified | bigint(21) | No | 0 | |
waiting_pid | bigint(21) | 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(21) | 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(21) | No | 0 | |
blocking_trx_rows_modified | bigint(21) | No | 0 | |
sql_kill_blocking_query | varchar(32) | No | ||
sql_kill_blocking_connection | varchar(26) | No |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
user | varchar(288) | Yes | NULL | |
total | decimal(42,0) | Yes | NULL | |
total_latency | decimal(42,0) | Yes | NULL | |
min_latency | bigint(20) | Yes | NULL | |
avg_latency | decimal(24,4) | Yes | NULL | |
max_latency | bigint(20) | Yes | NULL | |
thread_id | bigint(20) | No | ||
processlist_id | bigint(20) | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
file | varchar(512) | No | ||
count_read | bigint(20) | No | ||
total_read | bigint(20) | No | ||
avg_read | decimal(23,4) | No | 0.0000 | |
count_write | bigint(20) | No | ||
total_written | bigint(20) | No | ||
avg_write | decimal(23,4) | No | 0.0000 | |
total | bigint(21) | No | 0 | |
write_pct | decimal(26,2) | No | 0.00 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
file | varchar(512) | No | ||
total | bigint(20) | No | ||
total_latency | bigint(20) | No | ||
count_read | bigint(20) | No | ||
read_latency | bigint(20) | No | ||
count_write | bigint(20) | No | ||
write_latency | bigint(20) | No | ||
count_misc | bigint(20) | No | ||
misc_latency | bigint(20) | No |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
event_name | varchar(128) | Yes | NULL | |
total | bigint(20) | No | ||
total_latency | bigint(20) | No | ||
min_latency | bigint(20) | No | ||
avg_latency | bigint(20) | No | ||
max_latency | bigint(20) | No | ||
count_read | bigint(20) | No | ||
total_read | bigint(20) | No | ||
avg_read | decimal(23,4) | No | 0.0000 | |
count_write | bigint(20) | No | ||
total_written | bigint(20) | No | ||
avg_written | decimal(23,4) | No | 0.0000 | |
total_requested | bigint(21) | No | 0 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
event_name | varchar(128) | Yes | NULL | |
total | bigint(20) | No | ||
total_latency | bigint(20) | No | ||
avg_latency | bigint(20) | No | ||
max_latency | bigint(20) | No | ||
read_latency | bigint(20) | No | ||
write_latency | bigint(20) | No | ||
misc_latency | bigint(20) | No | ||
count_read | bigint(20) | No | ||
total_read | bigint(20) | No | ||
avg_read | decimal(23,4) | No | 0.0000 | |
count_write | bigint(20) | No | ||
total_written | bigint(20) | No | ||
avg_written | decimal(23,4) | No | 0.0000 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
thread | varchar(316) | Yes | NULL | |
file | varchar(512) | Yes | NULL | |
latency | bigint(20) | Yes | NULL | |
operation | varchar(32) | No | ||
requested | bigint(20) | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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(20) | Yes | NULL | |
total_allocated | decimal(42,0) | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
thread_id | bigint(20) | 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(20) | Yes | NULL | |
total_allocated | decimal(42,0) | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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(20) | Yes | NULL | |
total_allocated | decimal(42,0) | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
event_name | varchar(128) | No | ||
current_count | bigint(20) | No | ||
current_alloc | bigint(20) | No | ||
current_avg_alloc | decimal(23,4) | No | 0.0000 | |
high_count | bigint(20) | No | ||
high_alloc | bigint(20) | No | ||
high_avg_alloc | decimal(23,4) | No | 0.0000 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
total_allocated | decimal(41,0) | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
thd_id | bigint(20) | No | ||
conn_id | bigint(20) | Yes | NULL | |
user | varchar(288) | Yes | NULL | |
db | varchar(64) | Yes | NULL | |
command | varchar(16) | Yes | NULL | |
state | varchar(64) | Yes | NULL | |
time | bigint(20) | Yes | NULL | |
current_statement | longtext | Yes | NULL | |
statement_latency | bigint(20) | Yes | NULL | |
progress | decimal(26,2) | Yes | NULL | |
lock_latency | bigint(20) | Yes | NULL | |
rows_examined | bigint(20) | Yes | NULL | |
rows_sent | bigint(20) | Yes | NULL | |
rows_affected | bigint(20) | Yes | NULL | |
tmp_tables | bigint(20) | Yes | NULL | |
tmp_disk_tables | bigint(20) | Yes | NULL | |
full_scan | varchar(3) | No | ||
last_statement | longtext | Yes | NULL | |
last_statement_latency | bigint(20) | 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(20) | 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 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
avg_us | decimal(21,0) | Yes | NULL | |
percentile | decimal(46,4) | No | 0.0000 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
cnt | bigint(21) | No | 0 | |
avg_us | decimal(21,0) | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
table_schema | varchar(64) | No | ||
table_name | varchar(64) | No | ||
index_name | varchar(64) | Yes | NULL | |
non_unique | int(1) | Yes | NULL | |
subpart_exists | bigint(1) | Yes | NULL | |
index_columns | text | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
table_schema | varchar(64) | Yes | NULL | |
table_name | varchar(64) | Yes | NULL | |
index_name | varchar(64) | Yes | NULL | |
rows_selected | bigint(20) | No | ||
select_latency | bigint(20) | No | ||
rows_inserted | bigint(20) | No | ||
insert_latency | bigint(20) | No | ||
rows_updated | bigint(20) | No | ||
update_latency | bigint(20) | No | ||
rows_deleted | bigint(20) | No | ||
delete_latency | bigint(20) | No |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
object_schema | varchar(64) | Yes | NULL | |
object_name | varchar(64) | Yes | NULL | |
rows_full_scanned | bigint(20) | No | ||
latency | bigint(20) | No |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
object_schema | varchar(64) | Yes | NULL | |
object_name | varchar(64) | Yes | NULL | |
waiting_thread_id | bigint(20) | No | ||
waiting_pid | bigint(20) | 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(20) | Yes | NULL | |
waiting_query_rows_affected | bigint(20) | Yes | NULL | |
waiting_query_rows_examined | bigint(20) | Yes | NULL | |
blocking_thread_id | bigint(20) | No | ||
blocking_pid | bigint(20) | 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 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
table_schema | varchar(64) | Yes | NULL | |
table_name | varchar(64) | Yes | NULL | |
total_latency | bigint(20) | No | ||
rows_fetched | bigint(20) | No | ||
fetch_latency | bigint(20) | No | ||
rows_inserted | bigint(20) | No | ||
insert_latency | bigint(20) | No | ||
rows_updated | bigint(20) | No | ||
update_latency | bigint(20) | No | ||
rows_deleted | bigint(20) | No | ||
delete_latency | bigint(20) | 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 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
table_schema | varchar(64) | Yes | NULL | |
table_name | varchar(64) | Yes | NULL | |
rows_fetched | bigint(20) | No | ||
fetch_latency | bigint(20) | No | ||
rows_inserted | bigint(20) | No | ||
insert_latency | bigint(20) | No | ||
rows_updated | bigint(20) | No | ||
update_latency | bigint(20) | No | ||
rows_deleted | bigint(20) | No | ||
delete_latency | bigint(20) | 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(21) | Yes | 0 | |
innodb_buffer_pages_hashed | bigint(21) | Yes | 0 | |
innodb_buffer_pages_old | bigint(21) | Yes | 0 | |
innodb_buffer_rows_cached | decimal(44,0) | Yes | 0 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
thd_id | bigint(20) | No | ||
conn_id | bigint(20) | Yes | NULL | |
user | varchar(288) | Yes | NULL | |
db | varchar(64) | Yes | NULL | |
command | varchar(16) | Yes | NULL | |
state | varchar(64) | Yes | NULL | |
time | bigint(20) | Yes | NULL | |
current_statement | longtext | Yes | NULL | |
statement_latency | bigint(20) | Yes | NULL | |
progress | decimal(26,2) | Yes | NULL | |
lock_latency | bigint(20) | Yes | NULL | |
rows_examined | bigint(20) | Yes | NULL | |
rows_sent | bigint(20) | Yes | NULL | |
rows_affected | bigint(20) | Yes | NULL | |
tmp_tables | bigint(20) | Yes | NULL | |
tmp_disk_tables | bigint(20) | Yes | NULL | |
full_scan | varchar(3) | No | ||
last_statement | longtext | Yes | NULL | |
last_statement_latency | bigint(20) | 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(20) | 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 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
query | longtext | Yes | NULL | |
db | varchar(64) | Yes | NULL | |
exec_count | bigint(20) | No | ||
errors | bigint(20) | No | ||
error_pct | decimal(27,4) | No | 0.0000 | |
warnings | bigint(20) | 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 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
query | longtext | Yes | NULL | |
db | varchar(64) | Yes | NULL | |
exec_count | bigint(20) | No | ||
total_latency | bigint(20) | No | ||
no_index_used_count | bigint(20) | No | ||
no_good_index_used_count | bigint(20) | No | ||
no_index_used_pct | decimal(24,0) | No | 0 | |
rows_sent | bigint(20) | No | ||
rows_examined | bigint(20) | 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 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
query | longtext | Yes | NULL | |
db | varchar(64) | Yes | NULL | |
full_scan | varchar(1) | No | ||
exec_count | bigint(20) | No | ||
err_count | bigint(20) | No | ||
warn_count | bigint(20) | No | ||
total_latency | bigint(20) | No | ||
max_latency | bigint(20) | No | ||
avg_latency | bigint(20) | No | ||
rows_sent | bigint(20) | No | ||
rows_sent_avg | decimal(21,0) | No | 0 | |
rows_examined | bigint(20) | 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 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
query | longtext | Yes | NULL | |
db | varchar(64) | Yes | NULL | |
exec_count | bigint(20) | No | ||
total_latency | bigint(20) | No | ||
sort_merge_passes | bigint(20) | No | ||
avg_sort_merges | decimal(21,0) | No | 0 | |
sorts_using_scans | bigint(20) | No | ||
sort_using_range | bigint(20) | No | ||
rows_sorted | bigint(20) | 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 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
query | longtext | Yes | NULL | |
db | varchar(64) | Yes | NULL | |
exec_count | bigint(20) | No | ||
total_latency | bigint(20) | No | ||
memory_tmp_tables | bigint(20) | No | ||
disk_tmp_tables | bigint(20) | 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 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
query | longtext | Yes | NULL | |
db | varchar(64) | Yes | NULL | |
full_scan | varchar(1) | No | ||
exec_count | bigint(20) | No | ||
err_count | bigint(20) | No | ||
warn_count | bigint(20) | No | ||
total_latency | bigint(20) | No | ||
max_latency | bigint(20) | No | ||
avg_latency | bigint(20) | No | ||
lock_latency | bigint(20) | No | ||
rows_sent | bigint(20) | No | ||
rows_sent_avg | decimal(21,0) | No | 0 | |
rows_examined | bigint(20) | No | ||
rows_examined_avg | decimal(21,0) | No | 0 | |
rows_affected | bigint(20) | No | ||
rows_affected_avg | decimal(21,0) | No | 0 | |
tmp_tables | bigint(20) | No | ||
tmp_disk_tables | bigint(20) | No | ||
rows_sorted | bigint(20) | No | ||
sort_merge_passes | bigint(20) | 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 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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(21) | No | 0 | |
current_memory | decimal(63,0) | Yes | NULL | |
total_memory_allocated | decimal(64,0) | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
user | varchar(32) | Yes | NULL | |
ios | decimal(42,0) | Yes | NULL | |
io_latency | decimal(42,0) | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
user | varchar(32) | Yes | NULL | |
event_name | varchar(128) | No | ||
total | bigint(20) | No | ||
latency | bigint(20) | No | ||
max_latency | bigint(20) | No |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
user | varchar(32) | Yes | NULL | |
event_name | varchar(128) | No | ||
total | bigint(20) | No | ||
total_latency | bigint(20) | No | ||
avg_latency | bigint(20) | No |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
user | varchar(32) | Yes | NULL | |
statement | varchar(128) | Yes | NULL | |
total | bigint(20) | No | ||
total_latency | bigint(20) | No | ||
max_latency | bigint(20) | No | ||
lock_latency | bigint(20) | No | ||
rows_sent | bigint(20) | No | ||
rows_examined | bigint(20) | No | ||
rows_affected | bigint(20) | No | ||
full_scans | bigint(21) | No | 0 |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
host | varchar(255) | Yes | NULL | |
event | varchar(128) | No | ||
total | bigint(20) | No | ||
total_latency | bigint(20) | No | ||
avg_latency | bigint(20) | No | ||
max_latency | bigint(20) | No |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
user | varchar(32) | Yes | NULL | |
event | varchar(128) | No | ||
total | bigint(20) | No | ||
total_latency | bigint(20) | No | ||
avg_latency | bigint(20) | No | ||
max_latency | bigint(20) | No |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
events | varchar(128) | No | ||
total | bigint(20) | No | ||
total_latency | bigint(20) | No | ||
avg_latency | bigint(20) | No | ||
max_latency | bigint(20) | No |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
event_class | varchar(128) | Yes | NULL | |
total | decimal(42,0) | Yes | NULL | |
total_latency | decimal(42,0) | Yes | NULL | |
min_latency | bigint(20) | Yes | NULL | |
avg_latency | decimal(46,4) | No | 0.0000 | |
max_latency | bigint(20) | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
event_class | varchar(128) | Yes | NULL | |
total | decimal(42,0) | Yes | NULL | |
total_latency | decimal(42,0) | Yes | NULL | |
min_latency | bigint(20) | Yes | NULL | |
avg_latency | decimal(46,4) | No | 0.0000 | |
max_latency | bigint(20) | Yes | NULL |
No index defined!