*
host
statements
statement_latency
statement_avg_latency
table_scans
file_ios
file_io_latency
current_connections
total_connections
unique_users
current_memory
total_memory_allocated
*
host
ios
io_latency
*
host
event_name
total
total_latency
max_latency
*
host
event_name
total
total_latency
avg_latency
*
host
total
total_latency
max_latency
lock_latency
cpu_latency
rows_sent
rows_examined
rows_affected
full_scans
*
host
statement
total
total_latency
max_latency
lock_latency
cpu_latency
rows_sent
rows_examined
rows_affected
full_scans
*
object_schema
allocated
data
pages
pages_hashed
pages_old
rows_cached
*
object_schema
object_name
allocated
data
pages
pages_hashed
pages_old
rows_cached
*
wait_started
wait_age
wait_age_secs
locked_table
locked_table_schema
locked_table_name
locked_table_partition
locked_table_subpartition
locked_index
locked_type
waiting_trx_id
waiting_trx_started
waiting_trx_age
waiting_trx_rows_locked
waiting_trx_rows_modified
waiting_pid
waiting_query
waiting_lock_id
waiting_lock_mode
blocking_trx_id
blocking_pid
blocking_query
blocking_lock_id
blocking_lock_mode
blocking_trx_started
blocking_trx_age
blocking_trx_rows_locked
blocking_trx_rows_modified
sql_kill_blocking_query
sql_kill_blocking_connection
*
user
total
total_latency
min_latency
avg_latency
max_latency
thread_id
processlist_id
*
file
count_read
total_read
avg_read
count_write
total_written
avg_write
total
write_pct
*
file
total
total_latency
count_read
read_latency
count_write
write_latency
count_misc
misc_latency
*
event_name
total
total_latency
min_latency
avg_latency
max_latency
count_read
total_read
avg_read
count_write
total_written
avg_written
total_requested
*
event_name
total
total_latency
avg_latency
max_latency
read_latency
write_latency
misc_latency
count_read
total_read
avg_read
count_write
total_written
avg_written
*
thread
file
latency
operation
requested
*
host
current_count_used
current_allocated
current_avg_alloc
current_max_alloc
total_allocated
*
thread_id
user
current_count_used
current_allocated
current_avg_alloc
current_max_alloc
total_allocated
*
user
current_count_used
current_allocated
current_avg_alloc
current_max_alloc
total_allocated
*
event_name
current_count
current_alloc
current_avg_alloc
high_count
high_alloc
high_avg_alloc
*
total_allocated
*
Variable_name
Variable_value
Type
Enabled
*
thd_id
conn_id
user
db
command
state
time
current_statement
execution_engine
statement_latency
progress
lock_latency
cpu_latency
rows_examined
rows_sent
rows_affected
tmp_tables
tmp_disk_tables
full_scan
last_statement
last_statement_latency
current_memory
last_wait
last_wait_latency
source
trx_latency
trx_state
trx_autocommit
pid
program_name
*
variable_name
variable_value
*
table_schema
table_name
column_name
data_type
column_type
is_signed
is_unsigned
max_value
auto_increment
auto_increment_ratio
*
table_schema
table_name
index_name
rows_selected
select_latency
rows_inserted
insert_latency
rows_updated
update_latency
rows_deleted
delete_latency
*
db
object_type
count
*
table_schema
table_name
redundant_index_name
redundant_index_columns
redundant_index_non_unique
dominant_index_name
dominant_index_columns
dominant_index_non_unique
subpart_exists
sql_drop_index
*
object_schema
object_name
rows_full_scanned
latency
*
object_schema
object_name
waiting_thread_id
waiting_pid
waiting_account
waiting_lock_type
waiting_lock_duration
waiting_query
waiting_query_secs
waiting_query_rows_affected
waiting_query_rows_examined
blocking_thread_id
blocking_pid
blocking_account
blocking_lock_type
blocking_lock_duration
sql_kill_blocking_query
sql_kill_blocking_connection
*
table_schema
table_name
total_latency
rows_fetched
fetch_latency
rows_inserted
insert_latency
rows_updated
update_latency
rows_deleted
delete_latency
io_read_requests
io_read
io_read_latency
io_write_requests
io_write
io_write_latency
io_misc_requests
io_misc_latency
*
table_schema
table_name
rows_fetched
fetch_latency
rows_inserted
insert_latency
rows_updated
update_latency
rows_deleted
delete_latency
io_read_requests
io_read
io_read_latency
io_write_requests
io_write
io_write_latency
io_misc_requests
io_misc_latency
innodb_buffer_allocated
innodb_buffer_data
innodb_buffer_free
innodb_buffer_pages
innodb_buffer_pages_hashed
innodb_buffer_pages_old
innodb_buffer_rows_cached
*
object_schema
object_name
index_name
*
thd_id
conn_id
user
db
command
state
time
current_statement
execution_engine
statement_latency
progress
lock_latency
cpu_latency
rows_examined
rows_sent
rows_affected
tmp_tables
tmp_disk_tables
full_scan
last_statement
last_statement_latency
current_memory
last_wait
last_wait_latency
source
trx_latency
trx_state
trx_autocommit
pid
program_name
*
thread_id
ssl_version
ssl_cipher
ssl_sessions_reused
*
query
db
exec_count
errors
error_pct
warnings
warning_pct
first_seen
last_seen
digest
*
query
db
exec_count
total_latency
no_index_used_count
no_good_index_used_count
no_index_used_pct
rows_sent
rows_examined
rows_sent_avg
rows_examined_avg
first_seen
last_seen
digest
*
query
db
full_scan
exec_count
err_count
warn_count
total_latency
max_latency
avg_latency
rows_sent
rows_sent_avg
rows_examined
rows_examined_avg
first_seen
last_seen
digest
*
query
db
exec_count
total_latency
sort_merge_passes
avg_sort_merges
sorts_using_scans
sort_using_range
rows_sorted
avg_rows_sorted
first_seen
last_seen
digest
*
query
db
exec_count
total_latency
memory_tmp_tables
disk_tmp_tables
avg_tmp_tables_per_query
tmp_tables_to_disk_pct
first_seen
last_seen
digest
*
query
db
full_scan
exec_count
err_count
warn_count
total_latency
max_latency
avg_latency
lock_latency
cpu_latency
rows_sent
rows_sent_avg
rows_examined
rows_examined_avg
rows_affected
rows_affected_avg
tmp_tables
tmp_disk_tables
rows_sorted
sort_merge_passes
max_controlled_memory
max_total_memory
digest
first_seen
last_seen
*
variable
value
set_time
set_by
*
user
statements
statement_latency
statement_avg_latency
table_scans
file_ios
file_io_latency
current_connections
total_connections
unique_hosts
current_memory
total_memory_allocated
*
user
ios
io_latency
*
user
event_name
total
latency
max_latency
*
user
event_name
total
total_latency
avg_latency
*
user
total
total_latency
max_latency
lock_latency
cpu_latency
rows_sent
rows_examined
rows_affected
full_scans
*
user
statement
total
total_latency
max_latency
lock_latency
cpu_latency
rows_sent
rows_examined
rows_affected
full_scans
*
sys_version
mysql_version
*
host
event
total
total_latency
avg_latency
max_latency
*
user
event
total
total_latency
avg_latency
max_latency
*
events
total
total_latency
avg_latency
max_latency
*
event_class
total
total_latency
min_latency
avg_latency
max_latency
*
event_class
total
total_latency
min_latency
avg_latency
max_latency
*
host
statements
statement_latency
statement_avg_latency
table_scans
file_ios
file_io_latency
current_connections
total_connections
unique_users
current_memory
total_memory_allocated
*
host
ios
io_latency
*
host
event_name
total
total_latency
max_latency
*
host
event_name
total
total_latency
avg_latency
*
host
total
total_latency
max_latency
lock_latency
cpu_latency
rows_sent
rows_examined
rows_affected
full_scans
*
host
statement
total
total_latency
max_latency
lock_latency
cpu_latency
rows_sent
rows_examined
rows_affected
full_scans
*
object_schema
allocated
data
pages
pages_hashed
pages_old
rows_cached
*
object_schema
object_name
allocated
data
pages
pages_hashed
pages_old
rows_cached
*
wait_started
wait_age
wait_age_secs
locked_table
locked_table_schema
locked_table_name
locked_table_partition
locked_table_subpartition
locked_index
locked_type
waiting_trx_id
waiting_trx_started
waiting_trx_age
waiting_trx_rows_locked
waiting_trx_rows_modified
waiting_pid
waiting_query
waiting_lock_id
waiting_lock_mode
blocking_trx_id
blocking_pid
blocking_query
blocking_lock_id
blocking_lock_mode
blocking_trx_started
blocking_trx_age
blocking_trx_rows_locked
blocking_trx_rows_modified
sql_kill_blocking_query
sql_kill_blocking_connection
*
user
total
total_latency
min_latency
avg_latency
max_latency
thread_id
processlist_id
*
file
count_read
total_read
avg_read
count_write
total_written
avg_write
total
write_pct
*
file
total
total_latency
count_read
read_latency
count_write
write_latency
count_misc
misc_latency
*
event_name
total
total_latency
min_latency
avg_latency
max_latency
count_read
total_read
avg_read
count_write
total_written
avg_written
total_requested
*
event_name
total
total_latency
avg_latency
max_latency
read_latency
write_latency
misc_latency
count_read
total_read
avg_read
count_write
total_written
avg_written
*
thread
file
latency
operation
requested
*
host
current_count_used
current_allocated
current_avg_alloc
current_max_alloc
total_allocated
*
thread_id
user
current_count_used
current_allocated
current_avg_alloc
current_max_alloc
total_allocated
*
user
current_count_used
current_allocated
current_avg_alloc
current_max_alloc
total_allocated
*
event_name
current_count
current_alloc
current_avg_alloc
high_count
high_alloc
high_avg_alloc
*
total_allocated
*
thd_id
conn_id
user
db
command
state
time
current_statement
execution_engine
statement_latency
progress
lock_latency
cpu_latency
rows_examined
rows_sent
rows_affected
tmp_tables
tmp_disk_tables
full_scan
last_statement
last_statement_latency
current_memory
last_wait
last_wait_latency
source
trx_latency
trx_state
trx_autocommit
pid
program_name
*
avg_us
percentile
*
cnt
avg_us
*
table_schema
table_name
count_read
sum_number_of_bytes_read
sum_timer_read
count_write
sum_number_of_bytes_write
sum_timer_write
count_misc
sum_timer_misc
*
table_schema
table_name
index_name
non_unique
subpart_exists
index_columns
*
table_schema
table_name
index_name
rows_selected
select_latency
rows_inserted
insert_latency
rows_updated
update_latency
rows_deleted
delete_latency
*
object_schema
object_name
rows_full_scanned
latency
*
object_schema
object_name
waiting_thread_id
waiting_pid
waiting_account
waiting_lock_type
waiting_lock_duration
waiting_query
waiting_query_secs
waiting_query_rows_affected
waiting_query_rows_examined
blocking_thread_id
blocking_pid
blocking_account
blocking_lock_type
blocking_lock_duration
sql_kill_blocking_query
sql_kill_blocking_connection
*
table_schema
table_name
total_latency
rows_fetched
fetch_latency
rows_inserted
insert_latency
rows_updated
update_latency
rows_deleted
delete_latency
io_read_requests
io_read
io_read_latency
io_write_requests
io_write
io_write_latency
io_misc_requests
io_misc_latency
*
table_schema
table_name
rows_fetched
fetch_latency
rows_inserted
insert_latency
rows_updated
update_latency
rows_deleted
delete_latency
io_read_requests
io_read
io_read_latency
io_write_requests
io_write
io_write_latency
io_misc_requests
io_misc_latency
innodb_buffer_allocated
innodb_buffer_data
innodb_buffer_free
innodb_buffer_pages
innodb_buffer_pages_hashed
innodb_buffer_pages_old
innodb_buffer_rows_cached
*
thd_id
conn_id
user
db
command
state
time
current_statement
execution_engine
statement_latency
progress
lock_latency
cpu_latency
rows_examined
rows_sent
rows_affected
tmp_tables
tmp_disk_tables
full_scan
last_statement
last_statement_latency
current_memory
last_wait
last_wait_latency
source
trx_latency
trx_state
trx_autocommit
pid
program_name
*
query
db
exec_count
errors
error_pct
warnings
warning_pct
first_seen
last_seen
digest
*
query
db
exec_count
total_latency
no_index_used_count
no_good_index_used_count
no_index_used_pct
rows_sent
rows_examined
rows_sent_avg
rows_examined_avg
first_seen
last_seen
digest
*
query
db
full_scan
exec_count
err_count
warn_count
total_latency
max_latency
avg_latency
rows_sent
rows_sent_avg
rows_examined
rows_examined_avg
first_seen
last_seen
digest
*
query
db
exec_count
total_latency
sort_merge_passes
avg_sort_merges
sorts_using_scans
sort_using_range
rows_sorted
avg_rows_sorted
first_seen
last_seen
digest
*
query
db
exec_count
total_latency
memory_tmp_tables
disk_tmp_tables
avg_tmp_tables_per_query
tmp_tables_to_disk_pct
first_seen
last_seen
digest
*
query
db
full_scan
exec_count
exec_secondary_count
err_count
warn_count
total_latency
max_latency
avg_latency
lock_latency
cpu_latency
rows_sent
rows_sent_avg
rows_examined
rows_examined_avg
rows_affected
rows_affected_avg
tmp_tables
tmp_disk_tables
rows_sorted
sort_merge_passes
max_controlled_memory
max_total_memory
digest
first_seen
last_seen
*
user
statements
statement_latency
statement_avg_latency
table_scans
file_ios
file_io_latency
current_connections
total_connections
unique_hosts
current_memory
total_memory_allocated
*
user
ios
io_latency
*
user
event_name
total
latency
max_latency
*
user
event_name
total
total_latency
avg_latency
*
user
total
total_latency
max_latency
lock_latency
cpu_latency
rows_sent
rows_examined
rows_affected
full_scans
*
user
statement
total
total_latency
max_latency
lock_latency
cpu_latency
rows_sent
rows_examined
rows_affected
full_scans
*
host
event
total
total_latency
avg_latency
max_latency
*
user
event
total
total_latency
avg_latency
max_latency
*
events
total
total_latency
avg_latency
max_latency
*
event_class
total
total_latency
min_latency
avg_latency
max_latency
*
event_class
total
total_latency
min_latency
avg_latency
max_latency
selecionar tabela
host_summary
host_summary_by_file_io
host_summary_by_file_io_type
host_summary_by_stages
host_summary_by_statement_latency
host_summary_by_statement_type
innodb_buffer_stats_by_schema
innodb_buffer_stats_by_table
innodb_lock_waits
io_by_thread_by_latency
io_global_by_file_by_bytes
io_global_by_file_by_latency
io_global_by_wait_by_bytes
io_global_by_wait_by_latency
latest_file_io
memory_by_host_by_current_bytes
memory_by_thread_by_current_bytes
memory_by_user_by_current_bytes
memory_global_by_current_bytes
memory_global_total
metrics
processlist
ps_check_lost_instrumentation
schema_auto_increment_columns
schema_index_statistics
schema_object_overview
schema_redundant_indexes
schema_tables_with_full_table_scans
schema_table_lock_waits
schema_table_statistics
schema_table_statistics_with_buffer
schema_unused_indexes
session
session_ssl_status
statements_with_errors_or_warnings
statements_with_full_table_scans
statements_with_runtimes_in_95th_percentile
statements_with_sorting
statements_with_temp_tables
statement_analysis
sys_config
user_summary
user_summary_by_file_io
user_summary_by_file_io_type
user_summary_by_stages
user_summary_by_statement_latency
user_summary_by_statement_type
version
waits_by_host_by_latency
waits_by_user_by_latency
waits_global_by_latency
wait_classes_global_by_avg_latency
wait_classes_global_by_latency
x$host_summary
x$host_summary_by_file_io
x$host_summary_by_file_io_type
x$host_summary_by_stages
x$host_summary_by_statement_latency
x$host_summary_by_statement_type
x$innodb_buffer_stats_by_schema
x$innodb_buffer_stats_by_table
x$innodb_lock_waits
x$io_by_thread_by_latency
x$io_global_by_file_by_bytes
x$io_global_by_file_by_latency
x$io_global_by_wait_by_bytes
x$io_global_by_wait_by_latency
x$latest_file_io
x$memory_by_host_by_current_bytes
x$memory_by_thread_by_current_bytes
x$memory_by_user_by_current_bytes
x$memory_global_by_current_bytes
x$memory_global_total
x$processlist
x$ps_digest_95th_percentile_by_avg_us
x$ps_digest_avg_latency_distribution
x$ps_schema_table_statistics_io
x$schema_flattened_keys
x$schema_index_statistics
x$schema_tables_with_full_table_scans
x$schema_table_lock_waits
x$schema_table_statistics
x$schema_table_statistics_with_buffer
x$session
x$statements_with_errors_or_warnings
x$statements_with_full_table_scans
x$statements_with_runtimes_in_95th_percentile
x$statements_with_sorting
x$statements_with_temp_tables
x$statement_analysis
x$user_summary
x$user_summary_by_file_io
x$user_summary_by_file_io_type
x$user_summary_by_stages
x$user_summary_by_statement_latency
x$user_summary_by_statement_type
x$waits_by_host_by_latency
x$waits_by_user_by_latency
x$waits_global_by_latency
x$wait_classes_global_by_avg_latency
x$wait_classes_global_by_latency
.
selecionar coluna
Mostrar
X
selecionar tabela
host_summary
host_summary_by_file_io
host_summary_by_file_io_type
host_summary_by_stages
host_summary_by_statement_latency
host_summary_by_statement_type
innodb_buffer_stats_by_schema
innodb_buffer_stats_by_table
innodb_lock_waits
io_by_thread_by_latency
io_global_by_file_by_bytes
io_global_by_file_by_latency
io_global_by_wait_by_bytes
io_global_by_wait_by_latency
latest_file_io
memory_by_host_by_current_bytes
memory_by_thread_by_current_bytes
memory_by_user_by_current_bytes
memory_global_by_current_bytes
memory_global_total
metrics
processlist
ps_check_lost_instrumentation
schema_auto_increment_columns
schema_index_statistics
schema_object_overview
schema_redundant_indexes
schema_tables_with_full_table_scans
schema_table_lock_waits
schema_table_statistics
schema_table_statistics_with_buffer
schema_unused_indexes
session
session_ssl_status
statements_with_errors_or_warnings
statements_with_full_table_scans
statements_with_runtimes_in_95th_percentile
statements_with_sorting
statements_with_temp_tables
statement_analysis
sys_config
user_summary
user_summary_by_file_io
user_summary_by_file_io_type
user_summary_by_stages
user_summary_by_statement_latency
user_summary_by_statement_type
version
waits_by_host_by_latency
waits_by_user_by_latency
waits_global_by_latency
wait_classes_global_by_avg_latency
wait_classes_global_by_latency
x$host_summary
x$host_summary_by_file_io
x$host_summary_by_file_io_type
x$host_summary_by_stages
x$host_summary_by_statement_latency
x$host_summary_by_statement_type
x$innodb_buffer_stats_by_schema
x$innodb_buffer_stats_by_table
x$innodb_lock_waits
x$io_by_thread_by_latency
x$io_global_by_file_by_bytes
x$io_global_by_file_by_latency
x$io_global_by_wait_by_bytes
x$io_global_by_wait_by_latency
x$latest_file_io
x$memory_by_host_by_current_bytes
x$memory_by_thread_by_current_bytes
x$memory_by_user_by_current_bytes
x$memory_global_by_current_bytes
x$memory_global_total
x$processlist
x$ps_digest_95th_percentile_by_avg_us
x$ps_digest_avg_latency_distribution
x$ps_schema_table_statistics_io
x$schema_flattened_keys
x$schema_index_statistics
x$schema_tables_with_full_table_scans
x$schema_table_lock_waits
x$schema_table_statistics
x$schema_table_statistics_with_buffer
x$session
x$statements_with_errors_or_warnings
x$statements_with_full_table_scans
x$statements_with_runtimes_in_95th_percentile
x$statements_with_sorting
x$statements_with_temp_tables
x$statement_analysis
x$user_summary
x$user_summary_by_file_io
x$user_summary_by_file_io_type
x$user_summary_by_stages
x$user_summary_by_statement_latency
x$user_summary_by_statement_type
x$waits_by_host_by_latency
x$waits_by_user_by_latency
x$waits_global_by_latency
x$wait_classes_global_by_avg_latency
x$wait_classes_global_by_latency
.
selecionar coluna
Mostrar
X
selecionar tabela
host_summary
host_summary_by_file_io
host_summary_by_file_io_type
host_summary_by_stages
host_summary_by_statement_latency
host_summary_by_statement_type
innodb_buffer_stats_by_schema
innodb_buffer_stats_by_table
innodb_lock_waits
io_by_thread_by_latency
io_global_by_file_by_bytes
io_global_by_file_by_latency
io_global_by_wait_by_bytes
io_global_by_wait_by_latency
latest_file_io
memory_by_host_by_current_bytes
memory_by_thread_by_current_bytes
memory_by_user_by_current_bytes
memory_global_by_current_bytes
memory_global_total
metrics
processlist
ps_check_lost_instrumentation
schema_auto_increment_columns
schema_index_statistics
schema_object_overview
schema_redundant_indexes
schema_tables_with_full_table_scans
schema_table_lock_waits
schema_table_statistics
schema_table_statistics_with_buffer
schema_unused_indexes
session
session_ssl_status
statements_with_errors_or_warnings
statements_with_full_table_scans
statements_with_runtimes_in_95th_percentile
statements_with_sorting
statements_with_temp_tables
statement_analysis
sys_config
user_summary
user_summary_by_file_io
user_summary_by_file_io_type
user_summary_by_stages
user_summary_by_statement_latency
user_summary_by_statement_type
version
waits_by_host_by_latency
waits_by_user_by_latency
waits_global_by_latency
wait_classes_global_by_avg_latency
wait_classes_global_by_latency
x$host_summary
x$host_summary_by_file_io
x$host_summary_by_file_io_type
x$host_summary_by_stages
x$host_summary_by_statement_latency
x$host_summary_by_statement_type
x$innodb_buffer_stats_by_schema
x$innodb_buffer_stats_by_table
x$innodb_lock_waits
x$io_by_thread_by_latency
x$io_global_by_file_by_bytes
x$io_global_by_file_by_latency
x$io_global_by_wait_by_bytes
x$io_global_by_wait_by_latency
x$latest_file_io
x$memory_by_host_by_current_bytes
x$memory_by_thread_by_current_bytes
x$memory_by_user_by_current_bytes
x$memory_global_by_current_bytes
x$memory_global_total
x$processlist
x$ps_digest_95th_percentile_by_avg_us
x$ps_digest_avg_latency_distribution
x$ps_schema_table_statistics_io
x$schema_flattened_keys
x$schema_index_statistics
x$schema_tables_with_full_table_scans
x$schema_table_lock_waits
x$schema_table_statistics
x$schema_table_statistics_with_buffer
x$session
x$statements_with_errors_or_warnings
x$statements_with_full_table_scans
x$statements_with_runtimes_in_95th_percentile
x$statements_with_sorting
x$statements_with_temp_tables
x$statement_analysis
x$user_summary
x$user_summary_by_file_io
x$user_summary_by_file_io_type
x$user_summary_by_stages
x$user_summary_by_statement_latency
x$user_summary_by_statement_type
x$waits_by_host_by_latency
x$waits_by_user_by_latency
x$waits_global_by_latency
x$wait_classes_global_by_avg_latency
x$wait_classes_global_by_latency
.
selecionar coluna
Mostrar
X