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-compression-tuning.html
Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed data. However, because the efficiency of compression depends on the nature of your data, you can make decisions ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-usage.html
Table attributes such as ROW_FORMAT and KEY_BLOCK_SIZE are not part of the CREATE INDEX syntax for InnoDB tables, and are ignored if they are specified (although, if specified, they appear in the output of the SHOW CREATE TABLE statement).
https://dev.mysql.com/doc/refman/5.7/en/innodb-data-encryption.html
To verify that a keyring plugin is active, use the SHOW PLUGINS statement or query the Information Schema PLUGINS table. About Data-at-Rest Encryption Encryption Prerequisites Enabling File-Per-Table Tablespace Encryption Master Key Rotation ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlocks-handling.html
You can cope with deadlocks and reduce the likelihood of their occurrence with the following techniques: At any time, issue SHOW ENGINE INNODB STATUS to determine the cause of the most recent deadlock. This section builds on the conceptual ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlocks.html
To view the last deadlock in an InnoDB user transaction, use SHOW ENGINE INNODB STATUS. A deadlock is a situation in which multiple transactions are unable to proceed because each transaction holds a lock that is needed by another one. Because all ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-compatibility.html
The easiest way to determine the file format of an existing InnoDB tablespace is to examine the properties of the table it contains, using the SHOW TABLE STATUS command or querying the table INFORMATION_SCHEMA.TABLES. InnoDB incorporates several ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-space.html
When you ask for available free space in the tablespace by issuing a SHOW TABLE STATUS statement, InnoDB reports the extents that are definitely free in the tablespace. The data files that you define in the configuration file using the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-fulltext-index.html
As shown in the preceding example, the “147” hex value appears in the names of auxiliary index tables that are associated with the test/opening_lines table. The other index tables shown in the preceding example are referred to as common index ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-temp-table-info.html
mysql> SHOW TABLES FROM INFORMATION_SCHEMA LIKE 'INNODB_TEMP%'; +---------------------------------------------+ | Tables_in_INFORMATION_SCHEMA (INNODB_TEMP%) | +---------------------------------------------+ | INNODB_TEMP_TABLE_INFO | ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-understanding-innodb-locking.html
The INNODB_LOCK_WAITS table shows which locks already held by a transaction are blocking locks requested by other transactions. When a transaction updates a row in a table, or locks it with SELECT FOR UPDATE, InnoDB establishes a list or queue of ...