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 
  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 
  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 
  Performance_schema_socket_classes_lost 

Description: 

Scope: Global, Session 

Data Type: numeric 
  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 
  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 
  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 
  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 
     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.  

    
{'path': 'public/docs/mariadb/performance-schema-status-variables/index.html', 'source': 'DevDocs.IO'}