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 8.4 Reference Manual
前言和法律声明
一般信息
安装 MySQL
升级 MySQL
降级 MySQL
教程
MySQL 程序
MySQL 服务器管理
安全性
备份和恢复
优化
语言结构
字符集、排序规则、Unicode
数据类型
函数和运算符
SQL 语句
MySQL 数据字典
InnoDB 存储引擎
替代存储引擎
复制
组复制
MySQL Shell
将 MySQL 用作文档存储
InnoDB 集群
InnoDB 副本集
MySQL NDB Cluster 8.4
分区
存储对象
INFORMATION_SCHEMA 表
MySQL 性能模式
MySQL sys 模式
使用 sys Schema 的先决条件
使用 sys Schema
sys Schema 进度报告
sys Schema 对象参考
sys Schema 对象索引
sys Schema 表 and Triggers
sys_config 表
sys_config_insert_set_user 触发器
sys_config_update_set_user 触发器
sys Schema 视图
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
metrics 视图
The processlist and x$processlist Views
ps_check_lost_instrumentation 视图
schema_auto_increment_columns 视图
The schema_index_statistics and x$schema_index_statistics Views
schema_object_overview 视图
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
schema_unused_indexes 视图
The session and x$session Views
session_ssl_status 视图
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
version 视图
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 存储过程
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 存储函数
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
连接器和 API
MySQL 企业版
MySQL Workbench
OCI Marketplace 上的 MySQL
遥测
MySQL 8.4 常见问题解答
错误消息和常见问题
索引
MySQL 词汇表
Related Documentation
MySQL 8.4 Release Notes
Download this Manual
PDF (US Ltr)
- 39.8Mb
PDF (A4)
- 39.9Mb
Man Pages (TGZ)
- 257.9Kb
Man Pages (Zip)
- 364.9Kb
Info (Gzip)
- 4.0Mb
Info (Zip)
- 4.0Mb
version 8.4
8.0 current
5.7
8.0 Japanese
MySQL 8.4 Reference Manual
/
MySQL sys Schema
/ sys Schema Object Reference
30.4 sys Schema 对象参考
30.4.1 sys Schema 对象索引
30.4.2 sys Schema 表和触发器
30.4.3 sys Schema 视图
30.4.4 sys Schema 存储过程
30.4.5 sys Schema 存储函数
MySQL
sys
schema 包含表和触发器、视图和存储过程和函数。以下各节提供每个对象的详细信息。
PREV
HOME
UP
NEXT
Related Documentation
MySQL 8.4 Release Notes
Download this Manual
PDF (US Ltr)
- 39.8Mb
PDF (A4)
- 39.9Mb
Man Pages (TGZ)
- 257.9Kb
Man Pages (Zip)
- 364.9Kb
Info (Gzip)
- 4.0Mb
Info (Zip)
- 4.0Mb