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 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