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/explain-output.html
For InnoDB tables that have a user-defined clustered index, that index can be used even when Using index is absent from the Extra column. For DEPENDENT SUBQUERY, the subquery is re-evaluated only once for each set of different values of the ... The ...It lists the tables in the output in the order that MySQL would read them while processing the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-commands.html
For example: mysql> prompt (\u@\h) [\d]>\_ PROMPT set to '(\u@\h) [\d]>\_' (user@host) [database]> (user@host) [database]> prompt Returning to default PROMPT of mysql> mysql> . For example: $> mysql --prompt="(\u@\h) [\d]> " (user@host) [database]> ...Resetting a connection has effects similar to mysql_change_user() or an auto-reconnect except that the connection is not closed and reopened, and re-authentication is not ...For server side help, type 'help contents' If mysql is invoked ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-overview.html
The user-selected rule by which the division of data is accomplished is known as a partitioning function, which in MySQL can be the modulus, simple matching against a set of ranges or value lists, an internal hashing function, or a linear hashing ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-privilege-distribution.html
Normally, each MySQL server's user privilege tables in the mysql database must use the MyISAM storage engine, which means that a user account and its associated privileges created on one SQL node are not available on the cluster's other SQL nodes. A ...This support is not enabled by default; you should follow the procedure outlined in this section in order to do ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-preparation.html
For additional options that can be set in my.cnf for replicas, see Section 16.1.6, “Replication and Binary Logging Options and Variables”. (See Section 16.2.1, “Replication Formats”.) In addition, we recommend enabling the ... Preparing the ...To provide replication backup capability, you also need to add an --ndb-connectstring option to the replica's my.cnf file prior to starting the replication ...
https://dev.mysql.com/doc/refman/5.7/en/create-view.html
For views defined with the SQL SECURITY INVOKER characteristic, CURRENT_USER returns the account for the view's invoker. For information about user auditing within views, see Section 6.2.18, “SQL-Based Account Activity Auditing”. If the DEFINER ...For information about restrictions on view use, see Section 23.9, “Restrictions on ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin-usage.html
row *************************** id: 1 pattern: SELECT ? pattern_database: NULL replacement: SELECT ? + 1 enabled: YES message: NULL pattern_digest: 46b876e64cd5c41009d91c754921f1d4 normalized_pattern: select ? For information about statement ...To ... To enable or disable the plugin, enable or disable the rewriter_enabled system ...
https://dev.mysql.com/doc/refman/5.7/en/caching-sha2-pluggable-authentication.html
MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: sha256_password: Implements basic SHA-256 authentication. For example, the following statement creates such an account, where password is the ...
https://dev.mysql.com/doc/refman/5.7/en/using-encrypted-connections.html
For additional information about the REQUIRE clause, see Section 13.7.1.2, “CREATE USER Statement”. For example: mysql --ssl-mode=REQUIRED mysqldump --ssl-mode=VERIFY_CA mysqladmin --ssl-mode=VERIFY_IDENTITY To configure a MySQL account to be ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-variable-summary-tables.html
Account, host, and user statistics are not collected if the performance_schema_accounts_size, performance_schema_hosts_size, and performance_schema_users_size system variables, respectively, are set to 0. The Performance Schema supports TRUNCATE ...