Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-transactions.html
For more information about the preceding tables, see Section 28.4.28, “The INFORMATION_SCHEMA INNODB_TRX Table”, Section 29.12.13.1, “The data_locks Table”, and Section 29.12.13.2, “The data_lock_waits Table”. Each transaction in InnoDB ...That blocking lock request is for a row or table lock held by another transaction in an incompatible ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb.html
InnoDB is the storage engine that MySQL customers typically use in production databases where reliability and concurrency are important. This section explains how to optimize database operations for InnoDB tables.
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/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/8.4/en/innodb-in-memory-structures.html
This section describes InnoDB in-memory structures and related topics. ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/en/innodb-on-disk-structures.html
This section describes InnoDB on-disk structures and related topics. ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-buffer-pool.html
This section provides configuration and tuning information for the InnoDB buffer pool.
https://dev.mysql.com/doc/internals/en/innodb.html
...