https://dev.mysql.com/optimizing-innodb-storage-layout.html
The primary key value for a row is duplicated in all the secondary index records that point to the same row. Once your data reaches a stable size, or a growing table has increased by tens or some hundreds of megabytes, consider using the OPTIMIZE ...
https://dev.mysql.com/order-by-optimization.html
Change the tmpdir system variable to point to a dedicated file system with large amounts of free space. This section describes when MySQL can use an index to satisfy an ORDER BY clause, the filesort operation used when an index cannot be used, and ...
https://dev.mysql.com/partitioning-columns-range.html
Range columns partitioning is similar to range partitioning, but enables you to define partitions using ranges based on multiple column values. In addition, you can define the ranges using columns of types other than integer types. RANGE COLUMNS ...
https://dev.mysql.com/partitioning-limitations.html
Columns with spatial data types such as POINT or GEOMETRY cannot be used in partitioned tables. This section discusses current restrictions and limitations on MySQL partitioning support. The following constructs are not permitted in partitioning ...
https://dev.mysql.com/partitioning-management-range-list.html
Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the management of both sorts of partitioning in this section. For information about working with tables that are partitioned by hash or key, see ...
https://dev.mysql.com/partitioning-range.html
At some point in the future—when the number of stores has increased to 25, 30, or more—you can use an ALTER TABLE statement to add new partitions for stores 21-25, 26-30, and so on (see Section 23.3, “Partition Management”, for details of ...
https://dev.mysql.com/password-management.html
MySQL supports these password-management capabilities: Password expiration, to require passwords to be changed periodically. Password reuse restrictions, to prevent old passwords from being chosen again. Password verification, to require that ...
https://dev.mysql.com/performance-schema-atom-molecule-events.html
At this point, and until the next subsidiary event begins, the table I/O wait is also the most recent wait of any kind. For a table I/O event, there are usually two rows in events_waits_current, not one. For example, a row fetch might result in ...
https://dev.mysql.com/plugin-loading.html
However, removing options for a plugin from the my.cnf file may not be sufficient to uninstall it if at some point INSTALL PLUGIN has also been used. Server plugins must be loaded into the server before they can be used. It is also possible to ...
https://dev.mysql.com/prepared-statements-instances-table.html
For a prepared statement created by a stored program, these columns point to the stored program. The Performance Schema provides instrumentation for prepared statements, for which there are two protocols: The binary protocol. This is accessed ...
