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-monitors.html
InnoDB monitors provide information about the InnoDB internal state. This information is useful for performance tuning. ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-table-compression.html
This section describes InnoDB table compression, which is supported with InnoDB tables that reside in file_per_table tablespaces or general tablespaces. Table compression is enabled using the ROW_FORMAT=COMPRESSED attribute with CREATE TABLE or ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndb-innodb-usage.html
When comparing application feature requirements to the capabilities of InnoDB with NDB, some are clearly more compatible with one storage engine than the other. The following table lists supported application features according to the storage ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-ddl-operations.html
Many DDL operations on tables and indexes (CREATE, ALTER, and DROP statements) can be performed online. Online DDL support for adding secondary indexes means that you can generally speed up the process of creating and loading a table and associated ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-storage-layout.html
In InnoDB, having a long PRIMARY KEY (either a single column with a lengthy value, or several columns that form a long composite value) wastes a lot of disk space. When using COMPACT row format (the default InnoDB format) and variable-length ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-in-memory-structures.html
This section describes InnoDB in-memory structures and related topics. ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-compression-tables.html
There are two pairs of InnoDB INFORMATION_SCHEMA tables about compression that can provide insight into how well compression is working overall: INNODB_CMP and INNODB_CMP_RESET provide information about the number of compression operations and the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-on-disk-structures.html
This section describes InnoDB on-disk structures and related topics. ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-buffer-pool.html
This section provides configuration and tuning information for the InnoDB buffer pool.
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-optimizer-statistics.html
This section describes how to configure persistent and non-persistent optimizer statistics for InnoDB tables. Persistent optimizer statistics also provide control and flexibility with these additional benefits: You can use the ...Persistent ...