PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.8Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-lifecycle.html
If a GTID was assigned for the transaction, the GTID is persisted atomically at commit time by writing it to the binary log at the beginning of the transaction (as a Gtid_log_event). If binary logging is enabled on the replica, the GTID is persisted ... The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the ...
https://dev.mysql.com/doc/refman/8.0/en/show-engine.html
An NdbTransaction is created each time a table schema operation (such as CREATE TABLE or ALTER TABLE) is performed on an NDB table. In general, one of these is created each time a data manipulation statement is performed by an SQL node. SHOW ENGINE ...
https://dev.mysql.com/doc/refman/8.0/en/sys-host-summary-by-file-io-type.html
total_latency The total wait time of timed occurrences of the file I/O event for the host. max_latency The maximum single wait time of timed occurrences of the file I/O event for the host. These views summarize file I/O, grouped by host and event ...
https://dev.mysql.com/doc/refman/8.0/en/sys-host-summary-by-stages.html
total_latency The total wait time of timed occurrences of the stage event for the host. avg_latency The average wait time per timed occurrence of the stage event for the host. By default, rows are sorted by host and descending total latency. The ...
https://dev.mysql.com/doc/refman/8.0/en/sys-user-summary-by-file-io-type.html
latency The total wait time of timed occurrences of the file I/O event for the user. max_latency The maximum single wait time of timed occurrences of the file I/O event for the user. These views summarize file I/O, grouped by user and event type.
https://dev.mysql.com/doc/refman/8.0/en/sys-user-summary-by-stages.html
total_latency The total wait time of timed occurrences of the stage event for the user. avg_latency The average wait time per timed occurrence of the stage event for the user. By default, rows are sorted by user and descending total stage latency.
https://dev.mysql.com/doc/refman/8.0/en/table-locking.html
But because only one session can write to a table at any one time, for best performance with these other storage engines, use them primarily for tables that are queried often and rarely inserted into or updated. A SELECT statement that takes a long ... InnoDB tables use row-level locking so that multiple sessions and applications can read from and write to the same table simultaneously, without making each other wait or producing inconsistent ...
https://dev.mysql.com/doc/refman/8.0/en/version-tokens-reference.html
mysql> SELECT version_tokens_lock_exclusive('lock1', 'lock2', 10); +-----------------------------------------------------+ | version_tokens_lock_exclusive('lock1', 'lock2', 10) | +-----------------------------------------------------+ | 1 | ... The ...
https://dev.mysql.com/doc/refman/8.0/en/window-function-descriptions.html
This section describes nonaggregate window functions that, for each row from a query, perform a calculation using rows related to that row. Most aggregate functions also can be used as window functions; see Section 14.19.1, “Aggregate Function ...
https://dev.mysql.com/doc/refman/8.0/en/aggregate-functions.html
Examples: SELECT SEC_TO_TIME(SUM(TIME_TO_SEC(time_col))) FROM tbl_name; SELECT FROM_DAYS(SUM(TO_DAYS(date_col))) FROM tbl_name; Functions such as SUM() or AVG() that expect a numeric argument cast the argument to a number if necessary. Multiple ...