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/audit-log-file-reading.html
The plugin opens each remaining candidate file, verifies that the file actually contains JSON audit events, and sorts the files using the timestamps from the first event of each file. For example: [ { "timestamp": "2020-05-18 13:39:33", "id": 0, ...
https://dev.mysql.com/doc/refman/5.7/en/show-slave-status.html
Seconds_Behind_Master This field is an indication of how “late” the replica is: When the replica is actively processing updates, this field shows the difference between the current timestamp on the replica and the original timestamp logged on ...
https://dev.mysql.com/doc/refman/5.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 SLAVE] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ... This is an ...
https://dev.mysql.com/doc/refman/5.7/en/grant-tables.html
password_last_changed is a TIMESTAMP column indicating when the password was last changed. Table 6.5 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/5.7/en/mysqldump.html
--tz-utc Command-Line Format --tz-utc Disabled by skip-tz-utc This option enables TIMESTAMP columns to be dumped and reloaded between servers in different time zones. Without this option, TIMESTAMP columns are dumped and reloaded in the time zones ... The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlpump.html
However, these statements do not include attributes such as the event creation and modification timestamps, so when the events are reloaded, they are created with timestamps equal to the reload time. If you require events to be created with their ...
https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html
This includes the values displayed by functions such as NOW() or CURTIME(), and values stored in and retrieved from TIMESTAMP columns. Values for TIMESTAMP columns are converted from the session time zone to UTC for storage, and from UTC to the ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-reference.html
The following items are significant (other items are ignored): timestamp, id: The position within the audit log of the first event to read. The timestamp and id items together comprise a bookmark that uniquely identify a particular event. Example: ...Unless those objects are installed, the audit_log plugin operates in legacy ...
https://dev.mysql.com/doc/refman/5.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. --start-datetime=datetime Command-Line ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-literals.html
DATE 'str' TIME 'str' TIMESTAMP 'str' MySQL recognizes but, unlike standard SQL, does not require the type keyword. The TIMESTAMP syntax produces a DATETIME value in MySQL because DATETIME has a range that more closely corresponds to the standard ...