PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-usage.html
To determine the best value for KEY_BLOCK_SIZE, typically you create several copies of the same table with different values for this clause, then measure the size of the resulting .ibd files and see how well each performs with a realistic workload.
https://dev.mysql.com/doc/refman/5.7/en/innodb-doublewrite-buffer.html
This feature is only supported on Fusion-io hardware and is only enabled for Fusion-io NVMFS on Linux. To take full advantage of this feature, an innodb_flush_method setting of O_DIRECT is recommended. The doublewrite buffer is a storage area where ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-compatibility-checking-table-access.html
This check prevents crashes or corruptions that would otherwise occur when tables using a “too new” data structure are encountered. If you permit InnoDB to open a database containing files in a format it does not support (by setting the ... When ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-transactions.html
INNODB_LOCK_WAITS: This table indicates which transactions are waiting for a given lock, or for which lock a given transaction is waiting. This table contains one or more rows for each blocked transaction, indicating the lock it has requested and ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-linux-native-aio.html
This behavior is controlled by the innodb_use_native_aio configuration option, which applies to Linux systems only and is enabled by default. This option may also be disabled automatically during startup if InnoDB detects a potential problem such as ... InnoDB uses the asynchronous I/O subsystem (native AIO) on Linux to perform read-ahead and write requests for data file ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-compression-oltp.html
This option is enabled by default to prevent corruption that could occur if a different version of the zlib compression algorithm is used during recovery. Traditionally, the InnoDB compression feature was recommended primarily for read-only or ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-use_sys_malloc.html
This allocator is guarded by a single mutex, which may become a bottleneck. This parameter is not dynamic, and takes effect only when the system is started. When InnoDB was developed, the memory allocators supplied with operating systems and ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-service.html
This section describes how to use the keyring service functions to store, retrieve, and remove keys in the MySQL keyring keystore. If there is no user context, this value can be NULL. MySQL Server supports a keyring service that enables internal ...
https://dev.mysql.com/doc/refman/5.7/en/keyring.html
This service is accessible at two levels: SQL interface: In SQL statements, call the functions described in Section 6.4.4.8, “General-Purpose Keyring Key-Management Functions”. For information about accessing this service and writing keyring ...
https://dev.mysql.com/doc/refman/5.7/en/local-variable-scope.html
MySQL interprets this as a reference to the variable of that name rather than a column reference. The scope of a local variable is the BEGIN ... The variable can be referred to in blocks nested within the declaring block, except those blocks that ...