Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool.html
For information about optimizing this behavior, see Section 17.8.3.3, “Making the Buffer Pool Scan Resistant”, and Section 17.8.3.4, “Configuring InnoDB Buffer Pool Prefetching (Read-Ahead)”. The buffer pool is an area in main memory where ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-change-buffer.html
Test different settings with a representative workload to determine an optimal configuration. The change buffer is a special data structure that caches changes to secondary index pages when those pages are not in the buffer pool. The buffered ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-create-table-external.html
Those reasons might include space management, I/O optimization, or placing tables on a storage device with particular performance or capacity characteristics, for example. There are different reasons for creating InnoDB tables externally; that is, ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-file-per-table-tablespaces.html
File-per-table tablespace data files can be created on separate storage devices for I/O optimization, space management, or backup purposes. A file-per-table tablespace contains data and indexes for a single InnoDB table, and is stored on the file ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-system-tables.html
The data in this table is used by the MySQL optimizer to calculate which index to use when querying an InnoDB table. You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA tables. Traditionally, you would ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-temp-table-info.html
It does not provide information about internal InnoDB temporary tables used by the optimizer. INNODB_TEMP_TABLE_INFO provides information about user-created InnoDB temporary tables that are active in the InnoDB instance. mysql> SHOW TABLES FROM ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-introduction.html
InnoDB tables arrange your data on disk to optimize queries based on primary keys. InnoDB is a general-purpose storage engine that balances high reliability and high performance. Unless you have configured a different default storage engine, ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking.html
Predicate Locks for Spatial Indexes InnoDB supports SPATIAL indexing of columns containing spatial data (see Section 13.4.9, “Optimizing Spatial Analysis”). Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-multi-versioning.html
However, if the index condition pushdown (ICP) optimization is enabled, and parts of the WHERE condition can be evaluated using only fields from the index, the MySQL server still pushes this part of the WHERE condition down to the storage engine ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-multiple_io_threads.html
For more information about InnoDB I/O performance, see Section 10.5.8, “Optimizing InnoDB Disk I/O”. InnoDB uses background threads to service various types of I/O requests. You can configure the number of background threads that service read ...