Search Results
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/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.
https://dev.mysql.com/doc/refman/8.4/en/optimizing-server.html
This section discusses optimization techniques for the database server, primarily dealing with system configuration rather than tuning SQL statements. The information in this section is appropriate for DBAs who want to ensure performance and ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-spatial-analysis.html
For MyISAM and InnoDB tables, search operations in columns containing spatial data can be optimized using SPATIAL indexes. The most typical operations are: Point queries that search for all objects that contain a given point Region queries that ...
https://dev.mysql.com/doc/refman/8.4/en/primary-key-optimization.html
Query performance benefits from the NOT NULL optimization, because it cannot include any NULL values. The primary key for a table represents the column or set of columns that you use in your most vital queries. With the InnoDB storage engine, the ...