| def |
sys |
version |
select '2.1.2' AS `sys_version`,version() AS `mysq...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
innodb_buffer_stats_by_schema |
select if((locate('.',`ibp`.`TABLE_NAME`) = 0),'In...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$innodb_buffer_stats_by_schema |
select if((locate('.',`ibp`.`TABLE_NAME`) = 0),'In...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
innodb_buffer_stats_by_table |
select if((locate('.',`ibp`.`TABLE_NAME`) = 0),'In...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$innodb_buffer_stats_by_table |
select if((locate('.',`ibp`.`TABLE_NAME`) = 0),'In...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
schema_object_overview |
select `information_schema`.`routines`.`ROUTINE_SC...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
schema_auto_increment_columns |
select `information_schema`.`columns`.`TABLE_SCHEM...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$schema_flattened_keys |
select `information_schema`.`statistics`.`TABLE_SC...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
schema_redundant_indexes |
select `sys`.`redundant_keys`.`table_schema` AS `t...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
ps_check_lost_instrumentation |
select `performance_schema`.`global_status`.`VARIA...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
latest_file_io |
select if((`information_schema`.`processlist`.`ID`...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$latest_file_io |
select if((`information_schema`.`processlist`.`ID`...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
io_by_thread_by_latency |
select if((`performance_schema`.`threads`.`PROCESS...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$io_by_thread_by_latency |
select if((`performance_schema`.`threads`.`PROCESS...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
io_global_by_file_by_bytes |
select `sys`.`format_path`(`performance_schema`.`f...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$io_global_by_file_by_bytes |
select `performance_schema`.`file_summary_by_insta...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
io_global_by_file_by_latency |
select `sys`.`format_path`(`performance_schema`.`f...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$io_global_by_file_by_latency |
select `performance_schema`.`file_summary_by_insta...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
io_global_by_wait_by_bytes |
select substring_index(`performance_schema`.`file_...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$io_global_by_wait_by_bytes |
select substring_index(`performance_schema`.`file_...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
io_global_by_wait_by_latency |
select substring_index(`performance_schema`.`file_...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$io_global_by_wait_by_latency |
select substring_index(`performance_schema`.`file_...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
innodb_lock_waits |
select `r`.`trx_wait_started` AS `wait_started`,ti...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$innodb_lock_waits |
select `r`.`trx_wait_started` AS `wait_started`,ti...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
memory_by_user_by_current_bytes |
select if((`performance_schema`.`memory_summary_by...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$memory_by_user_by_current_bytes |
select if((`performance_schema`.`memory_summary_by...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
memory_by_host_by_current_bytes |
select if((`performance_schema`.`memory_summary_by...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$memory_by_host_by_current_bytes |
select if((`performance_schema`.`memory_summary_by...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
memory_by_thread_by_current_bytes |
select `mt`.`THREAD_ID` AS `thread_id`,if((`t`.`NA...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$memory_by_thread_by_current_bytes |
select `t`.`THREAD_ID` AS `thread_id`,if((`t`.`NAM...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
memory_global_by_current_bytes |
select `performance_schema`.`memory_summary_global...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$memory_global_by_current_bytes |
select `performance_schema`.`memory_summary_global...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
memory_global_total |
select format_bytes(sum(`performance_schema`.`memo...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$memory_global_total |
select sum(`performance_schema`.`memory_summary_gl...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
schema_index_statistics |
select `performance_schema`.`table_io_waits_summar...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$schema_index_statistics |
select `performance_schema`.`table_io_waits_summar...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$ps_schema_table_statistics_io |
select `extract_schema_from_file_name`(`performanc...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
schema_table_statistics |
select `pst`.`OBJECT_SCHEMA` AS `table_schema`,`ps...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$schema_table_statistics |
select `pst`.`OBJECT_SCHEMA` AS `table_schema`,`ps...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
schema_table_statistics_with_buffer |
select `pst`.`OBJECT_SCHEMA` AS `table_schema`,`ps...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$schema_table_statistics_with_buffer |
select `pst`.`OBJECT_SCHEMA` AS `table_schema`,`ps...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
schema_tables_with_full_table_scans |
select `performance_schema`.`table_io_waits_summar...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$schema_tables_with_full_table_scans |
select `performance_schema`.`table_io_waits_summar...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
schema_unused_indexes |
select `t`.`OBJECT_SCHEMA` AS `object_schema`,`t`....
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
schema_table_lock_waits |
select `g`.`OBJECT_SCHEMA` AS `object_schema`,`g`....
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$schema_table_lock_waits |
select `g`.`OBJECT_SCHEMA` AS `object_schema`,`g`....
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
statement_analysis |
select `sys`.`format_statement`(`performance_schem...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$statement_analysis |
select `performance_schema`.`events_statements_sum...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
statements_with_errors_or_warnings |
select `sys`.`format_statement`(`performance_schem...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$statements_with_errors_or_warnings |
select `performance_schema`.`events_statements_sum...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
statements_with_full_table_scans |
select `sys`.`format_statement`(`performance_schem...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$statements_with_full_table_scans |
select `performance_schema`.`events_statements_sum...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$ps_digest_avg_latency_distribution |
select count(0) AS `cnt`,round((`performance_schem...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$ps_digest_95th_percentile_by_avg_us |
select `sys`.`s2`.`avg_us` AS `avg_us`,ifnull((sum...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
statements_with_runtimes_in_95th_percentile |
select `sys`.`format_statement`(`stmts`.`DIGEST_TE...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$statements_with_runtimes_in_95th_percentile |
select `stmts`.`DIGEST_TEXT` AS `query`,`stmts`.`S...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
statements_with_sorting |
select `sys`.`format_statement`(`performance_schem...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$statements_with_sorting |
select `performance_schema`.`events_statements_sum...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
statements_with_temp_tables |
select `sys`.`format_statement`(`performance_schem...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$statements_with_temp_tables |
select `performance_schema`.`events_statements_sum...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
user_summary_by_file_io_type |
select if((`performance_schema`.`events_waits_summ...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$user_summary_by_file_io_type |
select if((`performance_schema`.`events_waits_summ...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
user_summary_by_file_io |
select if((`performance_schema`.`events_waits_summ...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$user_summary_by_file_io |
select if((`performance_schema`.`events_waits_summ...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
user_summary_by_statement_type |
select if((`performance_schema`.`events_statements...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$user_summary_by_statement_type |
select if((`performance_schema`.`events_statements...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
user_summary_by_statement_latency |
select if((`performance_schema`.`events_statements...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$user_summary_by_statement_latency |
select if((`performance_schema`.`events_statements...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
user_summary_by_stages |
select if((`performance_schema`.`events_stages_sum...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$user_summary_by_stages |
select if((`performance_schema`.`events_stages_sum...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
user_summary |
select if((`performance_schema`.`accounts`.`USER` ...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$user_summary |
select if((`performance_schema`.`accounts`.`USER` ...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
host_summary_by_file_io_type |
select if((`performance_schema`.`events_waits_summ...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$host_summary_by_file_io_type |
select if((`performance_schema`.`events_waits_summ...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
host_summary_by_file_io |
select if((`performance_schema`.`events_waits_summ...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$host_summary_by_file_io |
select if((`performance_schema`.`events_waits_summ...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
host_summary_by_statement_type |
select if((`performance_schema`.`events_statements...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$host_summary_by_statement_type |
select if((`performance_schema`.`events_statements...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
host_summary_by_statement_latency |
select if((`performance_schema`.`events_statements...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$host_summary_by_statement_latency |
select if((`performance_schema`.`events_statements...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
host_summary_by_stages |
select if((`performance_schema`.`events_stages_sum...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$host_summary_by_stages |
select if((`performance_schema`.`events_stages_sum...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
host_summary |
select if((`performance_schema`.`accounts`.`HOST` ...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$host_summary |
select if((`performance_schema`.`accounts`.`HOST` ...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
wait_classes_global_by_avg_latency |
select substring_index(`performance_schema`.`event...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$wait_classes_global_by_avg_latency |
select substring_index(`performance_schema`.`event...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
wait_classes_global_by_latency |
select substring_index(`performance_schema`.`event...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$wait_classes_global_by_latency |
select substring_index(`performance_schema`.`event...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
waits_by_user_by_latency |
select if((`performance_schema`.`events_waits_summ...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$waits_by_user_by_latency |
select if((`performance_schema`.`events_waits_summ...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
waits_by_host_by_latency |
select if((`performance_schema`.`events_waits_summ...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$waits_by_host_by_latency |
select if((`performance_schema`.`events_waits_summ...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
waits_global_by_latency |
select `performance_schema`.`events_waits_summary_...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$waits_global_by_latency |
select `performance_schema`.`events_waits_summary_...
|
NONE |
YES |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
metrics |
select lower(`performance_schema`.`global_status`....
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
processlist |
select `pps`.`THREAD_ID` AS `thd_id`,`pps`.`PROCES...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$processlist |
select `pps`.`THREAD_ID` AS `thd_id`,`pps`.`PROCES...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
session |
select `sys`.`processlist`.`thd_id` AS `thd_id`,`s...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
x$session |
select `sys`.`x$processlist`.`thd_id` AS `thd_id`,...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |
| def |
sys |
session_ssl_status |
select `sslver`.`THREAD_ID` AS `thread_id`,`sslver...
|
NONE |
NO |
mysql.sys@localhost |
INVOKER |
utf8mb4 |
utf8mb4_0900_ai_ci |