Performance Schema Status Variables

This page documents status variables related to the Performance Schema. See Server Status Variables for a complete list of status variables that can be viewed with SHOW STATUS.

See also the Full list of MariaDB options, system and status variables.

Performance_schema_accounts_lost

  • Description: Number of times a row could not be added to the performance schema accounts table due to it being full. The global value can be flushed by FLUSH STATUS.
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 10.0.0

Performance_schema_cond_classes_lost

  • Description: Number of condition instruments that could not be loaded.
  • Scope: Global, Session
  • Data Type: numeric

Performance_schema_cond_instances_lost

  • Description: Number of instances a condition object could not be created. The global value can be flushed by FLUSH STATUS.
  • Scope: Global, Session
  • Data Type: numeric

Performance_schema_digest_lost

  • Description: The global value can be flushed by FLUSH STATUS.
  • Scope: Global, Session
  • Data Type: numeric

Performance_schema_file_classes_lost

  • Description: Number of file instruments that could not be loaded.
  • Scope: Global, Session
  • Data Type: numeric

Performance_schema_file_handles_lost

  • Description: Number of instances a file object could not be opened. The global value can be flushed by FLUSH STATUS.
  • Scope: Global, Session
  • Data Type: numeric

Performance_schema_file_instances_lost

  • Description: Number of instances a file object could not be created. The global value can be flushed by FLUSH STATUS.
  • Scope: Global, Session
  • Data Type: numeric

Performance_schema_hosts_lost

  • Description: Number of times a row could not be added to the performance schema hosts table due to it being full. The global value can be flushed by FLUSH STATUS.
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 10.0.0

Performance_schema_index_stat_lost

  • Description:
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 10.5.2

Performance_schema_locker_lost

  • Description: Number of events not recorded, due to either being recursive, or having a deeper nested events stack than the implementation limit. The global value can be flushed by FLUSH STATUS.
  • Scope: Global, Session
  • Data Type: numeric

Performance_schema_memory_classes_lost

  • Description:
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 10.5.2

Performance_schema_metadata_lock_lost

  • Description:
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 10.5.2

Performance_schema_mutex_classes_lost

  • Description: Number of mutual exclusion instruments that could not be loaded.
  • Scope: Global, Session
  • Data Type: numeric

Performance_schema_mutex_instances_lost

  • Description: Number of instances a mutual exclusion object could not be created. The global value can be flushed by FLUSH STATUS.
  • Scope: Global, Session
  • Data Type: numeric

Performance_schema_nested_statement_lost

  • Description:
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 10.5.2

Performance_schema_prepared_statements_lost

  • Description:
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 10.5.2

Performance_schema_program_lost

  • Description:
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 10.5.2

Performance_schema_rwlock_classes_lost

  • Description: Number of read/write lock instruments that could not be loaded.
  • Scope: Global, Session
  • Data Type: numeric

Performance_schema_rwlock_instances_lost

  • Description: Number of instances a read/write lock object could not be created. The global value can be flushed by FLUSH STATUS.
  • Scope: Global, Session
  • Data Type: numeric

Performance_schema_session_connect_attrs_lost

  • Description: Number of connections for which connection attribute truncation has occurred. The global value can be flushed by FLUSH STATUS.
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 10.0

Performance_schema_socket_classes_lost

  • Description:
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 10.0.0

Performance_schema_socket_instances_lost

  • Description: Number of instances a socket object could not be created. The global value can be flushed by FLUSH STATUS.
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 10.0.0

Performance_schema_stage_classes_lost

  • Description: Number of stage event instruments that could not be loaded. The global value can be flushed by FLUSH STATUS.
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 10.0.0

Performance_schema_statement_classes_lost

  • Description: Number of statement instruments that could not be loaded. The global value can be flushed by FLUSH STATUS.
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 10.0.0

Performance_schema_table_handles_lost

  • Description: Number of instances a table object could not be opened. The global value can be flushed by FLUSH STATUS.
  • Scope: Global, Session
  • Data Type: numeric

Performance_schema_table_instances_lost

  • Description: Number of instances a table object could not be created. The global value can be flushed by FLUSH STATUS.
  • Scope: Global, Session
  • Data Type: numeric

Performance_schema_table_lock_stat_lost

  • Description:
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 10.5.2

Performance_schema_thread_classes_lost

  • Description: Number of thread instruments that could not be loaded.
  • Scope: Global, Session
  • Data Type: numeric

Performance_schema_thread_instances_lost

  • Description: Number of instances thread object could not be created. The global value can be flushed by FLUSH STATUS.
  • Scope: Global, Session
  • Data Type: numeric

Performance_schema_users_lost

  • Description: Number of times a row could not be added to the performance schema users table due to it being full. The global value can be flushed by FLUSH STATUS.
  • Scope: Global, Session
  • Data Type: numeric

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.