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/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 ...
https://dev.mysql.com/doc/refman/5.7/en/using-encrypted-connections.html
This section provides general guidance about configuring the server and clients for encrypted connections: Server-Side Startup Configuration for Encrypted Connections Client-Side Configuration for Encrypted Connections Configuring Encrypted ...
https://dev.mysql.com/doc/refman/5.7/en/handler-scope.html
When a condition occurs in a stored program, the server searches for applicable handlers in the current scope (current BEGIN ... If there are no applicable handlers, the search continues outward with the handlers in each successive containing scope ... A stored program may include handlers to be invoked when certain conditions occur within the ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-table.html
To keep the index maintenance period to a reasonable time, set the innodb_ft_num_word_optimize option to specify how many words to update in the search index, and run a sequence of OPTIMIZE TABLE statements until the search index is fully updated.
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 ...
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 ...