The following tables list sys schema objects and provide a short description of each one.
Table 28.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 28.2 sys Schema Views
Table 28.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 28.4 sys Schema Stored Functions
| Function Name | Description |
|---|---|
extract_schema_from_file_name() | Extract schema name from file path name |
extract_table_from_file_name() | Extract table name from file path name |
format_bytes() | Convert byte count to value with units |
format_path() | Replace data and temp-file directories in path name with symbolic values |
format_statement() | Truncate long statement to fixed length |
format_time() | Convert picoseconds value to value with units |
list_add() | Add item to list |
list_drop() | Remove item from list |
ps_is_account_enabled() | Check whether account instrumentation is enabled |
ps_is_consumer_enabled() | Check whether consumer is enabled |
ps_is_instrument_default_enabled() | Check whether instrument is enabled |
ps_is_instrument_default_timed() | Check whether instrument is timed |
ps_is_thread_instrumented() | Check whether thread is instrumented |
ps_thread_account() | Return account for thread ID |
ps_thread_id() | Return thread ID for connection ID |
ps_thread_stack() | Return event information for thread ID |
ps_thread_trx_info() | Return transaction information for thread ID |
quote_identifier() | Return string as quoted identifier |
sys_get_config() | Return sys schema configuration option |
version_major() | MySQL server major version number |
version_minor() | MySQL server minor version number |
version_patch() | MySQL server patch release version number |