PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-option-tables.html
ndb-deferred-constraints: Specifies that constraint checks on unique indexes (where these are supported) should be deferred until commit time. ndb-wait-connected: Time (in seconds) for MySQL server to wait for connection to cluster management and ...
https://dev.mysql.com/doc/refman/9.7/en/mysqldump.html
With large data sizes, even if the backup step takes a reasonable time, restoring the data can be very slow because replaying the SQL statements involves disk I/O for insertion, index creation, and so on. To dump information about one or more user ... 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/9.7/en/timestamp-lookups.html
Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted into and retrieved from TIMESTAMP columns are converted between the session time zone and UTC. If the session time zone is UTC, there is effectively no time zone ...
https://dev.mysql.com/doc/refman/9.7/en/replication-options-reference.html
gtid_executed_compression_period: Compress gtid_executed table each time this many transactions have occurred. replica_net_timeout: Number of seconds to wait for more data from source/replica connection before aborting read. The following two ...
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/datetime.html
MySQL recognizes DATE, DATETIME, and TIMESTAMP values in several formats, described in Section 11.1.3, “Date and Time Literals”. For the DATE and DATETIME range descriptions, “supported” means that although earlier values might work, there ...This section describes their characteristics, how they are similar, and how they ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-replication-applier-metrics-table.html
This table provides replication applier statistics such as wait times, wait counts, transaction counts, event counts, and byte counts for the applier coordinator. LAST_APPLIER_START The last time (since server start) that the channel's applier was ...If the applier is stopped and restarted, then all active periods are summed ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-data-arguments.html
Temporal types: DATE, DATETIME, and TIMESTAMP are supported, and are converted to JavaScript Date values. TIME values are treated as strings; YEAR values are treated as numbers. More more information, see Time zone support, later in this section.
https://dev.mysql.com/doc/refman/9.7/en/miscellaneous-functions.html
The UUID value is assumed not to have its time-low and time-high parts swapped. If swap_flag is 1, the UUID value is assumed to have its time-low and time-high parts swapped. For usage examples and information about time-part swapping, see the ...
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. For example: # at 141 #100309 9:28:36 ...