PDF (US Ltr)
- 3.9Mb
PDF (A4)
- 3.9Mb
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 |