The Performance Schema was introduced in MariaDB 5.5.
The following variables are used with MariaDB's Performance Schema. See Performance Schema Options for Performance Schema options that are not system variables. See Server System Variables for a complete list of system variables and instructions on setting them.
See also the Full list of MariaDB options, system and status variables.
performance_schema
1
(0 is default), enables the Performance Schema --performance-schema=#
boolean
OFF
(>= MariaDB 10.0.12), ON
(<= MariaDB 10.0.11) performance_schema_accounts_size
-1
(the default from MariaDB 10.0.12) for automated sizing. --performance-schema-accounts-size=#
numeric
-1
(>= MariaDB 10.0.12), 10
(<= MariaDB 10.0.11) -1
to 1048576
performance_schema_digests_size
0
for disabling, -1
(the default from MariaDB 10.0.12) for automated sizing. --performance-schema-digests-size=#
numeric
-1
(>= MariaDB 10.0.12), 1000
(<= MariaDB 10.0.11) -1
to 200
performance_schema_events_stages_history_long_size
0
for disabling, -1
(the default from MariaDB 10.0.12) for automated sizing. --performance-schema-events-stages-history-long-size=#
numeric
-1
(>= MariaDB 10.0.12), 10000
(<= MariaDB 10.0.11) -1
to 1048576
performance_schema_events_stages_history_size
0
for disabling, -1
(the default from MariaDB 10.0.12) for automated sizing. --performance-schema-events-stages-history-size=#
numeric
-1
(>= MariaDB 10.0.12), 10
(<= MariaDB 10.0.11) -1
to 1024
performance_schema_events_statements_history_long_size
0
for disabling, -1
(the default from MariaDB 10.0.12) for automated sizing. --performance-schema-events-statements-history-long-size=#
numeric
-1
(>= MariaDB 10.0.12), 100
(<= MariaDB 10.0.11) -1
to 1048576
performance_schema_events_statements_history_size
0
for disabling, -1
(the default from MariaDB 10.0.12) for automated sizing. --performance-schema-events-statements-history-size=#
numeric
-1
(>= MariaDB 10.0.12), 5
(<= MariaDB 10.0.11) -1
to 1024
performance_schema_events_waits_history_long_size
0
for disabling, -1
(the default from MariaDB 10.0.12) for automated sizing. --performance-schema-events-waits-history-long-size=#
numeric
-1
(>= MariaDB 10.0.12), 100
(<= MariaDB 10.0.11) -1
to 1048576
performance_schema_events_waits_history_size
0
for disabling, -1
(the default from MariaDB 10.0.12) for automated sizing. --performance-schema-events-waits-history-size=#
numeric
-1
(>= MariaDB 10.0.12), 5
(<= MariaDB 10.0.11) -1
to 1024
performance_schema_hosts_size
-1
(the default from MariaDB 10.0.12) for automated sizing. --performance-schema-hosts-size=#
numeric
-1
(>= MariaDB 10.0.12), 20
(<= MariaDB 10.0.11) -1
to 1048576
performance_schema_max_cond_classes
--performance-schema-max-cond-classes=#
numeric
80
0
to 256
performance_schema_max_cond_instances
0
for disabling, -1
(the default from MariaDB 10.0.12) for automated sizing. --performance-schema-max-cond-instances=#
numeric
-1
(>= MariaDB 10.0.12), 1000
(<= MariaDB 10.0.11) -1
to 1048576
performance_schema_max_digest_length
--performance-schema-max-digest-length=#
numeric
1024
0
to 1048576
performance_schema_max_file_classes
--performance-schema-max-file-classes=#
numeric
50
0
to 256
performance_schema_max_file_handles
--performance-schema-max-file-handles=#
numeric
32768
-1
to 32768
performance_schema_max_file_instances
0
for disabling, -1
(the default from MariaDB 10.0.12) for automated sizing. --performance-schema-max-file-instances=#
numeric
-1
(>= MariaDB 10.0.12), 10000
(<= MariaDB 10.0.11) -1
to 1048576
performance_schema_max_mutex_classes
--performance-schema-max-mutex-classes=#
numeric
200
0
to 256
performance_schema_max_mutex_instances
0
for disabling, -1
(the default from MariaDB 10.0.12) for automated sizing. --performance-schema-max-mutex-instances=#
numeric
-1
(>= MariaDB 10.0.12), 1000000
(<= MariaDB 10.0.11) -1
to 104857600
performance_schema_max_rwlock_classes
--performance-schema-max-rwlock-classes=#
numeric
40
0
to 256
performance_schema_max_rwlock_instances
0
for disabling, -1
(the default from MariaDB 10.0.12) for automated sizing. --performance-schema-max-rwlock-instances=#
numeric
-1
(>= MariaDB 10.0.12), 1000000
(<= MariaDB 10.0.11) -1
to 104857600
performance_schema_max_socket_classes
--performance-schema-max-socket-classes=#
numeric
10
0
to 256
performance_schema_max_socket_instances
0
for disabling, -1
(the default from MariaDB 10.0.12) for automated sizing. --performance-schema-max-socket-instances=#
numeric
-1
(>= MariaDB 10.0.12) -1
to 1048576
performance_schema_max_stage_classes
--performance-schema-max-stage-classes=#
numeric
160
(>= MariaDB 10.3.3), 150
(<= MariaDB 10.3.2) 0
to 256
performance_schema_max_statement_classes
--performance-schema-max-statement-classes=#
numeric
0
to 256
performance_schema_max_table_handles
0
for disabling, -1
(the default from MariaDB 10.0.12) for automated sizing. --performance-schema-max-table-handles=#
numeric
-1
(>= MariaDB 10.0.12), 10000
(<= MariaDB 10.0.11) -1
to 1048576
performance_schema_max_table_instances
0
for disabling, -1
(the default from MariaDB 10.0.12) for automated sizing. --performance-schema-max-table-instances=#
numeric
-1
(>= MariaDB 10.0.12), 1000
(<= MariaDB 10.0.11) -1
to 1048576
performance_schema_max_thread_classes
--performance-schema-max-thread-classes=#
numeric
50
0
to 256
performance_schema_max_thread_instances
0
for disabling, -1
(the default from MariaDB 10.0.12) for automated sizing. --performance-schema-max-thread-instances=#
numeric
-1
(>= MariaDB 10.0.12), 1000
(<= MariaDB 10.0.11) -1
to 1048576
performance_schema_session_connect_attrs_size
0
for disabling, -1
(the default from MariaDB 10.0.12) for automated sizing. --performance-schema-session-connect-attrs-size=#
numeric
-1
(>= MariaDB 10.0.12) -1
to 1048576
performance_schema_setup_actors_size
--performance-schema-setup-actors-size=#
numeric
100
0
to 1024
performance_schema_setup_objects_size
--performance-schema-setup-objects-size=#
numeric
100
0
to 1048576
performance_schema_users_size
-1
(the default from MariaDB 10.0.12) for automated sizing. --performance-schema-users-size=#
numeric
-1
(>= MariaDB 10.0.12) -1
to 1048576
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/performance-schema-system-variables/