MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 121 to 130 of 140 total results

https://dev.mysql.com/doc/refman/9.7/en/replication-administration-status.html

This is especially likely when the events have old timestamps; in such cases, if you execute SHOW REPLICA STATUS several times in a relatively short period, you may see this value change back and forth repeatedly between 0 and a relatively large ...

19.5.1.1 Replication and AUTO_INCREMENT

https://dev.mysql.com/doc/refman/9.7/en/replication-features-auto-increment.html

Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values is carried out subject to the following exceptions: A statement invoking a trigger or function that causes an update to an AUTO_INCREMENT column is not replicated ...(Bug #45677) An INSERT into a table that has a composite primary key that includes an AUTO_INCREMENT column that is not the first column of this composite key is not safe for statement-based logging or ...

19.5.1.15 Replication and Fractional Seconds Support

https://dev.mysql.com/doc/refman/9.7/en/replication-features-fractional-seconds.html

MySQL 9.7 permits fractional seconds for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision.

19.5.1.33 Replication Retries and Timeouts

https://dev.mysql.com/doc/refman/9.7/en/replication-features-timeout.html

This data includes timestamps showing how long it took the applier thread to apply the last transaction from start to finish (and when the transaction currently in progress was started), and how long this was after the commit on the original source ... The global value of the system variable replica_transaction_retries sets the maximum number of times for applier threads on a single-threaded or multithreaded replica to automatically retry failed transactions before ...

19.5.1.40 Replication and Variables

https://dev.mysql.com/doc/refman/9.7/en/replication-features-variables.html

sql_mode is also replicated except for the NO_DIR_IN_CREATE mode; the replica always preserves its own value for NO_DIR_IN_CREATE, regardless of changes to it on the source. However, when mysqlbinlog parses a SET @@sql_mode = mode statement, the ...

19.1.6.4 Binary Logging Options and Variables

https://dev.mysql.com/doc/refman/9.7/en/replication-options-binary-log.html

original_commit_timestamp System Variable original_commit_timestamp Scope Session Dynamic Yes SET_VAR Hint Applies No Type Numeric For internal use by replication. This allows the original commit timestamp to be propagated throughout a replication ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...

7.1.4 Server Option, System Variable, and Status Variable Reference

https://dev.mysql.com/doc/refman/9.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 ...

7.1.7 Server Command Options

https://dev.mysql.com/doc/refman/9.7/en/server-options.html

For information about the implications for binary logging and replication, see the description for SYSDATE() in Section 14.7, “Date and Time Functions” and for SET TIMESTAMP in Section 7.1.8, “Server System Variables”. When you start the ...

7.1.10 Server Status Variables

https://dev.mysql.com/doc/refman/9.7/en/server-status-variables.html

Deprecated_use_i_s_processlist_last_timestamp A timestamp indicating the last time the information_schema.processlist table has been accessed since the last restart. The MySQL server maintains many status variables that provide information about ...

7.1.5 Server System Variable Reference

https://dev.mysql.com/doc/refman/9.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 ...

Displaying 121 to 130 of 140 total results