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 table
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	Deprecated
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	5.7.28
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	Introduced
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
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
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
ps_thread_stack()	Event information for connection ID
ps_thread_trx_info()	Transaction information for thread ID
quote_identifier()	Quote string as identifier	5.7.14
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