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/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/validate-password.html
The validate_password plugin implements these capabilities: For SQL statements that assign a password supplied as a cleartext value, validate_password checks the password against the current password policy and rejects the password if it is weak ...
https://dev.mysql.com/doc/refman/5.7/en/explain.html
In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query execution plan (that is, an explanation of how MySQL would execute a query). Obtaining Execution Plan ...The ...
https://dev.mysql.com/doc/refman/5.7/en/bit-type.html
The maximum combined size of all BIT columns used in a given NDB table must not exceed 4096 bits. The BIT data type is used to store bit values. If you assign a value to a BIT(M) column that is less than M bits long, the value is padded on the left ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules.html
If the server does log the statement, the statement is sent to all replicas and each replica determines whether to execute it or ignore it. Instead, use filtering on the replica to control the events that are executed on the replica. On the replica ... If a replication source server does not write a statement to its binary log, the statement is not ...
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/federated-description.html
To read a result set, it uses mysql_store_result() and fetches rows one at a time using mysql_fetch_row(). When you create a table using one of the standard storage engines (such as MyISAM, CSV or InnoDB), the table consists of the table definition ...
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/events-status-info.html
The Event Scheduler writes information about event execution that terminates with an error or warning to the MySQL Server's error log. For frequently executed events, it is possible for this to result in many logged messages. INTO var_list ...See ...