Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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 ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-performance-schema.html
This type of tuning is primarily for expert users who evaluate optimization strategies to overcome performance bottlenecks. This section provides a brief introduction to InnoDB integration with Performance Schema. For comprehensive Performance ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-read-only-instance.html
See Section 10.5.3, “Optimizing InnoDB Read-Only Transactions” for ways to tune the performance of read-only queries, which do not require making the entire server read-only. You can query InnoDB tables where the MySQL data directory is on ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-redo-log-buffer.html
For related information, see Memory Configuration, and Section 10.5.4, “Optimizing InnoDB Redo Logging”. The log buffer is the memory area that holds data to be written to the log files on disk. The contents of the log buffer are periodically ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-redo-log.html
mysql> SHOW GLOBAL STATUS LIKE 'Innodb_redo_log_enabled'; +-------------------------+-------+ | Variable_name | Value | +-------------------------+-------+ | Innodb_redo_log_enabled | ON | +-------------------------+-------+ Related Topics Redo Log ... The redo log is a disk-based data structure used during crash recovery to correct data written by incomplete ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-restrictions-limitations.html
The row count is only a rough estimate used in SQL optimization. This section describes restrictions and limitations of the InnoDB storage engine. You cannot create a table with a column name that matches the name of an internal InnoDB column ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-row-format.html
The row format of a table determines how its rows are physically stored, which in turn can affect the performance of queries and DML operations. As more rows fit into a single disk page, queries and index lookups can work faster, less cache memory ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-table-import.html
After importing a table with a FULLTEXT index, run OPTIMIZE TABLE to rebuild the FULLTEXT indexes. This section describes how to import tables using the Transportable Tablespaces feature, which permits importing tables, partitioned tables, or ...