Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-trx-table.html
When this column and TRX_IS_READ_ONLY are both 1, InnoDB optimizes the transaction to reduce the overhead associated with transactions that change table data. The INNODB_TRX table provides information about every transaction currently executing ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-statistics-table.html
The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. If there are no cached statistics or statistics have expired, statistics are retrieved from storage engines when querying table ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-tables-table.html
For InnoDB tables, the row count is only a rough estimate used in SQL optimization. The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. If there are no cached statistics or statistics ...
https://dev.mysql.com/doc/refman/8.4/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. Choosing the Compressed Page Size The optimal setting of the compressed page size depends on the type and ...However, because the efficiency of compression depends on the nature of your data, you can make decisions that affect the performance of compressed tables: Which tables to ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-configuration.html
For information about optimizing database operations for InnoDB tables, see Section 10.5, “Optimizing for InnoDB Tables”. This section provides configuration information and procedures for InnoDB initialization, startup, and various components ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-disk-management.html
Within these constraints, InnoDB tries to optimize the database work and the organization of disk files to minimize the amount of disk I/O. As a DBA, you must manage disk I/O to keep the I/O subsystem from becoming saturated, and manage disk space ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-fulltext-index.html
To remove full-text index entries for deleted records, run OPTIMIZE TABLE on the indexed table with innodb_optimize_fulltext_only=ON to rebuild the full-text index. Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-index-types.html
To get the best performance from queries, inserts, and other database operations, it is important to understand how InnoDB uses the clustered index to optimize the common lookup and DML operations. For guidelines to take advantage of InnoDB ... Each ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-init-startup-configuration.html
The first decisions to make about InnoDB configuration involve the configuration of data files, log files, page size, and memory buffers, which should be configured before initializing InnoDB. Modifying the configuration after InnoDB is initialized ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-limitations.html
OPTIMIZE TABLE for an InnoDB table is mapped to an ALTER TABLE operation to rebuild the table and update index statistics and free unused space in the clustered index. OPTIMIZE TABLE is supported with the addition of online DDL support for ... The ...