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

In 10.6 CS?

In 10.5 ES?


...

In 10.2 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