* 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

selectează tabelul 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 . selectează coloana
Arată

criteriu

Sortează	Crescător	Descrescător
Adaugă ca	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	Text O altă coloană
	selectează tabelul 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 .	selectează coloana