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/mysqlshow.html
The mysqlshow client can be used to quickly see which databases exist, their tables, or a table's columns or indexes. If the file does not exist or is otherwise inaccessible, an error occurs. If the file does not exist or is otherwise inaccessible, ...The same information can be obtained by using those statements ...
https://dev.mysql.com/doc/refman/5.7/en/optimizer-hints.html
When a hint comment contains multiple hints, the possibility of duplicates and conflicts exists. Examples: SELECT id, a IN (SELECT /*+ SUBQUERY(MATERIALIZATION) */ a FROM t1) FROM t2; SELECT * FROM t2 WHERE t2.a IN (SELECT /*+ SUBQUERY(INTOEXISTS) ... One means of control over optimizer strategies is to set the optimizer_switch system variable (see Section 8.9.2, “Switchable ...
https://dev.mysql.com/doc/refman/5.7/en/pam-pluggable-authentication.html
To use a given PAM service, you must set up a PAM file with the same name in the PAM configuration directory (creating the file if it does not exist). The file contents are system dependent, so check existing login-related files in the /etc/pam.d ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-host-cache-table.html
New return codes are an optional extension to the existing plugin API. COUNT_PROXY_USER_ERRORS The number of errors detected when proxy user A is proxied to another user B who does not exist. COUNT_PROXY_USER_ACL_ERRORS The number of errors detected ... The MySQL server maintains an in-memory host cache that contains client host name and IP address information and is used to avoid Domain Name System (DNS) ...
https://dev.mysql.com/doc/refman/5.7/en/prepare.html
If a prepared statement with the given name already exists, it is deallocated implicitly before the new statement is prepared. This means that if the new statement contains an error and cannot be prepared, an error is returned and no statement with ... PREPARE stmt_name FROM preparable_stmt The PREPARE statement prepares a SQL statement and assigns it a name, stmt_name, by which to refer to the statement ...
https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html
DROP Enables use of statements that drop (remove) existing databases, tables, and views. As a security measure, the server does not overwrite existing files. INSERT or UPDATE granted for the mysql system database enable a user to add privileges or ... The privileges granted to a MySQL account determine which operations the account can ...
https://dev.mysql.com/doc/refman/5.7/en/proxy-users.html
The account for the proxied user must exist and be granted the privileges to be assumed by the proxy user. Suppose that there exists a plugin named ldap_auth that implements LDAP authentication and maps connecting users onto either a developer or ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-transaction-inconsistencies.html
The following scenarios are relevant to the existence of half-applied transactions, gaps, and source binary log position lag: While replication threads are running, there may be gaps and half-applied transactions. If a replication channel has gaps, ... Inconsistencies in the sequence of transactions that have been executed from the relay log can occur depending on your replication ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-usage.html
When a given client session ends, the server logs a DROP TEMPORARY TABLE IF EXISTS statement for each temporary table that still exists and was created when statement-based binary logging was in use. If row-based or mixed format binary logging was ... MySQL uses statement-based logging (SBL), row-based logging (RBL) or mixed-format ...
https://dev.mysql.com/doc/refman/5.7/en/show-slave-status.html
You can use this value with the CHANGE MASTER TO statement's MASTER_LOG_POS option when starting a new replica from an existing replica, so that the new replica reads from this point. Relay_Log_Space The total combined size of all existing relay log ... SHOW SLAVE STATUS [FOR CHANNEL channel] This statement provides status information on essential parameters of the replica ...