Constant mariadb_sys::enum_table_category::TABLE_CATEGORY_LOG

source · 
pub const TABLE_CATEGORY_LOG: Type = 4;
Expand description

Log tables. These tables are an interface provided by the system to inspect the system logs. 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 LOG table. An example of LOG tables are:
  • mysql.slow_log
  • mysql.general_log, which are updated 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 log tables). The server implementation perform writes. Log tables are cached in the table cache.