Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool-optimization.html
InnoDB maintains a storage area called the buffer pool for caching data and indexes in memory. Knowing how the InnoDB buffer pool works, and taking advantage of it to keep frequently accessed data in memory, is an important aspect of MySQL tuning.
https://dev.mysql.com/doc/refman/8.4/en/optimize-data-types.html
...
https://dev.mysql.com/doc/refman/8.4/en/optimize-multi-tables.html
Some techniques for keeping individual queries fast involve splitting data across many tables. When the number of tables runs into the thousands or even millions, the overhead of dealing with all these tables becomes a new performance consideration.
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/optimizer-trace-implementation.html
A trace is started by creating an instance of Opt_trace_start; information is added to this trace by creating instances of Opt_trace_object and Opt_trace_array, and by using the add() methods of these classes.
https://dev.mysql.com/doc/refman/8.4/en/optimizer-trace-testing.html
This feature is tested in mysql-test/suite/opt_trace and unittest/gunit/opt_trace-t. ...
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
...