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/replication-options.html
Command-Line Format --server-id=# System Variable server_id Scope Global Dynamic Yes Type Integer Default Value 0 Minimum Value 0 Maximum Value 4294967295 This variable specifies the server ID. Note The presence of the server_uuid system variable in ... The following sections contain information about mysqld options and server variables that are used in replication and for controlling the binary ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules-examples.html
If you want to be sure that your replication filters always operate in the same way independently of the binary logging format, which is particularly important if you are using mixed binary logging format, follow the guidance in this topic. The ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules-table-options.html
If row-based replication is enabled, the replica does not know whether a statement occurred within a stored function on the source, so this condition does not apply. Having reached this point, if there are no table options, the replica simply ...
https://dev.mysql.com/doc/refman/5.7/en/request-access.html
This is where the privilege columns in the grant tables come into play. Values in the scope columns of this table can take the following forms: A blank User value matches the anonymous user. This is similar to db table sorting, but simpler because ... After the server accepts a connection, it enters Stage 2 of access ...
https://dev.mysql.com/doc/refman/5.7/en/set-sql-log-bin.html
Set this variable to OFF for a session to temporarily disable binary logging while making changes to the source you do not want replicated to the replica. Setting the session value of this system variable is a restricted operation. Setting this ...
https://dev.mysql.com/doc/refman/5.7/en/set-variable.html
They use the = assignment operator, but the := assignment operator is also permitted for this purpose. This statement assigns a value to a user-defined variable and a system variable: SET @x = 1, SESSION sql_mode = ''; If you set multiple system ...
https://dev.mysql.com/doc/refman/5.7/en/show-columns.html
The conditions under which this occurs are described in Section 13.1.18.6, “Silent Column Specification Changes”. This value is displayed only if you use the FULL keyword. This is NULL if the column has an explicit default of NULL, or if the ...
https://dev.mysql.com/doc/refman/5.7/en/slow-query-log.html
To make this easier, you can use the mysqldumpslow command to process a slow query log file and summarize its contents. This behavior can be changed using log_slow_admin_statements and log_queries_not_using_indexes, as described later. By default, ... The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least min_examined_row_limit rows to be ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-materialization.html
(oe_1, oe_2, ..., oe_N) [NOT] IN (SELECT ie_1, i_2, ..., ie_N ...) The predicate has this form, when there is a single outer expression oe and inner expression ie. This query is subject to materialization: SELECT * FROM t1 WHERE t1.a IN (SELECT t2.b ... The optimizer uses materialization to enable more efficient subquery ...
https://dev.mysql.com/doc/refman/5.7/en/table-size-limit.html
For example, you are using MyISAM tables on an operating system that supports files only up to 2GB in size and you have hit this limit for the data file or index file. MyISAM permits data and index files to grow up to 256TB by default, but this ...