1-- Copyright (c) 2014, 2015, Oracle and/or its affiliates. All rights reserved.
2--
3-- This program is free software; you can redistribute it and/or modify
4-- it under the terms of the GNU General Public License as published by
5-- the Free Software Foundation; version 2 of the License.
6--
7-- This program is distributed in the hope that it will be useful,
8-- but WITHOUT ANY WARRANTY; without even the implied warranty of
9-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
10-- GNU General Public License for more details.
11--
12-- You should have received a copy of the GNU General Public License
13-- along with this program; if not, write to the Free Software
14-- Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
15
16SOURCE ./before_setup.sql
17
18SOURCE ./views/version.sql
19
20SOURCE ./tables/sys_config.sql
21SOURCE ./tables/sys_config_data_57.sql
22
23SOURCE ./triggers/sys_config_insert_set_user.sql
24SOURCE ./triggers/sys_config_update_set_user.sql
25
26SOURCE ./functions/extract_schema_from_file_name.sql
27SOURCE ./functions/extract_table_from_file_name.sql
28SOURCE ./functions/format_bytes.sql
29SOURCE ./functions/format_path_57.sql
30SOURCE ./functions/format_statement.sql
31SOURCE ./functions/format_time.sql
32SOURCE ./functions/list_add.sql
33SOURCE ./functions/list_drop.sql
34SOURCE ./functions/ps_is_account_enabled_57.sql
35SOURCE ./functions/ps_is_consumer_enabled.sql
36SOURCE ./functions/ps_is_instrument_default_enabled.sql
37SOURCE ./functions/ps_is_instrument_default_timed.sql
38SOURCE ./functions/ps_is_thread_instrumented.sql
39SOURCE ./functions/ps_thread_id.sql
40SOURCE ./functions/ps_thread_account.sql
41SOURCE ./functions/ps_thread_stack.sql
42SOURCE ./functions/ps_thread_trx_info.sql
43SOURCE ./functions/sys_get_config.sql
44SOURCE ./functions/version_major.sql
45SOURCE ./functions/version_minor.sql
46SOURCE ./functions/version_patch.sql
47
48SOURCE ./views/i_s/innodb_buffer_stats_by_schema.sql
49SOURCE ./views/i_s/x_innodb_buffer_stats_by_schema.sql
50SOURCE ./views/i_s/innodb_buffer_stats_by_table.sql
51SOURCE ./views/i_s/x_innodb_buffer_stats_by_table.sql
52SOURCE ./views/i_s/innodb_lock_waits.sql
53SOURCE ./views/i_s/x_innodb_lock_waits.sql
54SOURCE ./views/i_s/schema_object_overview.sql
55SOURCE ./views/i_s/schema_auto_increment_columns.sql
56SOURCE ./views/i_s/x_schema_flattened_keys.sql
57SOURCE ./views/i_s/schema_redundant_indexes.sql
58
59SOURCE ./views/p_s/ps_check_lost_instrumentation_57.sql
60
61SOURCE ./views/p_s/latest_file_io.sql
62SOURCE ./views/p_s/x_latest_file_io.sql
63SOURCE ./views/p_s/io_by_thread_by_latency.sql
64SOURCE ./views/p_s/x_io_by_thread_by_latency.sql
65SOURCE ./views/p_s/io_global_by_file_by_bytes.sql
66SOURCE ./views/p_s/x_io_global_by_file_by_bytes.sql
67SOURCE ./views/p_s/io_global_by_file_by_latency.sql
68SOURCE ./views/p_s/x_io_global_by_file_by_latency.sql
69SOURCE ./views/p_s/io_global_by_wait_by_bytes.sql
70SOURCE ./views/p_s/x_io_global_by_wait_by_bytes.sql
71SOURCE ./views/p_s/io_global_by_wait_by_latency.sql
72SOURCE ./views/p_s/x_io_global_by_wait_by_latency.sql
73
74SOURCE ./views/p_s/memory_by_user_by_current_bytes.sql
75SOURCE ./views/p_s/x_memory_by_user_by_current_bytes.sql
76SOURCE ./views/p_s/memory_by_host_by_current_bytes.sql
77SOURCE ./views/p_s/x_memory_by_host_by_current_bytes.sql
78SOURCE ./views/p_s/memory_by_thread_by_current_bytes.sql
79SOURCE ./views/p_s/x_memory_by_thread_by_current_bytes.sql
80SOURCE ./views/p_s/memory_global_by_current_bytes.sql
81SOURCE ./views/p_s/x_memory_global_by_current_bytes.sql
82SOURCE ./views/p_s/memory_global_total.sql
83SOURCE ./views/p_s/x_memory_global_total.sql
84
85SOURCE ./views/p_s/schema_index_statistics.sql
86SOURCE ./views/p_s/x_schema_index_statistics.sql
87SOURCE ./views/p_s/x_ps_schema_table_statistics_io.sql
88SOURCE ./views/p_s/schema_table_statistics.sql
89SOURCE ./views/p_s/x_schema_table_statistics.sql
90SOURCE ./views/p_s/schema_table_statistics_with_buffer.sql
91SOURCE ./views/p_s/x_schema_table_statistics_with_buffer.sql
92SOURCE ./views/p_s/schema_tables_with_full_table_scans.sql
93SOURCE ./views/p_s/x_schema_tables_with_full_table_scans.sql
94SOURCE ./views/p_s/schema_unused_indexes.sql
95SOURCE ./views/p_s/schema_table_lock_waits.sql
96SOURCE ./views/p_s/x_schema_table_lock_waits.sql
97
98SOURCE ./views/p_s/statement_analysis.sql
99SOURCE ./views/p_s/x_statement_analysis.sql
100SOURCE ./views/p_s/statements_with_errors_or_warnings.sql
101SOURCE ./views/p_s/x_statements_with_errors_or_warnings.sql
102SOURCE ./views/p_s/statements_with_full_table_scans.sql
103SOURCE ./views/p_s/x_statements_with_full_table_scans.sql
104SOURCE ./views/p_s/x_ps_digest_avg_latency_distribution.sql
105SOURCE ./views/p_s/x_ps_digest_95th_percentile_by_avg_us.sql
106SOURCE ./views/p_s/statements_with_runtimes_in_95th_percentile.sql
107SOURCE ./views/p_s/x_statements_with_runtimes_in_95th_percentile.sql
108SOURCE ./views/p_s/statements_with_sorting.sql
109SOURCE ./views/p_s/x_statements_with_sorting.sql
110SOURCE ./views/p_s/statements_with_temp_tables.sql
111SOURCE ./views/p_s/x_statements_with_temp_tables.sql
112
113SOURCE ./views/p_s/user_summary_by_file_io_type.sql
114SOURCE ./views/p_s/x_user_summary_by_file_io_type.sql
115SOURCE ./views/p_s/user_summary_by_file_io.sql
116SOURCE ./views/p_s/x_user_summary_by_file_io.sql
117SOURCE ./views/p_s/user_summary_by_statement_type.sql
118SOURCE ./views/p_s/x_user_summary_by_statement_type.sql
119SOURCE ./views/p_s/user_summary_by_statement_latency.sql
120SOURCE ./views/p_s/x_user_summary_by_statement_latency.sql
121SOURCE ./views/p_s/user_summary_by_stages.sql
122SOURCE ./views/p_s/x_user_summary_by_stages.sql
123SOURCE ./views/p_s/user_summary_57.sql
124SOURCE ./views/p_s/x_user_summary_57.sql
125
126SOURCE ./views/p_s/host_summary_by_file_io_type.sql
127SOURCE ./views/p_s/x_host_summary_by_file_io_type.sql
128SOURCE ./views/p_s/host_summary_by_file_io.sql
129SOURCE ./views/p_s/x_host_summary_by_file_io.sql
130SOURCE ./views/p_s/host_summary_by_statement_type.sql
131SOURCE ./views/p_s/x_host_summary_by_statement_type.sql
132SOURCE ./views/p_s/host_summary_by_statement_latency.sql
133SOURCE ./views/p_s/x_host_summary_by_statement_latency.sql
134SOURCE ./views/p_s/host_summary_by_stages.sql
135SOURCE ./views/p_s/x_host_summary_by_stages.sql
136SOURCE ./views/p_s/host_summary_57.sql
137SOURCE ./views/p_s/x_host_summary_57.sql
138
139SOURCE ./views/p_s/wait_classes_global_by_avg_latency.sql
140SOURCE ./views/p_s/x_wait_classes_global_by_avg_latency.sql
141SOURCE ./views/p_s/wait_classes_global_by_latency.sql
142SOURCE ./views/p_s/x_wait_classes_global_by_latency.sql
143SOURCE ./views/p_s/waits_by_user_by_latency.sql
144SOURCE ./views/p_s/x_waits_by_user_by_latency.sql
145SOURCE ./views/p_s/waits_by_host_by_latency.sql
146SOURCE ./views/p_s/x_waits_by_host_by_latency.sql
147SOURCE ./views/p_s/waits_global_by_latency.sql
148SOURCE ./views/p_s/x_waits_global_by_latency.sql
149
150SOURCE ./views/p_s/metrics.sql
151
152SOURCE ./views/p_s/processlist_57.sql
153SOURCE ./views/p_s/x_processlist_57.sql
154
155SOURCE ./views/p_s/sessions.sql
156SOURCE ./views/p_s/x_sessions.sql
157SOURCE ./views/p_s/session_ssl_status.sql
158
159SOURCE ./procedures/create_synonym_db.sql
160SOURCE ./procedures/execute_prepared_stmt.sql
161
162SOURCE ./procedures/diagnostics.sql
163
164SOURCE ./procedures/ps_statement_avg_latency_histogram.sql
165SOURCE ./procedures/ps_trace_statement_digest.sql
166SOURCE ./procedures/ps_trace_thread_57.sql
167
168SOURCE ./procedures/ps_setup_disable_background_threads.sql
169SOURCE ./procedures/ps_setup_disable_consumer.sql
170SOURCE ./procedures/ps_setup_disable_instrument.sql
171SOURCE ./procedures/ps_setup_disable_thread.sql
172
173SOURCE ./procedures/ps_setup_enable_background_threads.sql
174SOURCE ./procedures/ps_setup_enable_consumer.sql
175SOURCE ./procedures/ps_setup_enable_instrument.sql
176SOURCE ./procedures/ps_setup_enable_thread.sql
177
178SOURCE ./procedures/ps_setup_reload_saved.sql
179SOURCE ./procedures/ps_setup_reset_to_default_57_before.sql
180SOURCE ./procedures/ps_setup_reset_to_default_57.sql
181SOURCE ./procedures/ps_setup_reset_to_default_57_after.sql
182SOURCE ./procedures/ps_setup_save.sql
183SOURCE ./procedures/ps_setup_show_disabled.sql
184SOURCE ./procedures/ps_setup_show_disabled_consumers.sql
185SOURCE ./procedures/ps_setup_show_disabled_instruments.sql
186SOURCE ./procedures/ps_setup_show_enabled.sql
187SOURCE ./procedures/ps_setup_show_enabled_consumers.sql
188SOURCE ./procedures/ps_setup_show_enabled_instruments.sql
189SOURCE ./procedures/ps_truncate_all_tables.sql
190
191SOURCE ./procedures/statement_performance_analyzer.sql
192SOURCE ./procedures/table_exists.sql
193
194SOURCE ./after_setup.sql
195