Performance Schema for MariaDB Enterprise Server 10.6

Overview

MariaDB Enterprise Server uses the Performance Schema to track data useful in troubleshooting performance related issues and events. In SkySQL, the Performance Schema is enabled and its tables are updated with current data. It is configured using SkySQL Configuration Manager.

MariaDB Enterprise Server uses the Performance Schema to track data useful in troubleshooting performance related issues and events. By default, the Performance Schema is disabled and its tables not updated with current data.

If you want to use the Performance Schema, set the performance_schema system variable and restart the Server:

[mariadb]
performance_schema = ON

When the Server starts back up, it begins using the Performance Schema.

Table

accounts

cond_instances

events_stages_current

events_stages_history

events_stages_history_long

events_stages_summary_by_account_by_event_name

events_stages_summary_by_host_by_event_name

events_stages_summary_by_thread_by_event_name

events_stages_summary_by_user_by_event_name

events_stages_summary_global_by_event_name

events_statements_current

events_statements_history

events_statements_history_long

events_statements_summary_by_account_by_event_name

events_statements_summary_by_digest

events_statements_summary_by_host_by_event_name

events_statements_summary_by_program

events_statements_summary_by_thread_by_event_name

events_statements_summary_by_user_by_event_name

events_statements_summary_global_by_event_name

events_transactions_current

events_transactions_history

events_transactions_history_long

events_transactions_summary_by_account_by_event_name

events_transactions_summary_by_host_by_event_name

events_transactions_summary_by_thread_by_event_name

events_transactions_summary_by_user_by_event_name

events_transactions_summary_global_by_event_name

events_waits_current

events_waits_history

events_waits_history_long

events_waits_summary_by_account_by_event_name

events_waits_summary_by_host_by_event_name

events_waits_summary_by_instance

events_waits_summary_by_thread_by_event_name

events_waits_summary_by_user_by_event_name

events_waits_summary_global_by_event_name

file_instances

file_summary_by_event_name

file_summary_by_instance

galera_group_member_stats

galera_group_members

global_status

global_variables

host_cache

hosts

memory_summary_by_account_by_event_name

memory_summary_by_host_by_event_name

memory_summary_by_thread_by_event_name

memory_summary_by_user_by_event_name

memory_summary_global_by_event_name

metadata_locks

mutex_instances

objects_summary_global_by_type

performance_timers

prepared_statements_instances

replication_applier_configuration

replication_applier_status

replication_applier_status_by_coordinator

replication_applier_status_by_worker

replication_connection_configuration

rwlock_instances

session_account_connect_attrs

session_connect_attrs

session_status

session_variables

setup_actors

setup_consumers

setup_instruments

setup_objects

setup_timers

socket_instances

socket_summary_by_event_name

socket_summary_by_instance

status_by_account

status_by_host

status_by_thread

status_by_user

table_handles

table_io_waits_summary_by_index_usage

table_io_waits_summary_by_table

table_lock_waits_summary_by_table

threads

user_variables_by_thread

users

variables_by_thread