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/monitor-alter-table-performance-schema.html
You can monitor ALTER TABLE progress for InnoDB tables using Performance Schema. In order of occurrence, ALTER TABLE stage events include: stage/innodb/alter table (read PK and internal sort): This stage is active when ALTER TABLE is in the ...
https://dev.mysql.com/doc/refman/5.7/en/innochecksum.html
This tool reads an InnoDB tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored checksum, and reports mismatches, which indicate damaged pages. Because checksum mismatches cause InnoDB to deliberately ...It was originally developed to speed up verifying the integrity of tablespace files after power outages but can also be used after file ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-change-buffer.html
Change buffer merging may also continue to occur after a transaction is committed, and even after a server shutdown and restart (see Section 14.22.2, “Forcing InnoDB Recovery” for more information). The type of data cached in the change buffer ... The change buffer is a special data structure that caches changes to secondary index pages when those pages are not in the buffer ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-persistent-stats.html
Optimizer statistics are persisted to disk when innodb_stats_persistent=ON or when individual tables are defined with STATS_PERSISTENT=1. Because of the asynchronous nature of automatic statistics recalculation, which occurs in the background, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-syntax-warnings.html
SQL Compression Syntax Warnings and Errors for File-Per-Table Tablespaces When innodb_strict_mode is enabled (the default), specifying ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE in CREATE TABLE or ALTER TABLE statements produces the following error if ... This section describes syntax warnings and errors that you may encounter when using the table compression feature with file-per-table tablespaces and general ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-system-tablespace.html
The system tablespace is the storage area for the InnoDB data dictionary, the doublewrite buffer, the change buffer, and undo logs. The size and number of system tablespace data files is defined by the innodb_data_file_path startup option. To do ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-compatibility-checking-table-access.html
When a table is first accessed, InnoDB (including some releases prior to InnoDB 1.0) checks that the file format of the tablespace in which the table is stored is fully supported. The setting of the system configuration parameter innodb_file_format ...This check prevents crashes or corruptions that would otherwise occur when tables using a “too new” data structure are ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-linux-native-aio.html
InnoDB uses the asynchronous I/O subsystem (native AIO) on Linux to perform read-ahead and write requests for data file pages. This behavior is controlled by the innodb_use_native_aio configuration option, which applies to Linux systems only and is ...Using the asynchronous I/O subsystem on Linux requires the libaio ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-undo-logs.html
InnoDB supports a maximum of 128 rollback segments, 32 of which are allocated to the temporary tablespace. The innodb_rollback_segments variable defines the number of rollback segments used by InnoDB. The number of undo slots in a rollback segment ... An undo log is a collection of undo log records associated with a single read-write ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-compared.html
Since both NDB and InnoDB can serve as transactional MySQL storage engines, users of MySQL Server sometimes become interested in NDB Cluster. They see NDB as a possible alternative or upgrade to the default InnoDB storage engine in MySQL 5.7. While ... MySQL Server offers a number of choices in storage ...