Debian Codegraph @

mysql-test/suite/sysschema/r/all_sys_objects_exist.result

raw
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 privileges_by_table_by_level
26 processlist
27 ps_check_lost_instrumentation
28 schema_auto_increment_columns
29 schema_index_statistics
30 schema_object_overview
31 schema_redundant_indexes
32 schema_tables_with_full_table_scans
33 schema_table_lock_waits
34 schema_table_statistics
35 schema_table_statistics_with_buffer
36 schema_unused_indexes
37 session
38 session_ssl_status
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 statement_analysis
45 sys_config
46 user_summary
47 user_summary_by_file_io
48 user_summary_by_file_io_type
49 user_summary_by_stages
50 user_summary_by_statement_latency
51 user_summary_by_statement_type
52 version
53 waits_by_host_by_latency
54 waits_by_user_by_latency
55 waits_global_by_latency
56 wait_classes_global_by_avg_latency
57 wait_classes_global_by_latency
58 x$host_summary
59 x$host_summary_by_file_io
60 x$host_summary_by_file_io_type
61 x$host_summary_by_stages
62 x$host_summary_by_statement_latency
63 x$host_summary_by_statement_type
64 x$innodb_buffer_stats_by_schema
65 x$innodb_buffer_stats_by_table
66 x$innodb_lock_waits
67 x$io_by_thread_by_latency
68 x$io_global_by_file_by_bytes
69 x$io_global_by_file_by_latency
70 x$io_global_by_wait_by_bytes
71 x$io_global_by_wait_by_latency
72 x$latest_file_io
73 x$memory_by_host_by_current_bytes
74 x$memory_by_thread_by_current_bytes
75 x$memory_by_user_by_current_bytes
76 x$memory_global_by_current_bytes
77 x$memory_global_total
78 x$processlist
79 x$ps_digest_95th_percentile_by_avg_us
80 x$ps_digest_avg_latency_distribution
81 x$ps_schema_table_statistics_io
82 x$schema_flattened_keys
83 x$schema_index_statistics
84 x$schema_tables_with_full_table_scans
85 x$schema_table_lock_waits
86 x$schema_table_statistics
87 x$schema_table_statistics_with_buffer
88 x$session
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$statement_analysis
95 x$user_summary
96 x$user_summary_by_file_io
97 x$user_summary_by_file_io_type
98 x$user_summary_by_stages
99 x$user_summary_by_statement_latency
100 x$user_summary_by_statement_type
101 x$waits_by_host_by_latency
102 x$waits_by_user_by_latency
103 x$waits_global_by_latency
104 x$wait_classes_global_by_avg_latency
105 x$wait_classes_global_by_latency
106 SELECT ROUTINE_NAME, ROUTINE_TYPE FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA = 'sys' ORDER BY ROUTINE_TYPE, ROUTINE_NAME;
107 ROUTINE_NAME ROUTINE_TYPE
108 extract_schema_from_file_name FUNCTION
109 extract_table_from_file_name FUNCTION
110 format_bytes FUNCTION
111 format_path FUNCTION
112 format_statement FUNCTION
113 format_time FUNCTION
114 list_add FUNCTION
115 list_drop FUNCTION
116 ps_is_account_enabled FUNCTION
117 ps_is_consumer_enabled FUNCTION
118 ps_is_instrument_default_enabled FUNCTION
119 ps_is_instrument_default_timed FUNCTION
120 ps_is_thread_instrumented FUNCTION
121 ps_thread_account FUNCTION
122 ps_thread_id FUNCTION
123 ps_thread_stack FUNCTION
124 ps_thread_trx_info FUNCTION
125 quote_identifier FUNCTION
126 sys_get_config FUNCTION
127 version_major FUNCTION
128 version_minor FUNCTION
129 version_patch FUNCTION
130 create_synonym_db PROCEDURE
131 diagnostics PROCEDURE
132 execute_prepared_stmt PROCEDURE
133 optimizer_switch_choice PROCEDURE
134 optimizer_switch_off PROCEDURE
135 optimizer_switch_on PROCEDURE
136 ps_setup_disable_background_threads PROCEDURE
137 ps_setup_disable_consumer PROCEDURE
138 ps_setup_disable_instrument PROCEDURE
139 ps_setup_disable_thread PROCEDURE
140 ps_setup_enable_background_threads PROCEDURE
141 ps_setup_enable_consumer PROCEDURE
142 ps_setup_enable_instrument PROCEDURE
143 ps_setup_enable_thread PROCEDURE
144 ps_setup_reload_saved PROCEDURE
145 ps_setup_reset_to_default PROCEDURE
146 ps_setup_save PROCEDURE
147 ps_setup_show_disabled PROCEDURE
148 ps_setup_show_disabled_consumers PROCEDURE
149 ps_setup_show_disabled_instruments PROCEDURE
150 ps_setup_show_enabled PROCEDURE
151 ps_setup_show_enabled_consumers PROCEDURE
152 ps_setup_show_enabled_instruments PROCEDURE
153 ps_statement_avg_latency_histogram PROCEDURE
154 ps_trace_statement_digest PROCEDURE
155 ps_trace_thread PROCEDURE
156 ps_truncate_all_tables PROCEDURE
157 statement_performance_analyzer PROCEDURE
158 table_exists PROCEDURE
159 SELECT TRIGGER_NAME FROM INFORMATION_SCHEMA.TRIGGERS WHERE TRIGGER_SCHEMA = 'sys' ORDER BY TRIGGER_NAME;
160 TRIGGER_NAME
161 SELECT sys_version FROM sys.version;
162 sys_version
163 1.5.2