PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-read_ahead.html
A read-ahead request is an I/O request to prefetch multiple pages in the buffer pool asynchronously, in anticipation that these pages are needed soon. InnoDB uses two read-ahead algorithms to improve I/O performance: Linear read-ahead is a ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-redo-log-buffer.html
The log buffer is the memory area that holds data to be written to the log files on disk. The contents of the log buffer are periodically flushed to disk. A large log buffer enables large transactions to run without the need to write redo log data ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-transaction-model.html
The InnoDB transaction model aims combine the best properties of a multi-versioning database with traditional two-phase locking. InnoDB performs locking at the row level and runs queries as nonlocking consistent reads by default, in the style of ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html
The following general guidelines apply to troubleshooting InnoDB problems: When an operation fails or you suspect a bug, look at the MySQL server error log (see Section 5.4.2, “The Error Log”). Server Error Message Reference provides ...
https://dev.mysql.com/doc/refman/5.7/en/insert-delayed.html
The DELAYED option for the INSERT statement is a MySQL extension to standard SQL. The server recognizes but ignores the DELAYED keyword, handles the insert as a nondelayed insert, and generates an ER_WARN_LEGACY_SYNTAX_CONVERTED warning: INSERT ...
https://dev.mysql.com/doc/refman/5.7/en/integer-types.html
MySQL supports the SQL standard integer types INTEGER (or INT) and SMALLINT. As an extension to the standard, MySQL also supports the integer types TINYINT, MEDIUMINT, and BIGINT. The following table shows the required storage and range for each ...
https://dev.mysql.com/doc/refman/5.7/en/is-null-optimization.html
MySQL can perform the same optimization on col_name IS NULL that it can use for col_name = constant_value. For example, MySQL can use indexes and ranges to search for NULL with IS NULL. This optimization does not occur in cases when the column ...
https://dev.mysql.com/doc/refman/5.7/en/key-cache-restructuring.html
A key cache can be restructured at any time by updating its parameter values. For example: mysql> SET GLOBAL cold_cache.key_buffer_size=4*1024*1024; If you assign to either the key_buffer_size or key_cache_block_size key cache component a value ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-functions-plugin-specific.html
For each keyring plugin-specific function, this section describes its purpose, calling sequence, and return value. For information about general-purpose keyring functions, see Section 6.4.4.8, “General-Purpose Keyring Key-Management Functions”.
https://dev.mysql.com/doc/refman/5.7/en/keyring-options.html
MySQL supports the following keyring-related command-line options: --keyring-migration-destination=plugin Command-Line Format --keyring-migration-destination=plugin_name Introduced 5.7.21 Type String The destination keyring plugin for key migration. The format and interpretation of the option value is the same as described for the --keyring-migration-source ...