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-background.html
An InnoDB table created with ROW_FORMAT=COMPRESSED can use a smaller page size on disk than the configured innodb_page_size value. Because processors and cache memories have increased in speed more than disk storage devices, many workloads are ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-downgrading.html
Each InnoDB tablespace file (with a name matching *.ibd) is tagged with the file format used to create its table and indexes. The way to modify the file format is to re-create the table and its indexes. For information about downgrading to a ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-indexes.html
This section covers topics related to InnoDB indexes. ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-examples-compression-sect.html
Example 14.1 Using the Compression Information Schema Tables The following is sample output from a database that contains compressed tables (see Section 14.9, “InnoDB Table and Page Compression”, INNODB_CMP, INNODB_CMP_PER_INDEX, and ...The ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locking-reads.html
InnoDB supports two types of locking reads that offer extra safety: SELECT ... If you query data and then insert or update related data within the same transaction, the regular SELECT statement does not give enough protection. Other transactions ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-compression-oltp.html
Traditionally, the InnoDB compression feature was recommended primarily for read-only or read-mostly workloads, such as in a data warehouse configuration. Configuration options introduced in MySQL 5.6 let you adjust the way compression works for a ...The rise of SSD storage devices, which are fast but relatively small and expensive, makes compression attractive also for OLTP workloads: high-traffic, interactive websites can reduce their storage requirements and their I/O operations per second (IOPS) by using compressed tables with applications that do frequent INSERT, UPDATE, and DELETE ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-redo-log-buffer.html
The innodb_flush_log_at_trx_commit variable controls how the contents of the log buffer are written and flushed to disk. For related information, see Memory Configuration, and Section 8.5.4, “Optimizing InnoDB Redo Logging”. The log buffer is ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-tables.html
This section covers topics related to InnoDB tables. ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-tablespace.html
This section covers topics related to InnoDB tablespaces. ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-undo-tablespaces.html
The number of undo tablespaces used by InnoDB is controlled by the innodb_undo_tablespaces option. Note The innodb_undo_tablespaces option is deprecated; expect it to be removed in a future release. To configure undo tablespaces: Specify a directory ... Undo tablespaces contain undo logs, which are collections of records containing information about how to undo the latest change by a transaction to a clustered index ...