PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/partitioning-hash.html
This can simply be the name of a column whose type is one of MySQL's integer types. In addition, you most likely want to follow this with PARTITIONS num, where num is a positive integer representing the number of partitions into which the table is ... Partitioning by HASH is used primarily to ensure an even distribution of data among a predetermined number of ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-digests.html
This section describes how statement digesting occurs and how it can be useful. In this case, the difference in the second column name is lost and both statements are considered the same. This is a copy of the original normalized statement that was ... The MySQL server is capable of maintaining statement digest ...
https://dev.mysql.com/doc/refman/5.7/en/repair-table.html
Although normally you should never have to run REPAIR TABLE, if disaster strikes, this statement is very likely to get back all your data from a MyISAM table. This is an unlikely but possible scenario that underscores the value of making a backup ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-howto.html
This section describes a process for configuring and starting GTID-based replication in MySQL 5.7. This is a “cold start” procedure that assumes either that you are starting the replication source server for the first time, or that it is ...For ...
https://dev.mysql.com/doc/refman/5.7/en/replication-howto-additionalslaves.html
To do this, you can set up the new replica by copying the data directory of an existing replica, and giving the new replica a different server ID (which is user-specified) and server UUID (which is generated at startup). You can do this by creating ... You can add another replica to an existing replication configuration without stopping the source ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer-workflow.html
If you select this option, you are responsible for securing the Data folder and its related files manually after the server configuration finishes. This does not apply to files and directories for specific products, such as the MySQL server data ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-storage-engine.html
This can also be changed by changing the source and recompiling. This is done by automatically combining adjacent deleted blocks and by extending blocks if the next block is deleted. myisamchk --fast checks only those tables that don't have this ...
https://dev.mysql.com/doc/refman/5.7/en/optimizer-hints.html
This occurs due to heuristic pruning during greedy search, which can be avoided by setting optimizer_prune_level=0. Changes to this variable affect execution of all subsequent queries; to affect one query differently from another, it is necessary to ... One means of control over optimizer strategies is to set the optimizer_switch system variable (see Section 8.9.2, “Switchable ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-tables.html
This is similar to the information available from the SHOW SLAVE STATUS statement, but representation in table form is more accessible and has usability benefits: SHOW SLAVE STATUS output is useful for visual inspection, but not so much for ...Query ...
https://dev.mysql.com/doc/refman/5.7/en/sorted-index-builds.html
The drawbacks of this “top-down” method of building an index are the cost of searching for an insert position and the constant splitting and merging of B-tree nodes. This method of index creation is also known as a sorted index build. This ...