MySQL 8.4 Release Notes
30.4.1 sys Schema 对象索引
The following tables list sys
schema objects and provide a short description of each one.
Table 30.1 sys Schema Tables and Triggers
Table or Trigger Name | Description |
---|---|
sys_config |
sys schema configuration options table |
sys_config_insert_set_user |
sys_config insert trigger |
sys_config_update_set_user |
sys_config update trigger |
Table 30.2 sys Schema Views
Table 30.3 sys Schema Stored Procedures
Procedure Name | Description |
---|---|
create_synonym_db() |
Create synonym for schema |
diagnostics() |
Collect system diagnostic information |
execute_prepared_stmt() |
Execute prepared statement |
ps_setup_disable_background_threads() |
Disable background thread instrumentation |
ps_setup_disable_consumer() |
Disable consumers |
ps_setup_disable_instrument() |
Disable instruments |
ps_setup_disable_thread() |
Disable instrumentation for thread |
ps_setup_enable_background_threads() |
Enable background thread instrumentation |
ps_setup_enable_consumer() |
Enable consumers |
ps_setup_enable_instrument() |
Enable instruments |
ps_setup_enable_thread() |
Enable instrumentation for thread |
ps_setup_reload_saved() |
Reload saved Performance Schema configuration |
ps_setup_reset_to_default() |
Reset saved Performance Schema configuration |
ps_setup_save() |
Save Performance Schema configuration |
ps_setup_show_disabled() |
Display disabled Performance Schema configuration |
ps_setup_show_disabled_consumers() |
Display disabled Performance Schema consumers |
ps_setup_show_disabled_instruments() |
Display disabled Performance Schema instruments |
ps_setup_show_enabled() |
Display enabled Performance Schema configuration |
ps_setup_show_enabled_consumers() |
Display enabled Performance Schema consumers |
ps_setup_show_enabled_instruments() |
Display enabled Performance Schema instruments |
ps_statement_avg_latency_histogram() |
Display statement latency histogram |
ps_trace_statement_digest() |
Trace Performance Schema instrumentation for digest |
ps_trace_thread() |
Dump Performance Schema data for thread |
ps_truncate_all_tables() |
Truncate Performance Schema summary tables |
statement_performance_analyzer() |
Report of statements running on server |
table_exists() |
Whether a table exists |
Table 30.4 sys Schema Stored Functions
Function Name | Description | Deprecated |
---|---|---|
extract_schema_from_file_name() |
Extract schema name part of file name | |
extract_table_from_file_name() |
Extract table name part of file name | |
format_bytes() |
Convert byte count to value with units | Yes |
format_path() |
Replace directories in path name with symbolic system variable names | |
format_statement() |
Truncate long statement to fixed length | |
format_time() |
Convert picoseconds time to value with units | Yes |
list_add() |
Add item to list | |
list_drop() |
Remove item from list | |
ps_is_account_enabled() |
Whether Performance Schema instrumentation for account is enabled | |
ps_is_consumer_enabled() |
Whether Performance Schema consumer is enabled | |
ps_is_instrument_default_enabled() |
Whether Performance Schema instrument is enabled by default | |
ps_is_instrument_default_timed() |
Whether Performance Schema instrument is timed by default | |
ps_is_thread_instrumented() |
Whether Performance Schema instrumentation for connection ID is enabled | |
ps_thread_account() |
Account associated with Performance Schema thread ID | |
ps_thread_id() |
Performance Schema thread ID associated with connection ID | Yes |
ps_thread_stack() |
Event information for connection ID | |
ps_thread_trx_info() |
Transaction information for thread ID | |
quote_identifier() |
Quote string as identifier | |
sys_get_config() |
sys schema configuration option value | |
version_major() |
MySQL server major version number | |
version_minor() |
MySQL server minor version number | |
version_patch() |
MySQL server patch release version number |