7.34 Table Configuration Configuration Metrics

Lists the Table Configuration configuration metrics and provides a brief description of each.

Table 7.34 Table Configuration Configuration Metrics

Name	Description
Big Tables Enabled	Enable large result sets by saving all temporary sets in files.
Default Storage Engine	Sets the default storage engine for tables.
Default Tmp Storage Engine	Sets the default storage engine for temporary tables (created with CREATE TEMPORARY TABLE).
Explicit Defaults For Timestamp Enabled	Sets whether TIMESTAMP columns has an explicit DEFAULT clause.
Flush Enabled	Whether to flush (synchronize) all changes to disk after each SQL statement.
Flush Time	How often (in seconds) to close all tables, to free up resources and synchronize unflushed data to disk, for low resource systems.
Lock Wait Timeout	This timeout applies to all statements that use metadata locks. These include DML and DDL operations on tables, views, stored procedures, and stored functions, as well as LOCK TABLES, FLUSH TABLES WITH READ LOCK, and HANDLER statements.
Lower Case File System Enabled	describes the case sensitivity of file names on the file system where the data directory is located. OFF means file names are case sensitive, ON means they are not case sensitive.
Lower Case Table Names	Whether table names are stored in lowercase or uppercase on disk, and whether comparisons are case sensitive or not.
Low Priority Updates Enabled	When enabled, all INSERT, UPDATE, DELETE, and LOCK TABLE WRITE statements wait until there is no pending SELECT or LOCK TABLE READ on the affected table. This affects only storage engines that use only table-level locking (such as MyISAM, MEMORY, and MERGE).
Max Heap Table Size	The maximum size to which user-created MEMORY tables are permitted to grow.
Max Tmp Tables	The maximum number of temporary tables a client can keep open at the same time. (This variable does not yet do anything.).
Metadata Locks Cache Size	The size of the metadata locks cache. The server uses this cache to avoid creation and destruction of synchronization objects.
Metadata Locks Hash Instances	The set of metadata locks can be partitioned into separate hashes to permit connections accessing different objects to use different locking hashes and reduce contention.
Old Alter Table Enabled	Whether to revert to using a temporary table, copying over the data, and then renaming the temporary table to the original, as used by MySQL 5.0 and earlier.
Open Files Limit	Changes the number of file descriptors available to mysqld.
Sync Frm Enabled	If this variable is set to 1, when any nontemporary table is created its .frm file is synchronized to disk (using fdatasync()).
Table Definition Cache	The number of table definitions that can be stored in the definition cache.
Table Open Cache	The number of concurrently open tables for all threads allowed.
Table Open Cache Instances	The number of open tables cache instances (default 1). To improve scalability by reducing contention among sessions, the open tables cache can be partitioned into several smaller cache instances of size table_open_cache / table_open_cache_instances .
Tmp Table Size	The maximum size to which in-memory temporary tables are permitted to grow before being automatically converting to an on-disk temporary table.
Updatable Views With Limit Enabled	If this variable is set to 1, when any nontemporary table is created its .frm file is synchronized to disk (using fdatasync()).