Search Results
https://dev.mysql.com/doc/refman/8.4/en/optimize-numeric.html
For unique IDs or other values that can be represented as either strings or numbers, prefer numeric columns to string columns. Since large numeric values can be stored in fewer bytes than the corresponding strings, it is faster and takes less ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-database-structure.html
In your role as a database designer, look for the most efficient way to organize your schemas, tables, and columns. As when tuning application code, you minimize I/O, keep related items together, and plan ahead so that performance stays high as the ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-ddl-operations.html
Many DDL operations on tables and indexes (CREATE, ALTER, and DROP statements) can be performed online. Online DDL support for adding secondary indexes means that you can generally speed up the process of creating and loading a table and associated ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-memory-tables.html
Consider using MEMORY tables for noncritical data that is accessed often, and is read-only or rarely updated. Benchmark your application against equivalent InnoDB or MyISAM tables under a realistic workload, to confirm that any additional ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-memory.html
...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-myisam.html
The MyISAM storage engine performs best with read-mostly data or with low-concurrency operations, because table locks limit the ability to perform simultaneous updates. In MySQL, InnoDB is the default storage engine rather than MyISAM.
https://dev.mysql.com/doc/refman/8.4/en/permission-optimization.html
The more complex your privilege setup, the more overhead applies to all SQL statements. Simplifying the privileges established by GRANT statements enables MySQL to reduce permission-checking overhead when clients execute statements. For example, if ...
https://dev.mysql.com/doc/refman/8.4/en/statement-optimization.html
The core logic of a database application is performed through SQL statements, whether issued directly through an interpreter or submitted behind the scenes through an API. The tuning guidelines in this section help to speed up all kinds of MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/bnl-bka-optimization.html
The block_nested_loop flag of the optimizer_switch system variable controls hash joins. The batched_key_access flag controls how the optimizer uses the Batched Key Access join algorithms. Optimizer hints may also be applied; see Optimizer Hints for ... In MySQL, a Batched Key Access (BKA) Join algorithm is available that uses both index access to the joined table and a join ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-parameters.html
For general I/O tuning advice, see Section 10.5.8, “Optimizing InnoDB Disk I/O”. For general I/O tuning advice, see Section 10.5.8, “Optimizing InnoDB Disk I/O”. innodb_change_buffering Command-Line Format --innodb-change-buffering=value ...