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/date-and-time-functions.html
A warning is logged if you use this function when binlog_format is set to STATEMENT. This section describes the functions that can be used to manipulate temporal values. See Section 11.2, “Date and Time Data Types”, for a description of the ...
https://dev.mysql.com/doc/refman/5.7/en/dynamic-system-variables.html
Many server system variables are dynamic and can be set at runtime. For a description of the privilege requirements for setting system variables, see Section 5.1.8.1, “System Variable Privileges” The following table lists all dynamic system ...
https://dev.mysql.com/doc/refman/5.7/en/show-variables.html
SHOW [GLOBAL | SESSION] VARIABLES [LIKE 'pattern' | WHERE expr] Note The value of the show_compatibility_56 system variable affects the information available from and privileges required for the statement described here. For details, see the ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-configuring-instances.html
server_id=1 gtid_mode=ON enforce_gtid_consistency=ON master_info_repository=TABLE relay_log_info_repository=TABLE binlog_checksum=NONE log_slave_updates=ON log_bin=binlog binlog_format=ROW These settings configure the server to use the unique ...
https://dev.mysql.com/doc/refman/5.7/en/server-system-variable-reference.html
The following table lists all system variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables (System Var), and status variables (Status var) in ...
https://dev.mysql.com/doc/refman/5.7/en/server-option-variable-reference.html
The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...
https://dev.mysql.com/doc/refman/5.7/en/system-variable-privileges.html
A system variable can have a global value that affects server operation as a whole, a session value that affects only the current session, or both. This section describes the privileges required to assign values to system variables at runtime.
https://dev.mysql.com/doc/refman/5.7/en/replication-rules-table-options.html
The only type of statement that can update both an included and an ignored table and still be replicated successfully is a DML statement that has been logged with binlog_format=ROW. The replica checks for and evaluates table options only if either ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules-db-options.html
When evaluating replication options, the replica begins by checking to see whether there are any --replicate-do-db or --replicate-ignore-db options that apply. When using --binlog-do-db or --binlog-ignore-db, the process is similar, but the options ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-usage.html
Nontransactional DML statements involving temporary tables are allowed when using binlog_format=ROW, as long as any nontransactional tables affected by the statements are temporary tables (Bug #14272672). MySQL uses statement-based logging (SBL), ...