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-option-tables.html
Ndb_conflict_fn_max: Number of times that NDB replication conflict resolution based on "greater timestamp wins" has been applied to update and delete operations. Ndb_conflict_fn_old: Number of times that NDB replication "same timestamp wins" ... The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-options-variables.html
Ndb_conflict_fn_max Used in NDB Cluster Replication conflict resolution, this variable shows the number of times that a row was not applied on the current SQL node due to “greatest timestamp wins” conflict resolution since the last time that ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-connection-status-table.html
LAST_ERROR_TIMESTAMP A timestamp in YYMMDD hh:mm:ss format that shows when the most recent I/O error took place. LAST_HEARTBEAT_TIMESTAMP A timestamp in YYMMDD hh:mm:ss format that shows when the most recent heartbeat signal was received by a ...
https://dev.mysql.com/doc/refman/5.7/en/point-in-time-recovery-positions.html
Because the output of mysqlbinlog includes SET TIMESTAMP statements before each SQL statement recorded, the recovered data and related MySQL logs reflect the original times at which the transactions were executed. The last section, Section 7.5.1, ...
https://dev.mysql.com/doc/refman/5.7/en/processlist-access.html
The thread's notion of the current time may be altered in some cases: The thread can change the time with SET TIMESTAMP = value. For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the ... The following discussion enumerates the sources of process information, the privileges required to see process information, and describes the content of process list ...
https://dev.mysql.com/doc/refman/5.7/en/replace.html
REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] {VALUES | VALUE} (value_list) [, (value_list)] ... REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-fractional-seconds.html
MySQL 5.7 permits fractional seconds for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision. Examples: On the source, the timestamp system variable returns a value that includes a microseconds fractional part; on the ...There may be problems replicating from a source server that understands fractional seconds to an older replica (MySQL 5.6.3 and earlier) that does not: For CREATE TABLE statements containing columns that have an fsp (fractional seconds precision) value greater than 0, replication fails due to parser ...
https://dev.mysql.com/doc/refman/5.7/en/slow-query-log.html
The log_timestamps system variable controls the time zone of timestamps in messages written to the slow query log file (as well as to the general query log file and the error log). Each statement written to the slow query log file is preceded by a ... 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/sql-mode.html
It does not apply to TIMESTAMP columns, which always require a valid date. This means HIGH_NOT_PRECEDENCE plus some SHOW CREATE TABLE behaviors specific to MYSQL323: TIMESTAMP column display does not include DEFAULT or ON UPDATE attributes. The ...
https://dev.mysql.com/doc/refman/5.7/en/type-conversion.html
If one of the arguments is a TIMESTAMP or DATETIME column and the other argument is a constant, the constant is converted to a timestamp before the comparison is performed. When an operator is used with operands of different types, type conversion ...