PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/optimize-table.html
OPTIMIZE TABLE does not sort R-tree indexes, such as spatial indexes on POINT columns. OPTIMIZE TABLE reorganizes the physical storage of table data and associated index data, to reduce storage space and improve I/O efficiency when accessing the ...
https://dev.mysql.com/doc/refman/9.7/en/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/doc/refman/9.7/en/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/doc/refman/9.7/en/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/doc/refman/9.7/en/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/doc/refman/9.7/en/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/doc/refman/9.7/en/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 26.3, “Partition Management”, for details of ...
https://dev.mysql.com/doc/refman/9.7/en/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/doc/refman/9.7/en/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/doc/refman/9.7/en/performance-schema-log-status-table.html
The log_status table informs the online backup which point it should copy up to in the source's binary log and gtid_executed record, and the relay log for each replication channel. It also provides relevant information for individual storage ... The ...