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 11.4 ES?

In 10.6 ES?

In 10.6 CS?

In 10.5 ES?


...

In 10.2 CS?

host_summary

11.4 ES

10.6 ES

10.6 CS

host_summary_by_file_io

11.4 ES

10.6 ES

10.6 CS

host_summary_by_file_io_type

11.4 ES

10.6 ES

10.6 CS

host_summary_by_stages

11.4 ES

10.6 ES

10.6 CS

host_summary_by_statement_latency

11.4 ES

10.6 ES

10.6 CS

host_summary_by_statement_type

11.4 ES

10.6 ES

10.6 CS

innodb_buffer_stats_by_schema

11.4 ES

10.6 ES

10.6 CS

innodb_buffer_stats_by_table

11.4 ES

10.6 ES

10.6 CS

innodb_lock_waits

11.4 ES

10.6 ES

10.6 CS

io_by_thread_by_latency

11.4 ES

10.6 ES

10.6 CS

io_global_by_file_by_bytes

11.4 ES

10.6 ES

10.6 CS

io_global_by_file_by_latency

11.4 ES

10.6 ES

10.6 CS

io_global_by_wait_by_bytes

11.4 ES

10.6 ES

10.6 CS

io_global_by_wait_by_latency

11.4 ES

10.6 ES

10.6 CS

latest_file_io

11.4 ES

10.6 ES

10.6 CS

memory_by_host_by_current_bytes

11.4 ES

10.6 ES

10.6 CS

memory_by_thread_by_current_bytes

11.4 ES

10.6 ES

10.6 CS

memory_by_user_by_current_bytes

11.4 ES

10.6 ES

10.6 CS

memory_global_by_current_bytes

11.4 ES

10.6 ES

10.6 CS

memory_global_total

11.4 ES

10.6 ES

10.6 CS

metrics

11.4 ES

10.6 ES

10.6 CS

processlist

11.4 ES

10.6 ES

10.6 CS

ps_check_lost_instrumentation

11.4 ES

10.6 ES

10.6 CS

schema_auto_increment_columns

11.4 ES

10.6 ES

10.6 CS

schema_index_statistics

11.4 ES

10.6 ES

10.6 CS

schema_object_overview

11.4 ES

10.6 ES

10.6 CS

schema_redundant_indexes

11.4 ES

10.6 ES

10.6 CS

schema_table_lock_waits

11.4 ES

10.6 ES

10.6 CS

schema_table_statistics

11.4 ES

10.6 ES

10.6 CS

schema_table_statistics_with_buffer

11.4 ES

10.6 ES

10.6 CS

schema_tables_with_full_table_scans

11.4 ES

10.6 ES

10.6 CS

schema_unused_indexes

11.4 ES

10.6 ES

10.6 CS

session

11.4 ES

10.6 ES

10.6 CS

session_ssl_status

11.4 ES

10.6 ES

10.6 CS

statement_analysis

11.4 ES

10.6 ES

10.6 CS

statements_with_errors_or_warnings

11.4 ES

10.6 ES

10.6 CS

statements_with_full_table_scans

11.4 ES

10.6 ES

10.6 CS

statements_with_runtimes_in_95th_percentile

11.4 ES

10.6 ES

10.6 CS

statements_with_sorting

11.4 ES

10.6 ES

10.6 CS

statements_with_temp_tables

11.4 ES

10.6 ES

10.6 CS

sys_config

11.4 ES

10.6 ES

10.6 CS

user_summary

11.4 ES

10.6 ES

10.6 CS

user_summary_by_file_io

11.4 ES

10.6 ES

10.6 CS

user_summary_by_file_io_type

11.4 ES

10.6 ES

10.6 CS

user_summary_by_stages

11.4 ES

10.6 ES

10.6 CS

user_summary_by_statement_latency

11.4 ES

10.6 ES

10.6 CS

user_summary_by_statement_type

11.4 ES

10.6 ES

10.6 CS

version

11.4 ES

10.6 ES

10.6 CS

wait_classes_global_by_avg_latency

11.4 ES

10.6 ES

10.6 CS

wait_classes_global_by_latency

11.4 ES

10.6 ES

10.6 CS

waits_by_host_by_latency

11.4 ES

10.6 ES

10.6 CS

waits_by_user_by_latency

11.4 ES

10.6 ES

10.6 CS

waits_global_by_latency

11.4 ES

10.6 ES

10.6 CS

x$host_summary

11.4 ES

10.6 ES

10.6 CS

x$host_summary_by_file_io

11.4 ES

10.6 ES

10.6 CS

x$host_summary_by_file_io_type

11.4 ES

10.6 ES

10.6 CS

x$host_summary_by_stages

11.4 ES

10.6 ES

10.6 CS

x$host_summary_by_statement_latency

11.4 ES

10.6 ES

10.6 CS

x$host_summary_by_statement_type

11.4 ES

10.6 ES

10.6 CS

x$innodb_buffer_stats_by_schema

11.4 ES

10.6 ES

10.6 CS

x$innodb_buffer_stats_by_table

11.4 ES

10.6 ES

10.6 CS

x$innodb_lock_waits

11.4 ES

10.6 ES

10.6 CS

x$io_by_thread_by_latency

11.4 ES

10.6 ES

10.6 CS

x$io_global_by_file_by_bytes

11.4 ES

10.6 ES

10.6 CS

x$io_global_by_file_by_latency

11.4 ES

10.6 ES

10.6 CS

x$io_global_by_wait_by_bytes

11.4 ES

10.6 ES

10.6 CS

x$io_global_by_wait_by_latency

11.4 ES

10.6 ES

10.6 CS

x$latest_file_io

11.4 ES

10.6 ES

10.6 CS

x$memory_by_host_by_current_bytes

11.4 ES

10.6 ES

10.6 CS

x$memory_by_thread_by_current_bytes

11.4 ES

10.6 ES

10.6 CS

x$memory_by_user_by_current_bytes

11.4 ES

10.6 ES

10.6 CS

x$memory_global_by_current_bytes

11.4 ES

10.6 ES

10.6 CS

x$memory_global_total

11.4 ES

10.6 ES

10.6 CS

x$processlist

11.4 ES

10.6 ES

10.6 CS

x$ps_digest_95th_percentile_by_avg_us

11.4 ES

10.6 ES

10.6 CS

x$ps_digest_avg_latency_distribution

11.4 ES

10.6 ES

10.6 CS

x$ps_schema_table_statistics_io

11.4 ES

10.6 ES

10.6 CS

x$schema_flattened_keys

11.4 ES

10.6 ES

10.6 CS

x$schema_index_statistics

11.4 ES

10.6 ES

10.6 CS

x$schema_table_lock_waits

11.4 ES

10.6 ES

10.6 CS

x$schema_table_statistics

11.4 ES

10.6 ES

10.6 CS

x$schema_table_statistics_with_buffer

11.4 ES

10.6 ES

10.6 CS

x$schema_tables_with_full_table_scans

11.4 ES

10.6 ES

10.6 CS

x$session

11.4 ES

10.6 ES

10.6 CS

x$statement_analysis

11.4 ES

10.6 ES

10.6 CS

x$statements_with_errors_or_warnings

11.4 ES

10.6 ES

10.6 CS

x$statements_with_full_table_scans

11.4 ES

10.6 ES

10.6 CS

x$statements_with_runtimes_in_95th_percentile

11.4 ES

10.6 ES

10.6 CS

x$statements_with_sorting

11.4 ES

10.6 ES

10.6 CS

x$statements_with_temp_tables

11.4 ES

10.6 ES

10.6 CS

x$user_summary

11.4 ES

10.6 ES

10.6 CS

x$user_summary_by_file_io

11.4 ES

10.6 ES

10.6 CS

x$user_summary_by_file_io_type

11.4 ES

10.6 ES

10.6 CS

x$user_summary_by_stages

11.4 ES

10.6 ES

10.6 CS

x$user_summary_by_statement_latency

11.4 ES

10.6 ES

10.6 CS

x$user_summary_by_statement_type

11.4 ES

10.6 ES

10.6 CS

x$wait_classes_global_by_avg_latency

11.4 ES

10.6 ES

10.6 CS

x$wait_classes_global_by_latency

11.4 ES

10.6 ES

10.6 CS

x$waits_by_host_by_latency

11.4 ES

10.6 ES

10.6 CS

x$waits_by_user_by_latency

11.4 ES

10.6 ES

10.6 CS

x$waits_global_by_latency

11.4 ES

10.6 ES

10.6 CS

Table

In 11.4 ES?

In 10.6 ES?

In 10.5 ES?

In 10.4 ES?

host_summary

11.4 ES

10.6 ES

host_summary_by_file_io

11.4 ES

10.6 ES

host_summary_by_file_io_type

11.4 ES

10.6 ES

host_summary_by_stages

11.4 ES

10.6 ES

host_summary_by_statement_latency

11.4 ES

10.6 ES

host_summary_by_statement_type

11.4 ES

10.6 ES

innodb_buffer_stats_by_schema

11.4 ES

10.6 ES

innodb_buffer_stats_by_table

11.4 ES

10.6 ES

innodb_lock_waits

11.4 ES

10.6 ES

io_by_thread_by_latency

11.4 ES

10.6 ES

io_global_by_file_by_bytes

11.4 ES

10.6 ES

io_global_by_file_by_latency

11.4 ES

10.6 ES

io_global_by_wait_by_bytes

11.4 ES

10.6 ES

io_global_by_wait_by_latency

11.4 ES

10.6 ES

latest_file_io

11.4 ES

10.6 ES

memory_by_host_by_current_bytes

11.4 ES

10.6 ES

memory_by_thread_by_current_bytes

11.4 ES

10.6 ES

memory_by_user_by_current_bytes

11.4 ES

10.6 ES

memory_global_by_current_bytes

11.4 ES

10.6 ES

memory_global_total

11.4 ES

10.6 ES

metrics

11.4 ES

10.6 ES

processlist

11.4 ES

10.6 ES

ps_check_lost_instrumentation

11.4 ES

10.6 ES

schema_auto_increment_columns

11.4 ES

10.6 ES

schema_index_statistics

11.4 ES

10.6 ES

schema_object_overview

11.4 ES

10.6 ES

schema_redundant_indexes

11.4 ES

10.6 ES

schema_table_lock_waits

11.4 ES

10.6 ES

schema_table_statistics

11.4 ES

10.6 ES

schema_table_statistics_with_buffer

11.4 ES

10.6 ES

schema_tables_with_full_table_scans

11.4 ES

10.6 ES

schema_unused_indexes

11.4 ES

10.6 ES

session

11.4 ES

10.6 ES

session_ssl_status

11.4 ES

10.6 ES

statement_analysis

11.4 ES

10.6 ES

statements_with_errors_or_warnings

11.4 ES

10.6 ES

statements_with_full_table_scans

11.4 ES

10.6 ES

statements_with_runtimes_in_95th_percentile

11.4 ES

10.6 ES

statements_with_sorting

11.4 ES

10.6 ES

statements_with_temp_tables

11.4 ES

10.6 ES

sys_config

11.4 ES

10.6 ES

user_summary

11.4 ES

10.6 ES

user_summary_by_file_io

11.4 ES

10.6 ES

user_summary_by_file_io_type

11.4 ES

10.6 ES

user_summary_by_stages

11.4 ES

10.6 ES

user_summary_by_statement_latency

11.4 ES

10.6 ES

user_summary_by_statement_type

11.4 ES

10.6 ES

version

11.4 ES

10.6 ES

wait_classes_global_by_avg_latency

11.4 ES

10.6 ES

wait_classes_global_by_latency

11.4 ES

10.6 ES

waits_by_host_by_latency

11.4 ES

10.6 ES

waits_by_user_by_latency

11.4 ES

10.6 ES

waits_global_by_latency

11.4 ES

10.6 ES

x$host_summary

11.4 ES

10.6 ES

x$host_summary_by_file_io

11.4 ES

10.6 ES

x$host_summary_by_file_io_type

11.4 ES

10.6 ES

x$host_summary_by_stages

11.4 ES

10.6 ES

x$host_summary_by_statement_latency

11.4 ES

10.6 ES

x$host_summary_by_statement_type

11.4 ES

10.6 ES

x$innodb_buffer_stats_by_schema

11.4 ES

10.6 ES

x$innodb_buffer_stats_by_table

11.4 ES

10.6 ES

x$innodb_lock_waits

11.4 ES

10.6 ES

x$io_by_thread_by_latency

11.4 ES

10.6 ES

x$io_global_by_file_by_bytes

11.4 ES

10.6 ES

x$io_global_by_file_by_latency

11.4 ES

10.6 ES

x$io_global_by_wait_by_bytes

11.4 ES

10.6 ES

x$io_global_by_wait_by_latency

11.4 ES

10.6 ES

x$latest_file_io

11.4 ES

10.6 ES

x$memory_by_host_by_current_bytes

11.4 ES

10.6 ES

x$memory_by_thread_by_current_bytes

11.4 ES

10.6 ES

x$memory_by_user_by_current_bytes

11.4 ES

10.6 ES

x$memory_global_by_current_bytes

11.4 ES

10.6 ES

x$memory_global_total

11.4 ES

10.6 ES

x$processlist

11.4 ES

10.6 ES

x$ps_digest_95th_percentile_by_avg_us

11.4 ES

10.6 ES

x$ps_digest_avg_latency_distribution

11.4 ES

10.6 ES

x$ps_schema_table_statistics_io

11.4 ES

10.6 ES

x$schema_flattened_keys

11.4 ES

10.6 ES

x$schema_index_statistics

11.4 ES

10.6 ES

x$schema_table_lock_waits

11.4 ES

10.6 ES

x$schema_table_statistics

11.4 ES

10.6 ES

x$schema_table_statistics_with_buffer

11.4 ES

10.6 ES

x$schema_tables_with_full_table_scans

11.4 ES

10.6 ES

x$session

11.4 ES

10.6 ES

x$statement_analysis

11.4 ES

10.6 ES

x$statements_with_errors_or_warnings

11.4 ES

10.6 ES

x$statements_with_full_table_scans

11.4 ES

10.6 ES

x$statements_with_runtimes_in_95th_percentile

11.4 ES

10.6 ES

x$statements_with_sorting

11.4 ES

10.6 ES

x$statements_with_temp_tables

11.4 ES

10.6 ES

x$user_summary

11.4 ES

10.6 ES

x$user_summary_by_file_io

11.4 ES

10.6 ES

x$user_summary_by_file_io_type

11.4 ES

10.6 ES

x$user_summary_by_stages

11.4 ES

10.6 ES

x$user_summary_by_statement_latency

11.4 ES

10.6 ES

x$user_summary_by_statement_type

11.4 ES

10.6 ES

x$wait_classes_global_by_avg_latency

11.4 ES

10.6 ES

x$wait_classes_global_by_latency

11.4 ES

10.6 ES

x$waits_by_host_by_latency

11.4 ES

10.6 ES

x$waits_by_user_by_latency

11.4 ES

10.6 ES

x$waits_global_by_latency

11.4 ES

10.6 ES