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/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/account-upgrades.html
For information about this plugin, see Section 6.4.1.5, “SHA-256 Pluggable Authentication”. The following table lists the types of mysql.user accounts considered in this discussion. This operation requires no password changes, so it can be ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-config-example.html
The NDB Cluster global configuration file is by convention named config.ini (but this is not required). This option has no default value, and is ignored if ndb_mgmd uses the configuration cache. This is also true for default sections of any other ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-starting.html
This section outlines the procedure for starting NDB Cluster replication using a single replication channel. Start the MySQL replication source server by issuing this command, where id is this server's unique ID (see Section 21.7.2, “General ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-diskio.html
This memory area is important enough that it is typically recommended that innodb_buffer_pool_size is configured to 50 to 75 percent of system memory. This behavior is controlled by the innodb_use_native_aio configuration option, which is enabled by ... If you follow best practices for database design and tuning techniques for SQL operations, but your database is still slow due to heavy disk I/O activity, consider these disk I/O ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-queries-myisam.html
This updates a value for each index part that indicates the average number of rows that have the same value. (For unique indexes, this is always 1.) MySQL uses this to decide which index to choose when you join two tables based on a nonconstant ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-types.html
This section discusses the types of partitioning which are available in MySQL 5.7. This type of partitioning assigns rows to partitions based on column values falling within a given range. For information about an extension to this type, RANGE ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-usage.html
The application caches this information to provide a central access point to it. In this case, the new server assignment may now be incompatible with the client requirements. This is an indication to the client to refresh its version token ...
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/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 ...