Constant mariadb_sys::enum_table_category::TABLE_CATEGORY_PERFORMANCE

source · 
pub const TABLE_CATEGORY_PERFORMANCE: Type = 6;
Expand description

Performance schema tables. These tables are an interface provided by the system to inspect the system performance data. These tables do not honor:

  • LOCK TABLE t FOR READ/WRITE
  • FLUSH TABLES WITH READ LOCK
  • SET GLOBAL READ_ONLY = ON as there is no point in locking explicitly a PERFORMANCE_SCHEMA table. An example of PERFORMANCE_SCHEMA tables are:
  • performance_schema.* which are updated (but not using the handler interface) even when there is either a GLOBAL READ LOCK or a GLOBAL READ_ONLY in effect. User queries do not write directly to these tables (there are exceptions for SETUP_* tables). The server implementation perform writes. Performance tables are cached in the table cache.