Sys Database Tables for MariaDB Enterprise Server

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:

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

Summary of Sys Database Tables

Table

In 23.08 ES?

In 23.07 ES?

In 10.6 ES?

In 10.6 CS?

In 10.5 ES?


...

In 10.2 CS?

host_summary

23.08 ES

23.07 ES

10.6 ES

10.6 CS

host_summary_by_file_io

23.08 ES

23.07 ES

10.6 ES

10.6 CS

host_summary_by_file_io_type

23.08 ES

23.07 ES

10.6 ES

10.6 CS

host_summary_by_stages

23.08 ES

23.07 ES

10.6 ES

10.6 CS

host_summary_by_statement_latency

23.08 ES

23.07 ES

10.6 ES

10.6 CS

host_summary_by_statement_type

23.08 ES

23.07 ES

10.6 ES

10.6 CS

innodb_buffer_stats_by_schema

23.08 ES

23.07 ES

10.6 ES

10.6 CS

innodb_buffer_stats_by_table

23.08 ES

23.07 ES

10.6 ES

10.6 CS

innodb_lock_waits

23.08 ES

23.07 ES

10.6 ES

10.6 CS

io_by_thread_by_latency

23.08 ES

23.07 ES

10.6 ES

10.6 CS

io_global_by_file_by_bytes

23.08 ES

23.07 ES

10.6 ES

10.6 CS

io_global_by_file_by_latency

23.08 ES

23.07 ES

10.6 ES

10.6 CS

io_global_by_wait_by_bytes

23.08 ES

23.07 ES

10.6 ES

10.6 CS

io_global_by_wait_by_latency

23.08 ES

23.07 ES

10.6 ES

10.6 CS

latest_file_io

23.08 ES

23.07 ES

10.6 ES

10.6 CS

memory_by_host_by_current_bytes

23.08 ES

23.07 ES

10.6 ES

10.6 CS

memory_by_thread_by_current_bytes

23.08 ES

23.07 ES

10.6 ES

10.6 CS

memory_by_user_by_current_bytes

23.08 ES

23.07 ES

10.6 ES

10.6 CS

memory_global_by_current_bytes

23.08 ES

23.07 ES

10.6 ES

10.6 CS

memory_global_total

23.08 ES

23.07 ES

10.6 ES

10.6 CS

metrics

23.08 ES

23.07 ES

10.6 ES

10.6 CS

processlist

23.08 ES

23.07 ES

10.6 ES

10.6 CS

ps_check_lost_instrumentation

23.08 ES

23.07 ES

10.6 ES

10.6 CS

schema_auto_increment_columns

23.08 ES

23.07 ES

10.6 ES

10.6 CS

schema_index_statistics

23.08 ES

23.07 ES

10.6 ES

10.6 CS

schema_object_overview

23.08 ES

23.07 ES

10.6 ES

10.6 CS

schema_redundant_indexes

23.08 ES

23.07 ES

10.6 ES

10.6 CS

schema_table_lock_waits

23.08 ES

23.07 ES

10.6 ES

10.6 CS

schema_table_statistics

23.08 ES

23.07 ES

10.6 ES

10.6 CS

schema_table_statistics_with_buffer

23.08 ES

23.07 ES

10.6 ES

10.6 CS

schema_tables_with_full_table_scans

23.08 ES

23.07 ES

10.6 ES

10.6 CS

schema_unused_indexes

23.08 ES

23.07 ES

10.6 ES

10.6 CS

session

23.08 ES

23.07 ES

10.6 ES

10.6 CS

session_ssl_status

23.08 ES

23.07 ES

10.6 ES

10.6 CS

statement_analysis

23.08 ES

23.07 ES

10.6 ES

10.6 CS

statements_with_errors_or_warnings

23.08 ES

23.07 ES

10.6 ES

10.6 CS

statements_with_full_table_scans

23.08 ES

23.07 ES

10.6 ES

10.6 CS

statements_with_runtimes_in_95th_percentile

23.08 ES

23.07 ES

10.6 ES

10.6 CS

statements_with_sorting

23.08 ES

23.07 ES

10.6 ES

10.6 CS

statements_with_temp_tables

23.08 ES

23.07 ES

10.6 ES

10.6 CS

sys_config

23.08 ES

23.07 ES

10.6 ES

10.6 CS

user_summary

23.08 ES

23.07 ES

10.6 ES

10.6 CS

user_summary_by_file_io

23.08 ES

23.07 ES

10.6 ES

10.6 CS

user_summary_by_file_io_type

23.08 ES

23.07 ES

10.6 ES

10.6 CS

user_summary_by_stages

23.08 ES

23.07 ES

10.6 ES

10.6 CS

user_summary_by_statement_latency

23.08 ES

23.07 ES

10.6 ES

10.6 CS

user_summary_by_statement_type

23.08 ES

23.07 ES

10.6 ES

10.6 CS

version

23.08 ES

23.07 ES

10.6 ES

10.6 CS

wait_classes_global_by_avg_latency

23.08 ES

23.07 ES

10.6 ES

10.6 CS

wait_classes_global_by_latency

23.08 ES

23.07 ES

10.6 ES

10.6 CS

waits_by_host_by_latency

23.08 ES

23.07 ES

10.6 ES

10.6 CS

waits_by_user_by_latency

23.08 ES

23.07 ES

10.6 ES

10.6 CS

waits_global_by_latency

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$host_summary

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$host_summary_by_file_io

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$host_summary_by_file_io_type

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$host_summary_by_stages

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$host_summary_by_statement_latency

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$host_summary_by_statement_type

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$innodb_buffer_stats_by_schema

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$innodb_buffer_stats_by_table

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$innodb_lock_waits

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$io_by_thread_by_latency

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$io_global_by_file_by_bytes

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$io_global_by_file_by_latency

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$io_global_by_wait_by_bytes

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$io_global_by_wait_by_latency

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$latest_file_io

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$memory_by_host_by_current_bytes

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$memory_by_thread_by_current_bytes

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$memory_by_user_by_current_bytes

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$memory_global_by_current_bytes

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$memory_global_total

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$processlist

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$ps_digest_95th_percentile_by_avg_us

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$ps_digest_avg_latency_distribution

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$ps_schema_table_statistics_io

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$schema_flattened_keys

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$schema_index_statistics

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$schema_table_lock_waits

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$schema_table_statistics

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$schema_table_statistics_with_buffer

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$schema_tables_with_full_table_scans

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$session

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$statement_analysis

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$statements_with_errors_or_warnings

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$statements_with_full_table_scans

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$statements_with_runtimes_in_95th_percentile

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$statements_with_sorting

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$statements_with_temp_tables

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$user_summary

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$user_summary_by_file_io

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$user_summary_by_file_io_type

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$user_summary_by_stages

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$user_summary_by_statement_latency

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$user_summary_by_statement_type

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$wait_classes_global_by_avg_latency

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$wait_classes_global_by_latency

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$waits_by_host_by_latency

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$waits_by_user_by_latency

23.08 ES

23.07 ES

10.6 ES

10.6 CS

x$waits_global_by_latency

23.08 ES

23.07 ES

10.6 ES

10.6 CS

Table

In 23.08 ES?

In 23.07 ES?

In 10.6 ES?

In 10.5 ES?

In 10.4 ES?

host_summary

23.08 ES

23.07 ES

10.6 ES

host_summary_by_file_io

23.08 ES

23.07 ES

10.6 ES

host_summary_by_file_io_type

23.08 ES

23.07 ES

10.6 ES

host_summary_by_stages

23.08 ES

23.07 ES

10.6 ES

host_summary_by_statement_latency

23.08 ES

23.07 ES

10.6 ES

host_summary_by_statement_type

23.08 ES

23.07 ES

10.6 ES

innodb_buffer_stats_by_schema

23.08 ES

23.07 ES

10.6 ES

innodb_buffer_stats_by_table

23.08 ES

23.07 ES

10.6 ES

innodb_lock_waits

23.08 ES

23.07 ES

10.6 ES

io_by_thread_by_latency

23.08 ES

23.07 ES

10.6 ES

io_global_by_file_by_bytes

23.08 ES

23.07 ES

10.6 ES

io_global_by_file_by_latency

23.08 ES

23.07 ES

10.6 ES

io_global_by_wait_by_bytes

23.08 ES

23.07 ES

10.6 ES

io_global_by_wait_by_latency

23.08 ES

23.07 ES

10.6 ES

latest_file_io

23.08 ES

23.07 ES

10.6 ES

memory_by_host_by_current_bytes

23.08 ES

23.07 ES

10.6 ES

memory_by_thread_by_current_bytes

23.08 ES

23.07 ES

10.6 ES

memory_by_user_by_current_bytes

23.08 ES

23.07 ES

10.6 ES

memory_global_by_current_bytes

23.08 ES

23.07 ES

10.6 ES

memory_global_total

23.08 ES

23.07 ES

10.6 ES

metrics

23.08 ES

23.07 ES

10.6 ES

processlist

23.08 ES

23.07 ES

10.6 ES

ps_check_lost_instrumentation

23.08 ES

23.07 ES

10.6 ES

schema_auto_increment_columns

23.08 ES

23.07 ES

10.6 ES

schema_index_statistics

23.08 ES

23.07 ES

10.6 ES

schema_object_overview

23.08 ES

23.07 ES

10.6 ES

schema_redundant_indexes

23.08 ES

23.07 ES

10.6 ES

schema_table_lock_waits

23.08 ES

23.07 ES

10.6 ES

schema_table_statistics

23.08 ES

23.07 ES

10.6 ES

schema_table_statistics_with_buffer

23.08 ES

23.07 ES

10.6 ES

schema_tables_with_full_table_scans

23.08 ES

23.07 ES

10.6 ES

schema_unused_indexes

23.08 ES

23.07 ES

10.6 ES

session

23.08 ES

23.07 ES

10.6 ES

session_ssl_status

23.08 ES

23.07 ES

10.6 ES

statement_analysis

23.08 ES

23.07 ES

10.6 ES

statements_with_errors_or_warnings

23.08 ES

23.07 ES

10.6 ES

statements_with_full_table_scans

23.08 ES

23.07 ES

10.6 ES

statements_with_runtimes_in_95th_percentile

23.08 ES

23.07 ES

10.6 ES

statements_with_sorting

23.08 ES

23.07 ES

10.6 ES

statements_with_temp_tables

23.08 ES

23.07 ES

10.6 ES

sys_config

23.08 ES

23.07 ES

10.6 ES

user_summary

23.08 ES

23.07 ES

10.6 ES

user_summary_by_file_io

23.08 ES

23.07 ES

10.6 ES

user_summary_by_file_io_type

23.08 ES

23.07 ES

10.6 ES

user_summary_by_stages

23.08 ES

23.07 ES

10.6 ES

user_summary_by_statement_latency

23.08 ES

23.07 ES

10.6 ES

user_summary_by_statement_type

23.08 ES

23.07 ES

10.6 ES

version

23.08 ES

23.07 ES

10.6 ES

wait_classes_global_by_avg_latency

23.08 ES

23.07 ES

10.6 ES

wait_classes_global_by_latency

23.08 ES

23.07 ES

10.6 ES

waits_by_host_by_latency

23.08 ES

23.07 ES

10.6 ES

waits_by_user_by_latency

23.08 ES

23.07 ES

10.6 ES

waits_global_by_latency

23.08 ES

23.07 ES

10.6 ES

x$host_summary

23.08 ES

23.07 ES

10.6 ES

x$host_summary_by_file_io

23.08 ES

23.07 ES

10.6 ES

x$host_summary_by_file_io_type

23.08 ES

23.07 ES

10.6 ES

x$host_summary_by_stages

23.08 ES

23.07 ES

10.6 ES

x$host_summary_by_statement_latency

23.08 ES

23.07 ES

10.6 ES

x$host_summary_by_statement_type

23.08 ES

23.07 ES

10.6 ES

x$innodb_buffer_stats_by_schema

23.08 ES

23.07 ES

10.6 ES

x$innodb_buffer_stats_by_table

23.08 ES

23.07 ES

10.6 ES

x$innodb_lock_waits

23.08 ES

23.07 ES

10.6 ES

x$io_by_thread_by_latency

23.08 ES

23.07 ES

10.6 ES

x$io_global_by_file_by_bytes

23.08 ES

23.07 ES

10.6 ES

x$io_global_by_file_by_latency

23.08 ES

23.07 ES

10.6 ES

x$io_global_by_wait_by_bytes

23.08 ES

23.07 ES

10.6 ES

x$io_global_by_wait_by_latency

23.08 ES

23.07 ES

10.6 ES

x$latest_file_io

23.08 ES

23.07 ES

10.6 ES

x$memory_by_host_by_current_bytes

23.08 ES

23.07 ES

10.6 ES

x$memory_by_thread_by_current_bytes

23.08 ES

23.07 ES

10.6 ES

x$memory_by_user_by_current_bytes

23.08 ES

23.07 ES

10.6 ES

x$memory_global_by_current_bytes

23.08 ES

23.07 ES

10.6 ES

x$memory_global_total

23.08 ES

23.07 ES

10.6 ES

x$processlist

23.08 ES

23.07 ES

10.6 ES

x$ps_digest_95th_percentile_by_avg_us

23.08 ES

23.07 ES

10.6 ES

x$ps_digest_avg_latency_distribution

23.08 ES

23.07 ES

10.6 ES

x$ps_schema_table_statistics_io

23.08 ES

23.07 ES

10.6 ES

x$schema_flattened_keys

23.08 ES

23.07 ES

10.6 ES

x$schema_index_statistics

23.08 ES

23.07 ES

10.6 ES

x$schema_table_lock_waits

23.08 ES

23.07 ES

10.6 ES

x$schema_table_statistics

23.08 ES

23.07 ES

10.6 ES

x$schema_table_statistics_with_buffer

23.08 ES

23.07 ES

10.6 ES

x$schema_tables_with_full_table_scans

23.08 ES

23.07 ES

10.6 ES

x$session

23.08 ES

23.07 ES

10.6 ES

x$statement_analysis

23.08 ES

23.07 ES

10.6 ES

x$statements_with_errors_or_warnings

23.08 ES

23.07 ES

10.6 ES

x$statements_with_full_table_scans

23.08 ES

23.07 ES

10.6 ES

x$statements_with_runtimes_in_95th_percentile

23.08 ES

23.07 ES

10.6 ES

x$statements_with_sorting

23.08 ES

23.07 ES

10.6 ES

x$statements_with_temp_tables

23.08 ES

23.07 ES

10.6 ES

x$user_summary

23.08 ES

23.07 ES

10.6 ES

x$user_summary_by_file_io

23.08 ES

23.07 ES

10.6 ES

x$user_summary_by_file_io_type

23.08 ES

23.07 ES

10.6 ES

x$user_summary_by_stages

23.08 ES

23.07 ES

10.6 ES

x$user_summary_by_statement_latency

23.08 ES

23.07 ES

10.6 ES

x$user_summary_by_statement_type

23.08 ES

23.07 ES

10.6 ES

x$wait_classes_global_by_avg_latency

23.08 ES

23.07 ES

10.6 ES

x$wait_classes_global_by_latency

23.08 ES

23.07 ES

10.6 ES

x$waits_by_host_by_latency

23.08 ES

23.07 ES

10.6 ES

x$waits_by_user_by_latency

23.08 ES

23.07 ES

10.6 ES

x$waits_global_by_latency

23.08 ES

23.07 ES

10.6 ES