Search Results
https://dev.mysql.com/doc/internals/en/providing-index-information-to-optimizer.html
In order for indexing to be used effectively, storage engines need to provide the optimizer with information about the table and its indexes. This information is used to choose whether to use an index, and if so, which index to use.
https://dev.mysql.com/doc/refman/8.4/en/group-by-optimization.html
If the WHERE clause contains range predicates (see the discussion of the range join type in Section 10.8.1, “Optimizing Queries with EXPLAIN”), a Loose Index Scan looks up the first key of each group that satisfies the range conditions, and ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-optimize-tablespace-page-allocation.html
You can optimize how InnoDB allocates space to file-per-table and general tablespaces on Linux. By default, when additional space is required, InnoDB allocates pages to the tablespace and physically writes NULLs to those pages. This behavior can ...
https://dev.mysql.com/doc/refman/8.4/en/insert-optimization.html
To optimize insert speed, combine many small operations into a single large operation. Ideally, you make a single connection, send the data for many new rows at once, and delay all index updates and consistency checking until the very end. The size ...
https://dev.mysql.com/doc/refman/8.4/en/miscellaneous-optimization-tips.html
To fix any compression issues that occur with ARCHIVE tables, use OPTIMIZE TABLE. This section lists a number of miscellaneous tips for improving query processing speed: If your application makes several database requests to perform related ...
https://dev.mysql.com/doc/refman/8.4/en/optimization-indexes.html
You must find the right balance to achieve fast queries using the optimal set of indexes. The best way to improve the performance of SELECT operations is to create indexes on one or more of the columns that are tested in the query. The index ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-blob.html
See Section 10.4.2.2, “Optimizing for Character and String Types” for reasons why a binary VARCHAR column is sometimes preferable to an equivalent BLOB column. When storing a large blob containing textual data, consider compressing it first. Do ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-character.html
See Section 10.4.2.1, “Optimizing for Numeric Data” for reasons why a numeric column is usually preferable to an equivalent string column. For character and string columns, follow these guidelines: Use binary collation order for fast comparison ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-tracing.html
The MySQL optimizer includes the capability to perform tracing; the interface is provided by a set of optimizer_trace_xxx system variables and the INFORMATION_SCHEMA.OPTIMIZER_TRACE table.
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb.html
This section explains how to optimize database operations for InnoDB tables. InnoDB is the storage engine that MySQL customers typically use in production databases where reliability and concurrency are important.