Sys Database Tables for MariaDB Enterprise Server

This page is part of MariaDB's Documentation.

The parent of this page is: Reference for MariaDB Enterprise Server

Topics on this page:

Overview
Sys Database Tables by MariaDB Server Version
Summary of Sys Database Tables

Overview

MariaDB Enterprise Server creates system-status VIEWs in the SYS database.

Reference material is available for MariaDB Enterprise Server.

Sys Database Tables by MariaDB Server Version

Choose a version of MariaDB Enterprise Server to see the sys database tables present in that version:

Sys Database Tables for MariaDB Enterprise Server 10.6

Choose a version of MariaDB Community Server to see the sys database tables present in that version:

Sys Database Tables for MariaDB Community Server 10.6

Summary of Sys Database Tables

Table	In 10.6 ES?	In 10.6 CS?
host_summary	10.6 ES	10.6 CS
host_summary_by_file_io	10.6 ES	10.6 CS
host_summary_by_file_io_type	10.6 ES	10.6 CS
host_summary_by_stages	10.6 ES	10.6 CS
host_summary_by_statement_latency	10.6 ES	10.6 CS
host_summary_by_statement_type	10.6 ES	10.6 CS
innodb_buffer_stats_by_schema	10.6 ES	10.6 CS
innodb_buffer_stats_by_table	10.6 ES	10.6 CS
innodb_lock_waits	10.6 ES	10.6 CS
io_by_thread_by_latency	10.6 ES	10.6 CS
io_global_by_file_by_bytes	10.6 ES	10.6 CS
io_global_by_file_by_latency	10.6 ES	10.6 CS
io_global_by_wait_by_bytes	10.6 ES	10.6 CS
io_global_by_wait_by_latency	10.6 ES	10.6 CS
latest_file_io	10.6 ES	10.6 CS
memory_by_host_by_current_bytes	10.6 ES	10.6 CS
memory_by_thread_by_current_bytes	10.6 ES	10.6 CS
memory_by_user_by_current_bytes	10.6 ES	10.6 CS
memory_global_by_current_bytes	10.6 ES	10.6 CS
memory_global_total	10.6 ES	10.6 CS
metrics	10.6 ES	10.6 CS
processlist	10.6 ES	10.6 CS
ps_check_lost_instrumentation	10.6 ES	10.6 CS
schema_auto_increment_columns	10.6 ES	10.6 CS
schema_index_statistics	10.6 ES	10.6 CS
schema_object_overview	10.6 ES	10.6 CS
schema_redundant_indexes	10.6 ES	10.6 CS
schema_table_lock_waits	10.6 ES	10.6 CS
schema_table_statistics	10.6 ES	10.6 CS
schema_table_statistics_with_buffer	10.6 ES	10.6 CS
schema_tables_with_full_table_scans	10.6 ES	10.6 CS
schema_unused_indexes	10.6 ES	10.6 CS
session	10.6 ES	10.6 CS
session_ssl_status	10.6 ES	10.6 CS
statement_analysis	10.6 ES	10.6 CS
statements_with_errors_or_warnings	10.6 ES	10.6 CS
statements_with_full_table_scans	10.6 ES	10.6 CS
statements_with_runtimes_in_95th_percentile	10.6 ES	10.6 CS
statements_with_sorting	10.6 ES	10.6 CS
statements_with_temp_tables	10.6 ES	10.6 CS
sys_config	10.6 ES	10.6 CS
user_summary	10.6 ES	10.6 CS
user_summary_by_file_io	10.6 ES	10.6 CS
user_summary_by_file_io_type	10.6 ES	10.6 CS
user_summary_by_stages	10.6 ES	10.6 CS
user_summary_by_statement_latency	10.6 ES	10.6 CS
user_summary_by_statement_type	10.6 ES	10.6 CS
version	10.6 ES	10.6 CS
wait_classes_global_by_avg_latency	10.6 ES	10.6 CS
wait_classes_global_by_latency	10.6 ES	10.6 CS
waits_by_host_by_latency	10.6 ES	10.6 CS
waits_by_user_by_latency	10.6 ES	10.6 CS
waits_global_by_latency	10.6 ES	10.6 CS
x$host_summary	10.6 ES	10.6 CS
x$host_summary_by_file_io	10.6 ES	10.6 CS
x$host_summary_by_file_io_type	10.6 ES	10.6 CS
x$host_summary_by_stages	10.6 ES	10.6 CS
x$host_summary_by_statement_latency	10.6 ES	10.6 CS
x$host_summary_by_statement_type	10.6 ES	10.6 CS
x$innodb_buffer_stats_by_schema	10.6 ES	10.6 CS
x$innodb_buffer_stats_by_table	10.6 ES	10.6 CS
x$innodb_lock_waits	10.6 ES	10.6 CS
x$io_by_thread_by_latency	10.6 ES	10.6 CS
x$io_global_by_file_by_bytes	10.6 ES	10.6 CS
x$io_global_by_file_by_latency	10.6 ES	10.6 CS
x$io_global_by_wait_by_bytes	10.6 ES	10.6 CS
x$io_global_by_wait_by_latency	10.6 ES	10.6 CS
x$latest_file_io	10.6 ES	10.6 CS
x$memory_by_host_by_current_bytes	10.6 ES	10.6 CS
x$memory_by_thread_by_current_bytes	10.6 ES	10.6 CS
x$memory_by_user_by_current_bytes	10.6 ES	10.6 CS
x$memory_global_by_current_bytes	10.6 ES	10.6 CS
x$memory_global_total	10.6 ES	10.6 CS
x$processlist	10.6 ES	10.6 CS
x$ps_digest_95th_percentile_by_avg_us	10.6 ES	10.6 CS
x$ps_digest_avg_latency_distribution	10.6 ES	10.6 CS
x$ps_schema_table_statistics_io	10.6 ES	10.6 CS
x$schema_flattened_keys	10.6 ES	10.6 CS
x$schema_index_statistics	10.6 ES	10.6 CS
x$schema_table_lock_waits	10.6 ES	10.6 CS
x$schema_table_statistics	10.6 ES	10.6 CS
x$schema_table_statistics_with_buffer	10.6 ES	10.6 CS
x$schema_tables_with_full_table_scans	10.6 ES	10.6 CS
x$session	10.6 ES	10.6 CS
x$statement_analysis	10.6 ES	10.6 CS
x$statements_with_errors_or_warnings	10.6 ES	10.6 CS
x$statements_with_full_table_scans	10.6 ES	10.6 CS
x$statements_with_runtimes_in_95th_percentile	10.6 ES	10.6 CS
x$statements_with_sorting	10.6 ES	10.6 CS
x$statements_with_temp_tables	10.6 ES	10.6 CS
x$user_summary	10.6 ES	10.6 CS
x$user_summary_by_file_io	10.6 ES	10.6 CS
x$user_summary_by_file_io_type	10.6 ES	10.6 CS
x$user_summary_by_stages	10.6 ES	10.6 CS
x$user_summary_by_statement_latency	10.6 ES	10.6 CS
x$user_summary_by_statement_type	10.6 ES	10.6 CS
x$wait_classes_global_by_avg_latency	10.6 ES	10.6 CS
x$wait_classes_global_by_latency	10.6 ES	10.6 CS
x$waits_by_host_by_latency	10.6 ES	10.6 CS
x$waits_by_user_by_latency	10.6 ES	10.6 CS
x$waits_global_by_latency	10.6 ES	10.6 CS

Table	In 10.6 ES?	In 10.5 ES?	In 10.4 ES?
host_summary	10.6 ES
host_summary_by_file_io	10.6 ES
host_summary_by_file_io_type	10.6 ES
host_summary_by_stages	10.6 ES
host_summary_by_statement_latency	10.6 ES
host_summary_by_statement_type	10.6 ES
innodb_buffer_stats_by_schema	10.6 ES
innodb_buffer_stats_by_table	10.6 ES
innodb_lock_waits	10.6 ES
io_by_thread_by_latency	10.6 ES
io_global_by_file_by_bytes	10.6 ES
io_global_by_file_by_latency	10.6 ES
io_global_by_wait_by_bytes	10.6 ES
io_global_by_wait_by_latency	10.6 ES
latest_file_io	10.6 ES
memory_by_host_by_current_bytes	10.6 ES
memory_by_thread_by_current_bytes	10.6 ES
memory_by_user_by_current_bytes	10.6 ES
memory_global_by_current_bytes	10.6 ES
memory_global_total	10.6 ES
metrics	10.6 ES
processlist	10.6 ES
ps_check_lost_instrumentation	10.6 ES
schema_auto_increment_columns	10.6 ES
schema_index_statistics	10.6 ES
schema_object_overview	10.6 ES
schema_redundant_indexes	10.6 ES
schema_table_lock_waits	10.6 ES
schema_table_statistics	10.6 ES
schema_table_statistics_with_buffer	10.6 ES
schema_tables_with_full_table_scans	10.6 ES
schema_unused_indexes	10.6 ES
session	10.6 ES
session_ssl_status	10.6 ES
statement_analysis	10.6 ES
statements_with_errors_or_warnings	10.6 ES
statements_with_full_table_scans	10.6 ES
statements_with_runtimes_in_95th_percentile	10.6 ES
statements_with_sorting	10.6 ES
statements_with_temp_tables	10.6 ES
sys_config	10.6 ES
user_summary	10.6 ES
user_summary_by_file_io	10.6 ES
user_summary_by_file_io_type	10.6 ES
user_summary_by_stages	10.6 ES
user_summary_by_statement_latency	10.6 ES
user_summary_by_statement_type	10.6 ES
version	10.6 ES
wait_classes_global_by_avg_latency	10.6 ES
wait_classes_global_by_latency	10.6 ES
waits_by_host_by_latency	10.6 ES
waits_by_user_by_latency	10.6 ES
waits_global_by_latency	10.6 ES
x$host_summary	10.6 ES
x$host_summary_by_file_io	10.6 ES
x$host_summary_by_file_io_type	10.6 ES
x$host_summary_by_stages	10.6 ES
x$host_summary_by_statement_latency	10.6 ES
x$host_summary_by_statement_type	10.6 ES
x$innodb_buffer_stats_by_schema	10.6 ES
x$innodb_buffer_stats_by_table	10.6 ES
x$innodb_lock_waits	10.6 ES
x$io_by_thread_by_latency	10.6 ES
x$io_global_by_file_by_bytes	10.6 ES
x$io_global_by_file_by_latency	10.6 ES
x$io_global_by_wait_by_bytes	10.6 ES
x$io_global_by_wait_by_latency	10.6 ES
x$latest_file_io	10.6 ES
x$memory_by_host_by_current_bytes	10.6 ES
x$memory_by_thread_by_current_bytes	10.6 ES
x$memory_by_user_by_current_bytes	10.6 ES
x$memory_global_by_current_bytes	10.6 ES
x$memory_global_total	10.6 ES
x$processlist	10.6 ES
x$ps_digest_95th_percentile_by_avg_us	10.6 ES
x$ps_digest_avg_latency_distribution	10.6 ES
x$ps_schema_table_statistics_io	10.6 ES
x$schema_flattened_keys	10.6 ES
x$schema_index_statistics	10.6 ES
x$schema_table_lock_waits	10.6 ES
x$schema_table_statistics	10.6 ES
x$schema_table_statistics_with_buffer	10.6 ES
x$schema_tables_with_full_table_scans	10.6 ES
x$session	10.6 ES
x$statement_analysis	10.6 ES
x$statements_with_errors_or_warnings	10.6 ES
x$statements_with_full_table_scans	10.6 ES
x$statements_with_runtimes_in_95th_percentile	10.6 ES
x$statements_with_sorting	10.6 ES
x$statements_with_temp_tables	10.6 ES
x$user_summary	10.6 ES
x$user_summary_by_file_io	10.6 ES
x$user_summary_by_file_io_type	10.6 ES
x$user_summary_by_stages	10.6 ES
x$user_summary_by_statement_latency	10.6 ES
x$user_summary_by_statement_type	10.6 ES
x$wait_classes_global_by_avg_latency	10.6 ES
x$wait_classes_global_by_latency	10.6 ES
x$waits_by_host_by_latency	10.6 ES
x$waits_by_user_by_latency	10.6 ES
x$waits_global_by_latency	10.6 ES