| 1 |
USE sys; |
| 2 |
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'sys' ORDER BY TABLE_NAME; |
| 3 |
TABLE_NAME |
| 4 |
host_summary |
| 5 |
host_summary_by_file_io |
| 6 |
host_summary_by_file_io_type |
| 7 |
host_summary_by_stages |
| 8 |
host_summary_by_statement_latency |
| 9 |
host_summary_by_statement_type |
| 10 |
innodb_buffer_stats_by_schema |
| 11 |
innodb_buffer_stats_by_table |
| 12 |
innodb_lock_waits |
| 13 |
io_by_thread_by_latency |
| 14 |
io_global_by_file_by_bytes |
| 15 |
io_global_by_file_by_latency |
| 16 |
io_global_by_wait_by_bytes |
| 17 |
io_global_by_wait_by_latency |
| 18 |
latest_file_io |
| 19 |
memory_by_host_by_current_bytes |
| 20 |
memory_by_thread_by_current_bytes |
| 21 |
memory_by_user_by_current_bytes |
| 22 |
memory_global_by_current_bytes |
| 23 |
memory_global_total |
| 24 |
metrics |
| 25 |
processlist |
| 26 |
ps_check_lost_instrumentation |
| 27 |
schema_auto_increment_columns |
| 28 |
schema_index_statistics |
| 29 |
schema_object_overview |
| 30 |
schema_redundant_indexes |
| 31 |
schema_table_lock_waits |
| 32 |
schema_table_statistics |
| 33 |
schema_table_statistics_with_buffer |
| 34 |
schema_tables_with_full_table_scans |
| 35 |
schema_unused_indexes |
| 36 |
session |
| 37 |
session_ssl_status |
| 38 |
statement_analysis |
| 39 |
statements_with_errors_or_warnings |
| 40 |
statements_with_full_table_scans |
| 41 |
statements_with_runtimes_in_95th_percentile |
| 42 |
statements_with_sorting |
| 43 |
statements_with_temp_tables |
| 44 |
sys_config |
| 45 |
user_summary |
| 46 |
user_summary_by_file_io |
| 47 |
user_summary_by_file_io_type |
| 48 |
user_summary_by_stages |
| 49 |
user_summary_by_statement_latency |
| 50 |
user_summary_by_statement_type |
| 51 |
version |
| 52 |
wait_classes_global_by_avg_latency |
| 53 |
wait_classes_global_by_latency |
| 54 |
waits_by_host_by_latency |
| 55 |
waits_by_user_by_latency |
| 56 |
waits_global_by_latency |
| 57 |
x$host_summary |
| 58 |
x$host_summary_by_file_io |
| 59 |
x$host_summary_by_file_io_type |
| 60 |
x$host_summary_by_stages |
| 61 |
x$host_summary_by_statement_latency |
| 62 |
x$host_summary_by_statement_type |
| 63 |
x$innodb_buffer_stats_by_schema |
| 64 |
x$innodb_buffer_stats_by_table |
| 65 |
x$innodb_lock_waits |
| 66 |
x$io_by_thread_by_latency |
| 67 |
x$io_global_by_file_by_bytes |
| 68 |
x$io_global_by_file_by_latency |
| 69 |
x$io_global_by_wait_by_bytes |
| 70 |
x$io_global_by_wait_by_latency |
| 71 |
x$latest_file_io |
| 72 |
x$memory_by_host_by_current_bytes |
| 73 |
x$memory_by_thread_by_current_bytes |
| 74 |
x$memory_by_user_by_current_bytes |
| 75 |
x$memory_global_by_current_bytes |
| 76 |
x$memory_global_total |
| 77 |
x$processlist |
| 78 |
x$ps_digest_95th_percentile_by_avg_us |
| 79 |
x$ps_digest_avg_latency_distribution |
| 80 |
x$ps_schema_table_statistics_io |
| 81 |
x$schema_flattened_keys |
| 82 |
x$schema_index_statistics |
| 83 |
x$schema_table_lock_waits |
| 84 |
x$schema_table_statistics |
| 85 |
x$schema_table_statistics_with_buffer |
| 86 |
x$schema_tables_with_full_table_scans |
| 87 |
x$session |
| 88 |
x$statement_analysis |
| 89 |
x$statements_with_errors_or_warnings |
| 90 |
x$statements_with_full_table_scans |
| 91 |
x$statements_with_runtimes_in_95th_percentile |
| 92 |
x$statements_with_sorting |
| 93 |
x$statements_with_temp_tables |
| 94 |
x$user_summary |
| 95 |
x$user_summary_by_file_io |
| 96 |
x$user_summary_by_file_io_type |
| 97 |
x$user_summary_by_stages |
| 98 |
x$user_summary_by_statement_latency |
| 99 |
x$user_summary_by_statement_type |
| 100 |
x$wait_classes_global_by_avg_latency |
| 101 |
x$wait_classes_global_by_latency |
| 102 |
x$waits_by_host_by_latency |
| 103 |
x$waits_by_user_by_latency |
| 104 |
x$waits_global_by_latency |
| 105 |
SELECT ROUTINE_NAME, ROUTINE_TYPE FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA = 'sys' ORDER BY ROUTINE_TYPE, ROUTINE_NAME; |
| 106 |
ROUTINE_NAME ROUTINE_TYPE |
| 107 |
extract_schema_from_file_name FUNCTION |
| 108 |
extract_table_from_file_name FUNCTION |
| 109 |
format_bytes FUNCTION |
| 110 |
format_path FUNCTION |
| 111 |
format_statement FUNCTION |
| 112 |
format_time FUNCTION |
| 113 |
list_add FUNCTION |
| 114 |
list_drop FUNCTION |
| 115 |
ps_is_account_enabled FUNCTION |
| 116 |
ps_is_consumer_enabled FUNCTION |
| 117 |
ps_is_instrument_default_enabled FUNCTION |
| 118 |
ps_is_instrument_default_timed FUNCTION |
| 119 |
ps_is_thread_instrumented FUNCTION |
| 120 |
ps_thread_account FUNCTION |
| 121 |
ps_thread_id FUNCTION |
| 122 |
ps_thread_stack FUNCTION |
| 123 |
ps_thread_trx_info FUNCTION |
| 124 |
quote_identifier FUNCTION |
| 125 |
sys_get_config FUNCTION |
| 126 |
version_major FUNCTION |
| 127 |
version_minor FUNCTION |
| 128 |
version_patch FUNCTION |
| 129 |
create_synonym_db PROCEDURE |
| 130 |
diagnostics PROCEDURE |
| 131 |
execute_prepared_stmt PROCEDURE |
| 132 |
ps_setup_disable_background_threads PROCEDURE |
| 133 |
ps_setup_disable_consumer PROCEDURE |
| 134 |
ps_setup_disable_instrument PROCEDURE |
| 135 |
ps_setup_disable_thread PROCEDURE |
| 136 |
ps_setup_enable_background_threads PROCEDURE |
| 137 |
ps_setup_enable_consumer PROCEDURE |
| 138 |
ps_setup_enable_instrument PROCEDURE |
| 139 |
ps_setup_enable_thread PROCEDURE |
| 140 |
ps_setup_reload_saved PROCEDURE |
| 141 |
ps_setup_reset_to_default PROCEDURE |
| 142 |
ps_setup_save PROCEDURE |
| 143 |
ps_setup_show_disabled PROCEDURE |
| 144 |
ps_setup_show_disabled_consumers PROCEDURE |
| 145 |
ps_setup_show_disabled_instruments PROCEDURE |
| 146 |
ps_setup_show_enabled PROCEDURE |
| 147 |
ps_setup_show_enabled_consumers PROCEDURE |
| 148 |
ps_setup_show_enabled_instruments PROCEDURE |
| 149 |
ps_statement_avg_latency_histogram PROCEDURE |
| 150 |
ps_trace_statement_digest PROCEDURE |
| 151 |
ps_trace_thread PROCEDURE |
| 152 |
ps_truncate_all_tables PROCEDURE |
| 153 |
statement_performance_analyzer PROCEDURE |
| 154 |
table_exists PROCEDURE |
| 155 |
SELECT TRIGGER_NAME FROM INFORMATION_SCHEMA.TRIGGERS WHERE TRIGGER_SCHEMA = 'sys' ORDER BY TRIGGER_NAME; |
| 156 |
TRIGGER_NAME |
| 157 |
sys_config_insert_set_user |
| 158 |
sys_config_update_set_user |
| 159 |
SELECT sys_version FROM sys.version; |
| 160 |
sys_version |
| 161 |
2.1.3 |