Documentation Home
Oracle Enterprise Manager for MySQL Database User's Guide
Download this Manual
PDF (US Ltr) - 0.7Mb
PDF (A4) - 0.7Mb
HTML Download (TGZ) - 223.8Kb
HTML Download (Zip) - 231.3Kb


Oracle Enterprise Manager for MySQL Database User's Guide  /  Configuration Metrics  /  Table Configuration Configuration Metrics

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

NameDescription
Big Tables EnabledEnable large result sets by saving all temporary sets in files.
Default Storage EngineSets the default storage engine for tables.
Default Tmp Storage EngineSets the default storage engine for temporary tables (created with CREATE TEMPORARY TABLE).
Explicit Defaults For Timestamp EnabledSets whether TIMESTAMP columns has an explicit DEFAULT clause.
Flush EnabledWhether to flush (synchronize) all changes to disk after each SQL statement.
Flush TimeHow often (in seconds) to close all tables, to free up resources and synchronize unflushed data to disk, for low resource systems.
Lock Wait TimeoutThis 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 Enableddescribes 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 NamesWhether table names are stored in lowercase or uppercase on disk, and whether comparisons are case sensitive or not.
Low Priority Updates EnabledWhen 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 SizeThe maximum size to which user-created MEMORY tables are permitted to grow.
Max Tmp TablesThe maximum number of temporary tables a client can keep open at the same time. (This variable does not yet do anything.).
Metadata Locks Cache SizeThe size of the metadata locks cache. The server uses this cache to avoid creation and destruction of synchronization objects.
Metadata Locks Hash InstancesThe 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 EnabledWhether 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 LimitChanges the number of file descriptors available to mysqld.
Sync Frm EnabledIf this variable is set to 1, when any nontemporary table is created its .frm file is synchronized to disk (using fdatasync()).
Table Definition CacheThe number of table definitions that can be stored in the definition cache.
Table Open CacheThe number of concurrently open tables for all threads allowed.
Table Open Cache InstancesThe 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 SizeThe 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 EnabledIf this variable is set to 1, when any nontemporary table is created its .frm file is synchronized to disk (using fdatasync()).