Configure the Performance Schema using these system variables to control buffer sizes, set instrumentation limits, and enable specific consumers at startup.
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_schemaDescription: If set to 1 (0 is default), enables the Performance Schema
Command line: --performance-schema=#
Scope: Global
Dynamic: No
Data Type: boolean
Default Value: OFF
performance_schema_accounts_sizeDescription: Maximum number of rows in the table. If set to 0, the will not store statistics in the accounts table. Use -1 (the default) for automated sizing.
Command line: --performance-schema-accounts-size=#
Scope: Global
performance_schema_digests_sizeDescription: Maximum number of rows that can be stored in the table. 0 for disabling, -1 (the default) for automated sizing.
Command line: --performance-schema-digests-size=#
Scope: Global
performance_schema_events_stages_history_long_sizeDescription: Number of rows in the table. 0 for disabling, -1 (the default) for automated sizing.
Command line: --performance-schema-events-stages-history-long-size=#
Scope: Global
performance_schema_events_stages_history_sizeDescription: Number of rows per thread in the table. 0 for disabling, -1 (the default) for automated sizing.
Command line: --performance-schema-events-stages-history-size=#
Scope: Global
performance_schema_events_statements_history_long_sizeDescription: Number of rows in the table. 0 for disabling, -1 (the default) for automated sizing.
Command line: --performance-schema-events-statements-history-long-size=#
Scope: Global
performance_schema_events_statements_history_sizeDescription: Number of rows per thread in the table. 0 for disabling, -1 (the default) for automated sizing.
Command line: --performance-schema-events-statements-history-size=#
Scope: Global
performance_schema_events_transactions_history_long_sizeDescription: Number of rows in table. Use 0 to disable, -1 for automated sizing.
Command line: --performance-schema-events-transactions-history-long-size=#
Scope: Global
performance_schema_events_transactions_history_sizeDescription:Number of rows per thread in . Use 0 to disable, -1 for automated sizing.
Command line: --performance-schema-events-transactions-history-size=#
Scope: Global
Dynamic: No
performance_schema_events_waits_history_long_sizeDescription: Number of rows contained in the table. 0 for disabling, -1 (the default) for automated sizing.
Command line: --performance-schema-events-waits-history-long-size=#
Scope: Global
performance_schema_events_waits_history_sizeDescription: Number of rows per thread contained in the table. 0 for disabling, -1 (the default) for automated sizing.
Command line: --performance-schema-events-waits-history-size=#
Scope: Global
performance_schema_hosts_sizeDescription: Number of rows stored in the table. If set to zero, no connection statistics are kept for the hosts table. -1 (the default) for automated sizing.
Command line: --performance-schema-hosts-size=#
Scope: Global
performance_schema_max_cond_classesDescription: Specifies the maximum number of condition instruments.
Command line: --performance-schema-max-cond-classes=#
Scope: Global
Dynamic: No
performance_schema_max_cond_instancesDescription: Specifies the maximum number of instrumented condition objects. 0 for disabling, -1 (the default) for automated sizing.
Command line: --performance-schema-max-cond-instances=#
Scope: Global
performance_schema_max_digest_lengthDescription: Maximum length considered for digest text, when stored in performance_schema tables.
Command line: --performance-schema-max-digest-length=#
Scope: Global
Dynamic: No
performance_schema_max_file_classesDescription: Specifies the maximum number of file instruments.
Command line: --performance-schema-max-file-classes=#
Scope: Global
Dynamic: No
performance_schema_max_file_handlesDescription: Specifies the maximum number of opened file objects. Should always be higher than .
Command line: --performance-schema-max-file-handles=#
Scope: Global
Dynamic: No
performance_schema_max_file_instancesDescription: Specifies the maximum number of instrumented file objects. 0 for disabling, -1 (the default) for automated sizing.
Command line: --performance-schema-max-file-instances=#
Scope: Global
performance_schema_max_index_statDescription: Maximum number of index statistics for instrumented tables. Use 0 to disable, -1 for automated scaling.
Command line: --performance-schema-max-index-stat=#
Scope: Global
Dynamic: No
performance_schema_max_memory_classesDescription: Maximum number of memory pool instruments.
Command line: --performance-schema-max-memory-classes=#
Scope: Global
Dynamic: No
performance_schema_max_metadata_locksDescription: Maximum number of . Use 0 to disable, -1 for automated scaling.
Command line: --performance-schema-max-metadata-locks=#
Scope: Global
Dynamic: No
performance_schema_max_mutex_classesDescription: Specifies the maximum number of mutex instruments.
Command line: --performance-schema-max-mutex-classes=#
Scope: Global
Dynamic: No
performance_schema_max_mutex_instancesDescription: Specifies the maximum number of instrumented mutex instances. 0 for disabling, -1 (the default) for automated sizing.
Command line: --performance-schema-max-mutex-instances=#
Scope: Global
performance_schema_max_prepared_statement_instancesDescription: Maximum number of instrumented prepared statements. Use 0 to disable, -1 for automated scaling.
Command line: --performance-schema-max-prepared-statement-instances=#
Scope: Global
Dynamic: No
performance_schema_max_program_instancesDescription: Maximum number of instrumented programs. Use 0 to disable, -1 for automated scaling.
Command line: --performance-schema-max-program-instances=#
Scope: Global
Dynamic: No
performance_schema_max_rwlock_classesDescription: Specifies the maximum number of rwlock instruments.
Command line: --performance-schema-max-rwlock-classes=#
Scope: Global
Dynamic: No
performance_schema_max_rwlock_instancesDescription: Specifies the maximum number of instrumented rwlock objects. 0 for disabling, -1 (the default) for automated sizing.
Command line: --performance-schema-max-rwlock-instances=#
Scope: Global
performance_schema_max_socket_classesDescription: Specifies the maximum number of socket instruments.
Command line: --performance-schema-max-socket-classes=#
Scope: Global
Dynamic: No
performance_schema_max_socket_instancesDescription: Specifies the maximum number of instrumented socket objects. 0 for disabling, -1 (the default) for automated sizing.
Command line: --performance-schema-max-socket-instances=#
Scope: Global
performance_schema_max_sql_text_lengthDescription: Maximum length of displayed sql text.
Command line: --performance-schema-max-sql-text-length=#
Scope: Global
Dynamic: No
performance_schema_max_stage_classesDescription: Specifies the maximum number of stage instruments.
Command line: --performance-schema-max-stage-classes=#
Scope: Global
Dynamic: No
performance_schema_max_statement_classesDescription: Specifies the maximum number of statement instruments. Automatically calculated at server build based on the number of available statements. Should be left as either autosized or disabled, as changing to any positive value has no benefit and will most likely allocate unnecessary memory. Setting to zero disables all statement instrumentation, and no memory will be allocated for this purpose.
Command line: --performance-schema-max-statement-classes=#
Scope: Global
performance_schema_max_statement_stackDescription: Number of rows per thread in EVENTS_STATEMENTS_CURRENT.
Command line: --performance-schema-max-statement-stack=#
Scope: Global
Dynamic: No
performance_schema_max_table_handlesDescription: Specifies the maximum number of opened table objects. 0 for disabling, -1 (the default) for automated sizing. See also the .
Command line: --performance-schema-max-table-handles=#
Scope: Global
performance_schema_max_table_instancesDescription: Specifies the maximum number of instrumented table objects. 0 for disabling, -1 (the default) for automated sizing.
Command line: --performance-schema-max-table-instances=#
Scope: Global
performance_schema_max_table_lock_statDescription: Maximum number of lock statistics for instrumented tables. Use 0 to disable, -1 for automated scaling.
Command line: --performance-schema-max-table-lock-stat=#
Scope: Global
Dynamic: No
performance_schema_max_thread_classesDescription: Specifies the maximum number of thread instruments.
Command line: --performance-schema-max-thread-classes=#
Scope: Global
Dynamic: No
performance_schema_max_thread_instancesDescription: Specifies how many of the running server threads (see and ) can be instrumented. Should be greater than the sum of max_connections and max_delayed_threads. 0 for disabling, -1 (the default) for automated sizing.
Command line: --performance-schema-max-thread-instances=#
Scope: Global
performance_schema_session_connect_attrs_sizeDescription: Per thread preallocated memory for holding connection attribute strings. Incremented if the strings are larger than the reserved space. 0 for disabling, -1 (the default) for automated sizing.
Command line: --performance-schema-session-connect-attrs-size=#
Scope: Global
performance_schema_setup_actors_sizeDescription: The maximum number of rows to store in the performance schema table. -1 (from MariaDB 10.5.2) denotes automated sizing.
Command line: --performance-schema-setup-actors-size=#
Scope: Global
performance_schema_setup_objects_sizeDescription: The maximum number of rows that can be stored in the performance schema table. -1 (from MariaDB 10.5.2) denotes automated sizing.
Command line: --performance-schema-setup-objects-size=#
Scope: Global
performance_schema_users_sizeDescription: Number of rows in the table. If set to 0, the will not store connection statistics in the users table. -1 (the default) for automated sizing.
Command line: --performance-schema-users-size=#
Scope: Global
This page is licensed: CC BY-SA / Gnu FDL
Data Type: numeric
Default Value: -1
Range: -1 to 1048576
Dynamic: No
Data Type: numeric
Default Value: -1
Range: -1 to 1048576
Dynamic: No
Data Type: numeric
Default Value: -1
Range: -1 to 1048576
Dynamic: No
Data Type: numeric
Default Value: -1
Range: -1 to 1024
Dynamic: No
Data Type: numeric
Default Value: -1
Range: -1 to 1048576
Dynamic: No
Data Type: numeric
Default Value: -1
Range: -1 to 1024
Data Type: numeric
Default Value: -1
Range: -1 to 1048576
Introduced: MariaDB 10.5.2
Data Type: numeric
Default Value: -1
Range: -1 to 1024
Introduced: MariaDB 10.5.2
Dynamic: No
Data Type: numeric
Default Value: -1
Range: -1 to 1048576
Dynamic: No
Data Type: numeric
Default Value: -1
Range: -1 to 1024
Data Type: numeric
Default Value: -1
Range: -1 to 1048576
Data Type: numeric
Default Value: 90 (>= MariaDB 10.5.1), 80 (<= MariaDB 10.5.0)
Range: 0 to 256
Data Type: numeric
Default Value: -1
Range: -1 to 1048576
Data Type: numeric
Default Value: 1024
Range: 0 to 1048576
Data Type: numeric
Default Value:80 (>= MariaDB 10.5.2), 50 (<= MariaDB 10.5.1)
Range: 0 to 256
Data Type: numeric
Default Value: 32768
Range: -1 to 32768
Data Type: numeric
Default Value: -1
Range: -1 to 1048576
Data Type: numeric
Default Value: -1
Range: -1 to 1048576
Introduced: MariaDB 10.5.2
Data Type: numeric
Default Value: 320
Range: 0 to 1024
Introduced: MariaDB 10.5.2
Data Type: numeric
Default Value: -1
Range: -1 to 104857600
Introduced: MariaDB 10.5.2
Data Type: numeric
Default Value: 210 (>= MariaDB 10.5.2), 200 (<= MariaDB 10.5.1)
Range: 0 to 256
Data Type: numeric
Default Value:-1
Range: -1 to 104857600
Data Type: numeric
Default Value: -1
Range: -1 to 1048576
Introduced: MariaDB 10.5.2
Data Type: numeric
Default Value: -1
Range: -1 to 1048576
Introduced: MariaDB 10.5.2
Data Type: numeric
Default Value: 50 (>= MariaDB 10.5.2), 40 (<= MariaDB 10.5.1)
Range: 0 to 256
Data Type: numeric
Default Value:-1
Range: -1 to 104857600
Data Type: numeric
Default Value: 10
Range: 0 to 256
Data Type: numeric
Default Value:-1
Range: -1 to 1048576
Data Type: numeric
Default Value: 1024
Range: 0 to 1048576
Introduced: MariaDB 10.5.2
Data Type: numeric
Default Value: 160
Range: 0 to 256
Data Type: numeric
Default Value: Autosized (see description)
Range: 0 to 256
Data Type: numeric
Default Value: 10
Range: 1 to 256
Introduced: MariaDB 10.5.2
Dynamic: No
Data Type: numeric
Default Value: -1
Range: -1 to 1048576
Data Type: numeric
Default Value:-1
Range: -1 to 1048576
Data Type: numeric
Default Value: -1
Range: -1 to 1048576
Introduced: MariaDB 10.5.2
Data Type: numeric
Default Value: 50
Range: 0 to 256
Dynamic: No
Data Type: numeric
Default Value:-1
Range: -1 to 1048576
Dynamic: No
Data Type: numeric
Default Value: -1
Range: -1 to 1048576
Data Type: numeric
Default Value: -1 (>= MariaDB 10.5.2), 100 (<= MariaDB 10.5.1)
Range: -1 to 1024 (>= MariaDB 10.5.2), 0 to 1024 (<= MariaDB 10.5.1)
Data Type: numeric
Default Value: -1 (>= MariaDB 10.5.2), 100 (<= MariaDB 10.5.1)
Range: -1 to 1048576 (>= MariaDB 10.5.2), 0 to 1048576 (<= MariaDB 10.5.1)
Data Type: numeric
Default Value: -1
Range: -1 to 1048576