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/audit-log-reference.html
The password is fetched from the MySQL keyring, which must be enabled or an error occurs. Return value: The password string for success (up to 766 bytes), or NULL and an error for failure. Current sessions are no longer logged unless they disconnect ...Unless those objects are installed, the audit_log plugin operates in legacy ...
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/keyring-service.html
MySQL Server supports a keyring service that enables internal server components and plugins to securely store sensitive information for later retrieval. MySQL distributions provide a keyring interface that is accessible at two levels: At the SQL ...
https://dev.mysql.com/doc/refman/5.7/en/subqueries.html
All subquery forms and operations that the SQL standard requires are supported, as well as a few features that are MySQL-specific. Here is an example of a subquery: SELECT * FROM t1 WHERE column1 = (SELECT column1 FROM t2); In this example, SELECT * ...
https://dev.mysql.com/doc/refman/5.7/en/merge-table-advantages.html
MERGE tables can help you solve the following problems: Easily manage a set of log tables. For example, you can put data from different months into separate tables, compress some of them with myisampack, and then create a MERGE table to use them as ...
https://dev.mysql.com/doc/refman/5.7/en/option-modifiers.html
For example, with --maximum-back_log=200, the server produces this error: Maximum value of 'back_log' cannot be set . The --maximum prefix is available for mysqld only and permits a limit to be placed on how large client programs can set session ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-information-schema.html
Changing the value of lower_case_table_names to 1 or 2 causes the second query to return the same (nonempty) result as the first query. String columns in INFORMATION_SCHEMA tables have a collation of utf8_general_ci, which is case-insensitive.
https://dev.mysql.com/doc/refman/5.7/en/diagnostics-area.html
Standard SQL also supports GET STACKED DIAGNOSTICS syntax for referring to the second diagnostics area during condition handler execution. Execution of RESIGNAL The RESIGNAL statement passes on the error condition information that is available ...
https://dev.mysql.com/doc/refman/5.7/en/engine-condition-pushdown-optimization.html
(An index access method would be more efficient and so would be chosen in preference to condition pushdown.) Engine condition pushdown cannot be employed for the second query because the comparison involving the nonindexed column b is indirect. For ... This optimization improves the efficiency of direct comparisons between a nonindexed column and a ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-generated-columns.html
Adding or dropping a secondary index on a virtual generated column is an in-place operation. For more information, see Section 13.1.18.8, “Secondary Indexes and Generated Columns”. However, later reads from the table might report warnings or ...