The following tables show all sys
schema objects
available in MySQL Server. Each table contains these columns:
Name: The item name.
Introduced: The version or versions in which the item was introduced. This column appears only if it applies to some item.
Deprecated: The version or versions in which the item was deprecated. This column appears only if it applies to some item.
Removed: The version or versions in which the item was removed. This column appears only if it applies to some item.
-
Whether the item is available in the corresponding MySQL Server release series. The indicator links to the item description in the main reference manual if more information is available.
An item has a row in the table if it ever existed in any series shown in the table. The value displayed for a given series indicates item availability in that series:
Yes: The item is available in all production-ready General Availability (GA) versions. For a series that has not reached GA status, Yes indicates that the item is available in the most recently released pre-GA version.
Some: The item is available in some GA versions. This is the case if the item was introduced after the first GA version, or removed from some GA version.
Blank: The item is not available in any GA version. Either it does not exist in the series, or existed in pre-GA versions but was removed before the series reached GA status.
Table 6.2 sys Schema View Reference
View Name | Deprecated | 5.7 | 8.0 | 8.1 | 8.2 | 8.3 | 8.4 | 9.0 | 9.1 |
---|---|---|---|---|---|---|---|---|---|
host_summary , x$host_summary
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
host_summary_by_file_io , x$host_summary_by_file_io
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
host_summary_by_file_io_type , x$host_summary_by_file_io_type
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
host_summary_by_stages , x$host_summary_by_stages
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
host_summary_by_statement_latency , x$host_summary_by_statement_latency
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
host_summary_by_statement_type , x$host_summary_by_statement_type
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
innodb_buffer_stats_by_schema , x$innodb_buffer_stats_by_schema
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
innodb_buffer_stats_by_table , x$innodb_buffer_stats_by_table
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
innodb_lock_waits , x$innodb_lock_waits
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
io_by_thread_by_latency , x$io_by_thread_by_latency
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
io_global_by_file_by_bytes , x$io_global_by_file_by_bytes
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
io_global_by_file_by_latency , x$io_global_by_file_by_latency
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
io_global_by_wait_by_bytes , x$io_global_by_wait_by_bytes
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
io_global_by_wait_by_latency , x$io_global_by_wait_by_latency
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
latest_file_io , x$latest_file_io
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
memory_by_host_by_current_bytes , x$memory_by_host_by_current_bytes
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
memory_by_thread_by_current_bytes , x$memory_by_thread_by_current_bytes
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
memory_by_user_by_current_bytes , x$memory_by_user_by_current_bytes
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
memory_global_by_current_bytes , x$memory_global_by_current_bytes
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
memory_global_total , x$memory_global_total
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
metrics |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
processlist , x$processlist
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
ps_check_lost_instrumentation |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
schema_auto_increment_columns |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
schema_index_statistics , x$schema_index_statistics
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
schema_object_overview |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
schema_redundant_indexes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
schema_table_lock_waits , x$schema_table_lock_waits
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
schema_table_statistics , x$schema_table_statistics
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
schema_table_statistics_with_buffer , x$schema_table_statistics_with_buffer
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
schema_tables_with_full_table_scans , x$schema_tables_with_full_table_scans
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
schema_unused_indexes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
session , x$session
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
session_ssl_status |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
statement_analysis , x$statement_analysis
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
statements_with_errors_or_warnings , x$statements_with_errors_or_warnings
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
statements_with_full_table_scans , x$statements_with_full_table_scans
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
statements_with_runtimes_in_95th_percentile , x$statements_with_runtimes_in_95th_percentile
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
statements_with_sorting , x$statements_with_sorting
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
statements_with_temp_tables , x$statements_with_temp_tables
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
user_summary , x$user_summary
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
user_summary_by_file_io , x$user_summary_by_file_io
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
user_summary_by_file_io_type , x$user_summary_by_file_io_type
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
user_summary_by_stages , x$user_summary_by_stages
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
user_summary_by_statement_latency , x$user_summary_by_statement_latency
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
user_summary_by_statement_type , x$user_summary_by_statement_type
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
version |
5.7.28, 8.0.18 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
wait_classes_global_by_avg_latency , x$wait_classes_global_by_avg_latency
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
wait_classes_global_by_latency , x$wait_classes_global_by_latency
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
waits_by_host_by_latency , x$waits_by_host_by_latency
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
waits_by_user_by_latency , x$waits_by_user_by_latency
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
waits_global_by_latency , x$waits_global_by_latency
|
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
x$ps_digest_95th_percentile_by_avg_us |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
x$ps_digest_avg_latency_distribution |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
x$ps_schema_table_statistics_io |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
x$schema_flattened_keys |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Table 6.3 sys Schema Stored Procedure Reference
Stored Procedure Name | 5.7 | 8.0 | 8.1 | 8.2 | 8.3 | 8.4 | 9.0 | 9.1 |
---|---|---|---|---|---|---|---|---|
create_synonym_db() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
diagnostics() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
execute_prepared_stmt() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
ps_setup_disable_background_threads() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
ps_setup_disable_consumer() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
ps_setup_disable_instrument() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
ps_setup_disable_thread() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
ps_setup_enable_background_threads() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
ps_setup_enable_consumer() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
ps_setup_enable_instrument() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
ps_setup_enable_thread() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
ps_setup_reload_saved() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
ps_setup_reset_to_default() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
ps_setup_save() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
ps_setup_show_disabled() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
ps_setup_show_disabled_consumers() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
ps_setup_show_disabled_instruments() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
ps_setup_show_enabled() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
ps_setup_show_enabled_consumers() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
ps_setup_show_enabled_instruments() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
ps_statement_avg_latency_histogram() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
ps_trace_statement_digest() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
ps_trace_thread() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
ps_truncate_all_tables() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
statement_performance_analyzer() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
table_exists() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Table 6.4 sys Schema Stored Function Reference
Stored Function Name | Introduced | Deprecated | 5.7 | 8.0 | 8.1 | 8.2 | 8.3 | 8.4 | 9.0 | 9.1 |
---|---|---|---|---|---|---|---|---|---|---|
extract_schema_from_file_name() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
extract_table_from_file_name() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
format_bytes() |
8.0.16 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
format_path() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
format_statement() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
format_time() |
8.0.16 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
list_add() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
list_drop() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
ps_is_account_enabled() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
ps_is_consumer_enabled() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
ps_is_instrument_default_enabled() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
ps_is_instrument_default_timed() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
ps_is_thread_instrumented() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
ps_thread_account() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
ps_thread_id() |
8.0.16 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
ps_thread_stack() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
ps_thread_trx_info() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
quote_identifier() |
5.7.14 | Some | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
sys_get_config() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
version_major() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
version_minor() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
version_patch() |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |