PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/replication-options-replica.html
With this option set to 1 (TRUE), the replica does not skip events that have its own server ID. This section explains the server options and system variables that apply to replica servers and contains the following: Startup Options for Replica ...
https://dev.mysql.com/doc/refman/9.7/en/replication-rbr-safe-unsafe.html
If this is true of the statement, we refer to the statement as safe; otherwise, we refer to it as unsafe. The “safeness” of a statement in MySQL replication refers to whether the statement and its effects can be replicated correctly using ...
https://dev.mysql.com/doc/refman/9.7/en/replication-rules-table-options.html
The replica checks for and evaluates table options only if either of the following two conditions is true: No matching database options were found. One or more database options were found, and were evaluated to arrive at an “execute” condition ...
https://dev.mysql.com/doc/refman/9.7/en/replication-solutions-performance.html
With this option, replication instructions from Source 1 are also written to Source 2's binary log so that they can then be replicated to the true replicas. As the number of replicas connecting to a source increases, the load, although minimal, ...
https://dev.mysql.com/doc/refman/9.7/en/replication-solutions-switch.html
When this is true for all replicas, they can be reconfigured to the new setup. You can tell a replica to change to a new source using the CHANGE REPLICATION SOURCE TO statement. The replica does not check whether the databases on the source are ...
https://dev.mysql.com/doc/refman/9.7/en/restart.html
One use for RESTART is when it is not possible or convenient to gain command-line access to the MySQL server on the server host to restart it. For example, SET PERSIST_ONLY can be used at runtime to make configuration changes to system variables ...
https://dev.mysql.com/doc/refman/9.7/en/reusing-ssl-sessions.html
If the currently active mysql connection did resume the session, the status information includes SSL session reused: true. MySQL client programs may elect to resume a prior SSL session, provided that the server has the session in its runtime cache.
https://dev.mysql.com/doc/refman/9.7/en/rewriter-query-rewrite-plugin-usage.html
This is also true for statements executed by MySQL client programs including mysqlbinlog, mysqladmin, and mysqldump; for this reason, you should grant SKIP_QUERY_REWRITE to the user account or accounts used by these utilities to connect to MySQL.
https://dev.mysql.com/doc/refman/9.7/en/row-subqueries.html
If this row has col3 and col4 values equal to the col1 and col2 values of any rows in t1, the WHERE expression is TRUE and each query returns those t1 rows. Scalar or column subqueries return a single value or a column of values. A row subquery is ...
https://dev.mysql.com/doc/refman/9.7/en/select.html
where_condition is an expression that evaluates to true for each row to be selected. SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] ...