PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/replication-delayed.html
In MySQL 9.7, the method of delaying replication depends on two timestamps, immediate_commit_timestamp and original_commit_timestamp (see Replication Delay Timestamps); delayed replication is measured using these timestamps. This section describes ... MySQL supports delayed replication such that a replica server deliberately executes transactions later than the source by at least a specified amount of ...
https://dev.mysql.com/doc/refman/9.7/en/create-event.html
CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON {REPLICA | SLAVE}] [COMMENT 'string'] DO event_body schedule: { AT timestamp [+ INTERVAL interval] ... This ...The event does not run unless the Event Scheduler is ...
https://dev.mysql.com/doc/refman/9.7/en/time-zone-support.html
Time zone offsets are also supported for inserted datetime values; see Section 13.2.2, “The DATE, DATETIME, and TIMESTAMP Types”, for more information. This includes the values displayed by functions such as NOW() or CURTIME(), and values stored ... This section describes the time zone settings maintained by MySQL, how to load the system tables required for named time support, how to stay current with time zone changes, and how to enable leap-second ...
https://dev.mysql.com/doc/refman/9.7/en/grant-tables.html
password_last_changed is a TIMESTAMP column indicating when the password was last changed. Table 8.7 procs_priv Table Columns Table Name procs_priv Scope columns Host Db User Routine_name Routine_type Privilege columns Proc_priv Other columns ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-status-variables.html
Gr_flow_control_throttle_last_throttle_timestamp A timestamp showing when a transaction was last throttled by the Group Replication flow control mechanism. Gr_last_consensus_end_timestamp The time when the last consensus proposal was approved, in a ... This section describes the status variables providing information about Group ...
https://dev.mysql.com/doc/refman/9.7/en/mysqlbinlog.html
For statement-based logging, event information includes the SQL statement, the ID of the server on which it was executed, the timestamp when the statement was executed, how much time it took, and so forth. This system variable affects the handling ... The server's binary log consists of files containing “events” that describe modifications to database ...
https://dev.mysql.com/doc/refman/9.7/en/bit-functions.html
Binary String Bit-Operation Examples The following example illustrates use of bit operations to extract parts of a UUID value, in this case, the timestamp and IEEE 802 node number. Convert the text UUID to the corresponding 16-byte binary value so ... Table 14.17 Bit Functions and Operators Name Description & Bitwise AND >> Right shift << Left shift ^ Bitwise XOR BIT_COUNT() Return the number of bits that are set | Bitwise OR ~ Bitwise inversion The following list describes available bit functions and operators: | Bitwise ...
https://dev.mysql.com/doc/refman/9.7/en/date-and-time-type-conversion.html
For example, although DATE, DATETIME, and TIMESTAMP values all can be specified using the same set of formats, the types do not all have the same range of values. TIMESTAMP values cannot be earlier than 1970 UTC or later than '2038-01-19 03:14:07' ... To some extent, you can convert a value from one temporal type to ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-range.html
(See Bug #42849.) Note It is also possible in MySQL 9.7 to use UNIX_TIMESTAMP(timestamp_column) as a partitioning expression for tables that are partitioned by LIST. A table that is partitioned by range is partitioned in such a way that each ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-tp-connections-table.html
TIME_OF_EXPIRY Timestamp showing when an idle connection will expire if no new request arrives before then; this is NULL when the thread is currently processing a request. TIME_OF_ADD Timestamp showing when the connection was added to the thread ...