PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/controlling-query-plan-evaluation.html
If you are unsure of what a reasonable value is for optimizer_search_depth, this variable can be set to 0 to tell the optimizer to determine the value automatically. Because the difference in performance between “good” and “bad” plans can be ... The task of the query optimizer is to find an optimal plan for executing an SQL ...
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/group-replication-restarting-group.html
You can do this manually by looking at the GTIDs, or you can compare the GTID sets using stored functions, as described in Section 16.1.3.7, “Stored Function Examples to Manipulate GTIDs”. For Group Replication, this includes both transactions ... Group Replication is designed to ensure that the database service is continuously available, even if some of the servers that form the group are currently unable to participate in it due to planned maintenance or unplanned ...
https://dev.mysql.com/doc/refman/5.7/en/security-against-attack.html
For example: [mysqld] user=mysql This causes the server to start as the designated user whether you start it manually or by using mysqld_safe or mysql.server. If the connection between the client and the server goes through an untrusted network, and ... When you connect to a MySQL server, you should use a ...