Performance Schema Status Variables

You are viewing an old version of this article. View the current version here.

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
  • Introduced: MariaDB 5.5

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
  • Introduced: MariaDB 5.5

Performance_schema_digest_lost

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

Performance_schema_file_classes_lost

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

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
  • Introduced: MariaDB 5.5

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
  • Introduced: MariaDB 5.5

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_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
  • Introduced: MariaDB 5.5

Performance_schema_mutex_classes_lost

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

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
  • Introduced: MariaDB 5.5

Performance_schema_rwlock_classes_lost

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

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
  • Introduced: MariaDB 5.5

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
  • Introduced: MariaDB 5.5

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
  • Introduced: MariaDB 5.5

Performance_schema_thread_classes_lost

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

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
  • Introduced: MariaDB 5.5

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
  • Introduced: MariaDB 5.5

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.