Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 38.1Mb
PDF (A4) - 38.1Mb
PDF (RPM) - 33.0Mb
HTML Download (TGZ) - 8.1Mb
HTML Download (Zip) - 8.1Mb
HTML Download (RPM) - 7.0Mb
Man Pages (TGZ) - 132.7Kb
Man Pages (Zip) - 189.0Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

MySQL 8.0 Reference Manual  /  ...  /  sys Schema Object Index

26.4.1 sys Schema Object Index

The following tables list sys schema objects and provide a short description of each one.

Table 26.1 sys Schema Tables and Triggers

Table or Trigger Name Description
sys_config sys schema configuration options
sys_config_insert_set_user sys_config insert trigger
sys_config_update_set_user sys_config update trigger

Table 26.2 sys Schema Views

View Name Description
host_summary, x$host_summary Statement activity, file I/O, and connections, grouped by host
host_summary_by_file_io, x$host_summary_by_file_io File I/O, grouped by host
host_summary_by_file_io_type, x$host_summary_by_file_io_type File I/O, grouped by host and event type
host_summary_by_stages, x$host_summary_by_stages Statement stages, grouped by host
host_summary_by_statement_latency, x$host_summary_by_statement_latency Statement statistics, grouped by host
host_summary_by_statement_type, x$host_summary_by_statement_type Statements executed, grouped by host and statement
innodb_buffer_stats_by_schema, x$innodb_buffer_stats_by_schema InnoDB buffer information, grouped by schema
innodb_buffer_stats_by_table, x$innodb_buffer_stats_by_table InnoDB buffer information, grouped by schema and table
innodb_lock_waits, x$innodb_lock_waits InnoDB lock information
io_by_thread_by_latency, x$io_by_thread_by_latency I/O consumers, grouped by thread
io_global_by_file_by_bytes, x$io_global_by_file_by_bytes Global I/O consumers, grouped by file and bytes
io_global_by_file_by_latency, x$io_global_by_file_by_latency Global I/O consumers, grouped by file and latency
io_global_by_wait_by_bytes, x$io_global_by_wait_by_bytes Global I/O consumers, grouped by bytes
io_global_by_wait_by_latency, x$io_global_by_wait_by_latency Global I/O consumers, grouped by latency
latest_file_io, x$latest_file_io Most recent I/O, grouped by file and thread
memory_by_host_by_current_bytes, x$memory_by_host_by_current_bytes Memory use, grouped by host
memory_by_thread_by_current_bytes, x$memory_by_thread_by_current_bytes Memory use, grouped by thread
memory_by_user_by_current_bytes, x$memory_by_user_by_current_bytes Memory use, grouped by user
memory_global_by_current_bytes, x$memory_global_by_current_bytes Memory use, grouped by allocation type
memory_global_total, x$memory_global_total Total memory use
metrics Server metrics
processlist, x$processlist Processlist information
ps_check_lost_instrumentation Variables that have lost instruments
schema_auto_increment_columns AUTO_INCREMENT column information
schema_index_statistics, x$schema_index_statistics Index statistics
schema_object_overview Types of objects within each schema
schema_redundant_indexes Duplicate or redundant indexes
schema_table_lock_waits, x$schema_table_lock_waits Sessions waiting for metadata locks
schema_table_statistics, x$schema_table_statistics Table statistics
schema_table_statistics_with_buffer, x$schema_table_statistics_with_buffer Table statistics, including InnoDB buffer pool statistics
schema_tables_with_full_table_scans, x$schema_tables_with_full_table_scans Tables being accessed with full scans
schema_unused_indexes Indexes not in active use
session, x$session Processlist information for user sessions
session_ssl_status Connection SSL information
statement_analysis, x$statement_analysis Statement aggregate statistics
statements_with_errors_or_warnings, x$statements_with_errors_or_warnings Statements that have produced errors or warnings
statements_with_full_table_scans, x$statements_with_full_table_scans Statements that have done full table scans
statements_with_runtimes_in_95th_percentile, x$statements_with_runtimes_in_95th_percentile Statements with highest average runtime
statements_with_sorting, x$statements_with_sorting Statements that performed sorts
statements_with_temp_tables, x$statements_with_temp_tables Statements that used temporary tables
user_summary, x$user_summary User statement and connection activity
user_summary_by_file_io, x$user_summary_by_file_io File I/O, grouped by user
user_summary_by_file_io_type, x$user_summary_by_file_io_type File I/O, grouped by user and event
user_summary_by_stages, x$user_summary_by_stages Stage events, grouped by user
user_summary_by_statement_latency, x$user_summary_by_statement_latency Statement statistics, grouped by user
user_summary_by_statement_type, x$user_summary_by_statement_type Statements executed, grouped by user and statement
version Current sys schema and MySQL server versions
wait_classes_global_by_avg_latency, x$wait_classes_global_by_avg_latency Wait class average latency, grouped by event class
wait_classes_global_by_latency, x$wait_classes_global_by_latency Wait class total latency, grouped by event class
waits_by_host_by_latency, x$waits_by_host_by_latency Wait events, grouped by host and event
waits_by_user_by_latency, x$waits_by_user_by_latency Wait events, grouped by user and event
waits_global_by_latency, x$waits_global_by_latency Wait events, grouped by event
x$ps_digest_95th_percentile_by_avg_us Helper view for 95th-percentile views
x$ps_digest_avg_latency_distribution Helper view for 95th-percentile views
x$ps_schema_table_statistics_io Helper view for table-statistics views
x$schema_flattened_keys Helper view for schema_redundant_indexes

Table 26.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 26.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 value 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

User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.