Lists the Table Configuration configuration metrics and provides a brief description of each.
Table 5.30 Table Configuration Configuration Metrics
| Name | Description |
|---|---|
| Big Tables Enabled (Total) | Enable large result sets by saving all temporary sets in files. |
| Default Storage Engine (Total) | Sets the default storage engine for tables. |
| Default Tmp Storage Engine (Total) | Sets the default storage engine for temporary tables (created with CREATE TEMPORARY TABLE). |
| Explicit Defaults For Timestamp Enabled (Total) | Sets whether TIMESTAMP columns should have an explicit DEFAULT clause. |
| Flush Enabled (Total) | Whether to flush (synchronize) all changes to disk after each SQL statement. |
| Flush Time (Total) | How often (in seconds) to close all tables, to free up resources and synchronize unflushed data to disk, for low resourcesystems. |
| Lock Wait Timeout (Total) | 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 (Total) | 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 (Total) | Whether table names are stored in lowercase or uppercase on disk, and whether comparisons are case sensitive or not. |
| Low Priority Updates Enabled (Total) | 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 (Total) | The maximum size to which user-created MEMORY tables are permitted to grow. |
| Max Tmp Tables (Total) | 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 (Total) | The size of the metadata locks cache. The server uses this cache to avoid creation and destruction of synchronization objects. |
| Metadata Locks Hash Instances (Total) | 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 (Total) | 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 (Total) | Changes the number of file descriptors available to mysqld. |
| Sync Frm Enabled (Total) | 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 (Total) | The number of table definitions that can be stored in the definition cache. |
| Table Open Cache (Total) | The number of concurrently open tables for all threads allowed. |
| Table Open Cache Instances (Total) | 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 (Total) | 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 (Total) | If this variable is set to 1, when any nontemporary table is created its .frm file is synchronized to disk (using fdatasync()). |