Skip to Main Content
The world's most popular open source database
Contact MySQL
|
Login
|
Register
MySQL.com
Downloads
Documentation
Developer Zone
Developer Zone
Downloads
MySQL.com
Documentation
MySQL Server
MySQL Enterprise
Workbench
InnoDB Cluster
MySQL NDB Cluster
Connectors
More
MySQL.com
Downloads
Developer Zone
Section Menu:
Documentation Home
MySQL 9.1 Reference Manual
Preface and Legal Notices
General Information
Installing MySQL
Upgrading MySQL
Downgrading MySQL
Tutorial
MySQL Programs
MySQL Server Administration
Security
Backup and Recovery
Optimization
Language Structure
Character Sets, Collations, Unicode
Data Types
Functions and Operators
SQL Statements
MySQL Data Dictionary
The InnoDB Storage Engine
Alternative Storage Engines
Replication
Group Replication
MySQL Shell
Using MySQL as a Document Store
InnoDB Cluster
InnoDB ReplicaSet
MySQL NDB Cluster 9.1
Partitioning
Stored Objects
INFORMATION_SCHEMA Tables
MySQL Performance Schema
MySQL sys Schema
Prerequisites for Using the sys Schema
Using the sys Schema
sys Schema Progress Reporting
sys Schema Object Reference
sys Schema Object Index
sys Schema Tables and Triggers
The sys_config Table
The sys_config_insert_set_user Trigger
The sys_config_update_set_user Trigger
sys Schema Views
The host_summary and x$host_summary Views
The host_summary_by_file_io and x$host_summary_by_file_io Views
The host_summary_by_file_io_type and x$host_summary_by_file_io_type Views
The host_summary_by_stages and x$host_summary_by_stages Views
The host_summary_by_statement_latency and x$host_summary_by_statement_latency Views
The host_summary_by_statement_type and x$host_summary_by_statement_type Views
The innodb_buffer_stats_by_schema and x$innodb_buffer_stats_by_schema Views
The innodb_buffer_stats_by_table and x$innodb_buffer_stats_by_table Views
The innodb_lock_waits and x$innodb_lock_waits Views
The io_by_thread_by_latency and x$io_by_thread_by_latency Views
The io_global_by_file_by_bytes and x$io_global_by_file_by_bytes Views
The io_global_by_file_by_latency and x$io_global_by_file_by_latency Views
The io_global_by_wait_by_bytes and x$io_global_by_wait_by_bytes Views
The io_global_by_wait_by_latency and x$io_global_by_wait_by_latency Views
The latest_file_io and x$latest_file_io Views
The memory_by_host_by_current_bytes and x$memory_by_host_by_current_bytes Views
The memory_by_thread_by_current_bytes and x$memory_by_thread_by_current_bytes Views
The memory_by_user_by_current_bytes and x$memory_by_user_by_current_bytes Views
The memory_global_by_current_bytes and x$memory_global_by_current_bytes Views
The memory_global_total and x$memory_global_total Views
The metrics View
The processlist and x$processlist Views
The ps_check_lost_instrumentation View
The schema_auto_increment_columns View
The schema_index_statistics and x$schema_index_statistics Views
The schema_object_overview View
The schema_redundant_indexes and x$schema_flattened_keys Views
The schema_table_lock_waits and x$schema_table_lock_waits Views
The schema_table_statistics and x$schema_table_statistics Views
The schema_table_statistics_with_buffer and x$schema_table_statistics_with_buffer Views
The schema_tables_with_full_table_scans and x$schema_tables_with_full_table_scans Views
The schema_unused_indexes View
The session and x$session Views
The session_ssl_status View
The statement_analysis and x$statement_analysis Views
The statements_with_errors_or_warnings and x$statements_with_errors_or_warnings Views
The statements_with_full_table_scans and x$statements_with_full_table_scans Views
The statements_with_runtimes_in_95th_percentile and x$statements_with_runtimes_in_95th_percentile Views
The statements_with_sorting and x$statements_with_sorting Views
The statements_with_temp_tables and x$statements_with_temp_tables Views
The user_summary and x$user_summary Views
The user_summary_by_file_io and x$user_summary_by_file_io Views
The user_summary_by_file_io_type and x$user_summary_by_file_io_type Views
The user_summary_by_stages and x$user_summary_by_stages Views
The user_summary_by_statement_latency and x$user_summary_by_statement_latency Views
The user_summary_by_statement_type and x$user_summary_by_statement_type Views
The version View
The wait_classes_global_by_avg_latency and x$wait_classes_global_by_avg_latency Views
The wait_classes_global_by_latency and x$wait_classes_global_by_latency Views
The waits_by_host_by_latency and x$waits_by_host_by_latency Views
The waits_by_user_by_latency and x$waits_by_user_by_latency Views
The waits_global_by_latency and x$waits_global_by_latency Views
sys Schema Stored Procedures
The create_synonym_db() Procedure
The diagnostics() Procedure
The execute_prepared_stmt() Procedure
The ps_setup_disable_background_threads() Procedure
The ps_setup_disable_consumer() Procedure
The ps_setup_disable_instrument() Procedure
The ps_setup_disable_thread() Procedure
The ps_setup_enable_background_threads() Procedure
The ps_setup_enable_consumer() Procedure
The ps_setup_enable_instrument() Procedure
The ps_setup_enable_thread() Procedure
The ps_setup_reload_saved() Procedure
The ps_setup_reset_to_default() Procedure
The ps_setup_save() Procedure
The ps_setup_show_disabled() Procedure
The ps_setup_show_disabled_consumers() Procedure
The ps_setup_show_disabled_instruments() Procedure
The ps_setup_show_enabled() Procedure
The ps_setup_show_enabled_consumers() Procedure
The ps_setup_show_enabled_instruments() Procedure
The ps_statement_avg_latency_histogram() Procedure
The ps_trace_statement_digest() Procedure
The ps_trace_thread() Procedure
The ps_truncate_all_tables() Procedure
The statement_performance_analyzer() Procedure
The table_exists() Procedure
sys Schema Stored Functions
The extract_schema_from_file_name() Function
The extract_table_from_file_name() Function
The format_bytes() Function
The format_path() Function
The format_statement() Function
The format_time() Function
The list_add() Function
The list_drop() Function
The ps_is_account_enabled() Function
The ps_is_consumer_enabled() Function
The ps_is_instrument_default_enabled() Function
The ps_is_instrument_default_timed() Function
The ps_is_thread_instrumented() Function
The ps_thread_account() Function
The ps_thread_id() Function
The ps_thread_stack() Function
The ps_thread_trx_info() Function
The quote_identifier() Function
The sys_get_config() Function
The version_major() Function
The version_minor() Function
The version_patch() Function
Connectors and APIs
MySQL Enterprise Edition
MySQL Workbench
MySQL on OCI Marketplace
Telemetry
MySQL 9.1 Frequently Asked Questions
Error Messages and Common Problems
Indexes
MySQL Glossary
Related Documentation
MySQL 9.1 Release Notes
Download this Manual
PDF (US Ltr)
- 40.3Mb
PDF (A4)
- 40.4Mb
Man Pages (TGZ)
- 259.3Kb
Man Pages (Zip)
- 366.4Kb
Info (Gzip)
- 4.0Mb
Info (Zip)
- 4.0Mb
version 9.1
9.0
8.4 current
8.0
5.7
8.0 Japanese
MySQL 9.1 Reference Manual
/
...
/
MySQL sys Schema
/
sys Schema Object Reference
/
sys Schema Tables and Triggers
30.4.2 sys Schema Tables and Triggers
30.4.2.1 The sys_config Table
30.4.2.2 The sys_config_insert_set_user Trigger
30.4.2.3 The sys_config_update_set_user Trigger
The following sections describe
sys
schema tables and triggers.
PREV
HOME
UP
NEXT
Related Documentation
MySQL 9.1 Release Notes
Download this Manual
PDF (US Ltr)
- 40.3Mb
PDF (A4)
- 40.4Mb
Man Pages (TGZ)
- 259.3Kb
Man Pages (Zip)
- 366.4Kb
Info (Gzip)
- 4.0Mb
Info (Zip)
- 4.0Mb