summaryrefslogtreecommitdiffstats
path: root/scripts/sys_schema/sys_56.sql
diff options
context:
space:
mode:
authorDaniel Baumann <daniel.baumann@progress-linux.org>2024-05-04 18:00:34 +0000
committerDaniel Baumann <daniel.baumann@progress-linux.org>2024-05-04 18:00:34 +0000
commit3f619478f796eddbba6e39502fe941b285dd97b1 (patch)
treee2c7b5777f728320e5b5542b6213fd3591ba51e2 /scripts/sys_schema/sys_56.sql
parentInitial commit. (diff)
downloadmariadb-3f619478f796eddbba6e39502fe941b285dd97b1.tar.xz
mariadb-3f619478f796eddbba6e39502fe941b285dd97b1.zip
Adding upstream version 1:10.11.6.upstream/1%10.11.6upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'scripts/sys_schema/sys_56.sql')
-rw-r--r--scripts/sys_schema/sys_56.sql179
1 files changed, 179 insertions, 0 deletions
diff --git a/scripts/sys_schema/sys_56.sql b/scripts/sys_schema/sys_56.sql
new file mode 100644
index 00000000..1de01d25
--- /dev/null
+++ b/scripts/sys_schema/sys_56.sql
@@ -0,0 +1,179 @@
+-- Copyright (c) 2014, 2015, Oracle and/or its affiliates. All rights reserved.
+--
+-- This program is free software; you can redistribute it and/or modify
+-- it under the terms of the GNU General Public License as published by
+-- the Free Software Foundation; version 2 of the License.
+--
+-- This program is distributed in the hope that it will be useful,
+-- but WITHOUT ANY WARRANTY; without even the implied warranty of
+-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+-- GNU General Public License for more details.
+--
+-- You should have received a copy of the GNU General Public License
+-- along with this program; if not, write to the Free Software
+-- Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
+
+SOURCE ./before_setup.sql
+
+SOURCE ./views/version.sql
+
+SOURCE ./tables/sys_config.sql
+SOURCE ./tables/sys_config_data.sql
+
+SOURCE ./triggers/sys_config_insert_set_user.sql
+SOURCE ./triggers/sys_config_update_set_user.sql
+
+SOURCE ./functions/extract_schema_from_file_name.sql
+SOURCE ./functions/extract_table_from_file_name.sql
+SOURCE ./functions/format_bytes.sql
+SOURCE ./functions/format_path.sql
+SOURCE ./functions/format_statement.sql
+SOURCE ./functions/format_time.sql
+SOURCE ./functions/list_add.sql
+SOURCE ./functions/list_drop.sql
+SOURCE ./functions/ps_is_account_enabled.sql
+SOURCE ./functions/ps_is_consumer_enabled.sql
+SOURCE ./functions/ps_is_instrument_default_enabled.sql
+SOURCE ./functions/ps_is_instrument_default_timed.sql
+SOURCE ./functions/ps_is_thread_instrumented.sql
+SOURCE ./functions/ps_thread_id.sql
+SOURCE ./functions/ps_thread_account.sql
+SOURCE ./functions/ps_thread_stack.sql
+SOURCE ./functions/quote_identifier.sql
+SOURCE ./functions/sys_get_config.sql
+SOURCE ./functions/version_major.sql
+SOURCE ./functions/version_minor.sql
+SOURCE ./functions/version_patch.sql
+
+SOURCE ./views/i_s/innodb_buffer_stats_by_schema.sql
+SOURCE ./views/i_s/x_innodb_buffer_stats_by_schema.sql
+SOURCE ./views/i_s/innodb_buffer_stats_by_table.sql
+SOURCE ./views/i_s/x_innodb_buffer_stats_by_table.sql
+SOURCE ./views/i_s/innodb_lock_waits.sql
+SOURCE ./views/i_s/x_innodb_lock_waits.sql
+SOURCE ./views/i_s/schema_object_overview.sql
+SOURCE ./views/i_s/schema_auto_increment_columns.sql
+SOURCE ./views/i_s/x_schema_flattened_keys.sql
+SOURCE ./views/i_s/schema_redundant_indexes.sql
+
+SOURCE ./views/p_s/ps_check_lost_instrumentation.sql
+SOURCE ./views/p_s/processlist.sql
+SOURCE ./views/p_s/x_processlist.sql
+
+SOURCE ./views/p_s/sessions.sql
+SOURCE ./views/p_s/x_sessions.sql
+
+SOURCE ./views/p_s/latest_file_io.sql
+SOURCE ./views/p_s/x_latest_file_io.sql
+SOURCE ./views/p_s/io_by_thread_by_latency.sql
+SOURCE ./views/p_s/x_io_by_thread_by_latency.sql
+SOURCE ./views/p_s/io_global_by_file_by_bytes.sql
+SOURCE ./views/p_s/x_io_global_by_file_by_bytes.sql
+SOURCE ./views/p_s/io_global_by_file_by_latency.sql
+SOURCE ./views/p_s/x_io_global_by_file_by_latency.sql
+SOURCE ./views/p_s/io_global_by_wait_by_bytes.sql
+SOURCE ./views/p_s/x_io_global_by_wait_by_bytes.sql
+SOURCE ./views/p_s/io_global_by_wait_by_latency.sql
+SOURCE ./views/p_s/x_io_global_by_wait_by_latency.sql
+
+SOURCE ./views/p_s/schema_index_statistics.sql
+SOURCE ./views/p_s/x_schema_index_statistics.sql
+SOURCE ./views/p_s/x_ps_schema_table_statistics_io.sql
+SOURCE ./views/p_s/schema_table_statistics.sql
+SOURCE ./views/p_s/x_schema_table_statistics.sql
+SOURCE ./views/p_s/schema_table_statistics_with_buffer.sql
+SOURCE ./views/p_s/x_schema_table_statistics_with_buffer.sql
+SOURCE ./views/p_s/schema_tables_with_full_table_scans.sql
+SOURCE ./views/p_s/x_schema_tables_with_full_table_scans.sql
+SOURCE ./views/p_s/schema_unused_indexes.sql
+
+SOURCE ./views/p_s/statement_analysis.sql
+SOURCE ./views/p_s/x_statement_analysis.sql
+SOURCE ./views/p_s/statements_with_errors_or_warnings.sql
+SOURCE ./views/p_s/x_statements_with_errors_or_warnings.sql
+SOURCE ./views/p_s/statements_with_full_table_scans.sql
+SOURCE ./views/p_s/x_statements_with_full_table_scans.sql
+SOURCE ./views/p_s/x_ps_digest_avg_latency_distribution.sql
+SOURCE ./views/p_s/x_ps_digest_95th_percentile_by_avg_us.sql
+SOURCE ./views/p_s/statements_with_runtimes_in_95th_percentile.sql
+SOURCE ./views/p_s/x_statements_with_runtimes_in_95th_percentile.sql
+SOURCE ./views/p_s/statements_with_sorting.sql
+SOURCE ./views/p_s/x_statements_with_sorting.sql
+SOURCE ./views/p_s/statements_with_temp_tables.sql
+SOURCE ./views/p_s/x_statements_with_temp_tables.sql
+
+SOURCE ./views/p_s/user_summary_by_file_io_type.sql
+SOURCE ./views/p_s/x_user_summary_by_file_io_type.sql
+SOURCE ./views/p_s/user_summary_by_file_io.sql
+SOURCE ./views/p_s/x_user_summary_by_file_io.sql
+SOURCE ./views/p_s/user_summary_by_statement_type.sql
+SOURCE ./views/p_s/x_user_summary_by_statement_type.sql
+SOURCE ./views/p_s/user_summary_by_statement_latency.sql
+SOURCE ./views/p_s/x_user_summary_by_statement_latency.sql
+SOURCE ./views/p_s/user_summary_by_stages.sql
+SOURCE ./views/p_s/x_user_summary_by_stages.sql
+SOURCE ./views/p_s/user_summary.sql
+SOURCE ./views/p_s/x_user_summary.sql
+
+SOURCE ./views/p_s/host_summary_by_file_io_type.sql
+SOURCE ./views/p_s/x_host_summary_by_file_io_type.sql
+SOURCE ./views/p_s/host_summary_by_file_io.sql
+SOURCE ./views/p_s/x_host_summary_by_file_io.sql
+SOURCE ./views/p_s/host_summary_by_statement_type.sql
+SOURCE ./views/p_s/x_host_summary_by_statement_type.sql
+SOURCE ./views/p_s/host_summary_by_statement_latency.sql
+SOURCE ./views/p_s/x_host_summary_by_statement_latency.sql
+SOURCE ./views/p_s/host_summary_by_stages.sql
+SOURCE ./views/p_s/x_host_summary_by_stages.sql
+SOURCE ./views/p_s/host_summary.sql
+SOURCE ./views/p_s/x_host_summary.sql
+
+SOURCE ./views/p_s/wait_classes_global_by_avg_latency.sql
+SOURCE ./views/p_s/x_wait_classes_global_by_avg_latency.sql
+SOURCE ./views/p_s/wait_classes_global_by_latency.sql
+SOURCE ./views/p_s/x_wait_classes_global_by_latency.sql
+SOURCE ./views/p_s/waits_by_user_by_latency.sql
+SOURCE ./views/p_s/x_waits_by_user_by_latency.sql
+SOURCE ./views/p_s/waits_by_host_by_latency.sql
+SOURCE ./views/p_s/x_waits_by_host_by_latency.sql
+SOURCE ./views/p_s/waits_global_by_latency.sql
+SOURCE ./views/p_s/x_waits_global_by_latency.sql
+
+SOURCE ./views/p_s/metrics_56.sql
+
+SOURCE ./procedures/create_synonym_db.sql
+SOURCE ./procedures/execute_prepared_stmt.sql
+
+SOURCE ./procedures/diagnostics.sql
+
+SOURCE ./procedures/ps_statement_avg_latency_histogram.sql
+SOURCE ./procedures/ps_trace_statement_digest.sql
+SOURCE ./procedures/ps_trace_thread.sql
+
+SOURCE ./procedures/ps_setup_disable_background_threads.sql
+SOURCE ./procedures/ps_setup_disable_consumer.sql
+SOURCE ./procedures/ps_setup_disable_instrument.sql
+SOURCE ./procedures/ps_setup_disable_thread.sql
+
+SOURCE ./procedures/ps_setup_enable_background_threads.sql
+SOURCE ./procedures/ps_setup_enable_consumer.sql
+SOURCE ./procedures/ps_setup_enable_instrument.sql
+SOURCE ./procedures/ps_setup_enable_thread.sql
+
+SOURCE ./procedures/ps_setup_reload_saved.sql
+SOURCE ./procedures/ps_setup_reset_to_default_57_before.sql
+SOURCE ./procedures/ps_setup_reset_to_default.sql
+SOURCE ./procedures/ps_setup_reset_to_default_57_after.sql
+SOURCE ./procedures/ps_setup_save.sql
+SOURCE ./procedures/ps_setup_show_disabled.sql
+SOURCE ./procedures/ps_setup_show_disabled_consumers.sql
+SOURCE ./procedures/ps_setup_show_disabled_instruments.sql
+SOURCE ./procedures/ps_setup_show_enabled.sql
+SOURCE ./procedures/ps_setup_show_enabled_consumers.sql
+SOURCE ./procedures/ps_setup_show_enabled_instruments.sql
+SOURCE ./procedures/ps_truncate_all_tables.sql
+
+SOURCE ./procedures/statement_performance_analyzer.sql
+SOURCE ./procedures/table_exists.sql
+
+SOURCE ./after_setup.sql