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/information-schema-plugins-table.html
This is the name used to refer to the plugin file in statements such as INSTALL PLUGIN and UNINSTALL PLUGIN. This file is located in the directory named by the plugin_dir system variable. The PLUGINS table has these columns: PLUGIN_NAME The name ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-schemata-table.html
A schema is a database, so the SCHEMATA table provides information about databases. The SCHEMATA table has these columns: CATALOG_NAME The name of the catalog to which the schema belongs. The following statements are equivalent: SELECT SCHEMA_NAME ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-checkpoints.html
(Strictly speaking, this performance improvement is available for MySQL 5.1 with the InnoDB Plugin 1.0.7 and higher. It is with MySQL 5.5 that this improvement is available in the default InnoDB storage engine.) How Checkpoint Processing Works ...
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 ...