PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-background.html
You might need to size your buffer pool to accommodate the additional data of both compressed and uncompressed pages, although the uncompressed pages are evicted from the buffer pool when space is needed, and then uncompressed again on the next ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-tuning.html
Database Compression versus Application Compression Decide whether to compress data in your application or in the table; do not use both types of compression for the same data. Most often, the internal optimizations described in InnoDB Data Storage ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-usage.html
After the innodb_file_per_table option is configured, specify the ROW_FORMAT=COMPRESSED clause or KEY_BLOCK_SIZE clause, or both, in a CREATE TABLE or ALTER TABLE statement to create a compressed table in a file-per-table tablespace. Compressed ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression.html
This section provides information about the InnoDB table compression and InnoDB page compression features. The page compression feature is also referred to as transparent page compression. Using the compression features of InnoDB, you can create ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-disk-management.html
Organizing tables into many small files, a few larger files, or a combination of both. As a DBA, you must manage disk I/O to keep the I/O subsystem from becoming saturated, and manage disk space to avoid filling up storage devices. The ACID design ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-doublewrite-buffer.html
As a result, doublewrite files can contain different page types including unencrypted and uncompressed pages, encrypted pages, compressed pages, and pages that are both encrypted and compressed. The doublewrite buffer is a storage area where InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-error-handling.html
Both deadlocks and lock wait timeouts are normal on busy servers and it is necessary for applications to be aware that they may happen and handle them by retrying. InnoDB sometimes rolls back only the statement that failed, other times it rolls back ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-file-defragmenting.html
Both ALTER TABLE tbl_name ENGINE=INNODB and ALTER TABLE tbl_name FORCE use online DDL. Random insertions into or deletions from a secondary index can cause the index to become fragmented. Fragmentation means that the physical ordering of the index ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-examples.html
As you can see: Session B (trx id A4, thread 6) and Session C (trx id A5, thread 7) are both waiting for Session A (trx id A3, thread 5). Note This section describes locking information as exposed by the Performance Schema data_locks and ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-init-startup-configuration.html
When the innodb_redo_log_capacity setting is defined, the innodb_log_file_size and innodb_log_files_in_group settings are ignored; otherwise, if one or both of these deprecated settings are defined then they are used to compute ... The first ...