PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.3Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tables-table.html
The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. If there are no cached statistics or statistics have expired, statistics are retrieved from storage engines when querying table ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-triggers-table.html
This is a TIMESTAMP(2) value (with a fractional part in hundredths of seconds) for triggers. To see information about a table's triggers, you must have the TRIGGER privilege for the table. The TRIGGERS table has these columns: TRIGGER_CATALOG The ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-autocommit-commit-rollback.html
If autocommit mode is enabled, each SQL statement forms a single transaction on its own. By default, MySQL starts the session for each new connection with autocommit enabled, so MySQL does a commit after each SQL statement if that statement did not ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-best-practices.html
Committing hundreds of times a second puts a cap on performance (limited by the write speed of your storage device). Specify a primary key for every table using the most frequently queried column or columns, or an auto-increment value if there is no ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-file-per-table-tablespaces.html
The buffer pool is scanned when dropping a table that resides in a file-per-table tablespace, which can take several seconds for large buffer pools. A file-per-table tablespace contains data and indexes for a single InnoDB table, and is stored on ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-fulltext_index-tables.html
This table contains metadata about the FULLTEXT index and related processing: optimize_checkpoint_limit: The number of seconds after which an OPTIMIZE TABLE run stops. INNODB_FT_BEING_DELETED: Provides a snapshot of the INNODB_FT_DELETED table; it ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-metrics-table.html
The TIME_ENABLED and TIME_ELAPSED values indicate when the counter was last enabled and how many seconds have elapsed since that time. The INNODB_METRICS table provides information about InnoDB performance and resource-related counters. SET GLOBAL ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-system-tables.html
The index TYPE value indicates the type of index (1 = Clustered Index, 0 = Secondary index). The CLUST_INDEX_SIZE and OTHER_INDEX_SIZE fields report the number of pages on disk that store clustered and secondary indexes for the table, respectively.
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-understanding-innodb-locking.html
If a second transaction wants to update a row or lock a table already locked by a prior transaction in an incompatible mode, InnoDB adds a lock request for the row to the corresponding queue. Note This section describes locking information as ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-porting-mysql.html
The second record is the entry you inserted for the multicol table. Consider these aspects of memcached applications when adapting an existing MySQL schema or application to use the daemon_memcached plugin: memcached keys cannot contain spaces or ...