PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
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/innodb-table-import.html
This section describes how to import tables using the Transportable Tablespaces feature, which permits importing tables, partitioned tables, or individual table partitions that reside in file-per-table tablespaces. The Transportable Tablespaces ...
https://dev.mysql.com/doc/refman/5.7/en/semijoins.html
This occurs due to heuristic pruning during greedy search, which can be avoided by setting optimizer_prune_level=0. The optimizer uses semijoin strategies to improve subquery execution, as described in this section. To list the classes that actually ... A semijoin is a preparation-time transformation that enables multiple execution strategies such as table pullout, duplicate weedout, first match, loose scan, and ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer-catalog-dashboard.html
If you are using a Commercial release of MySQL Installer, the icon opens the MySQL Installer Commercial License Information User Manual for licensing information, including licensing information relating to third-party software that may be included ... This section describes the MySQL Installer product catalog, the dashboard, and other actions related to product selection and ...Product Catalog MySQL Installer Dashboard Locating Products to Install Upgrading MySQL Server Removing MySQL Server Upgrading MySQL Installer Product Catalog The product ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-frequently-asked-questions.html
This limit has been identified from testing and benchmarking as a safe boundary where the group performs reliably on a stable local area network. Furthermore, given that changes are propagated and applied in row-based format, this means that they ...
https://dev.mysql.com/doc/refman/5.7/en/index-hints.html
They also work with multi-table DELETE statements, but not with single-table DELETE, as shown later in this section. (For the general syntax for specifying tables in a SELECT statement, see Section 13.2.9.2, “JOIN Clause”.) The syntax for ...