PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/window-functions-usage.html
For example, if a table contains a TIMESTAMP column named ts, standard SQL permits PARTITION BY ts but not PARTITION BY HOUR(ts), whereas MySQL permits both. Window functions are permitted only in the select list and ORDER BY clause. Query result ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-limits.html
In this section, we list limits found in NDB Cluster that either differ from limits found in, or that are not found in, standard MySQL. These hard limits include: Database memory size and index memory size (DataMemory and IndexMemory, respectively). The maximum number of operations that can be performed per transaction is set using the configuration parameters MaxNoOfConcurrentOperations and ...
https://dev.mysql.com/doc/refman/8.0/en/processlist-access.html
For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the replica host. The following discussion enumerates the sources of process information, the privileges required ...The other sources have negative performance consequences because they require a ...
https://dev.mysql.com/doc/refman/8.0/en/replication-administration-status.html
row *************************** Id: 10 User: root Host: replica1:58371 db: NULL Command: Binlog Dump Time: 777 State: Has sent all binlog to slave; waiting for binlog to be updated Info: NULL Because it is the replica that drives the replication ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-restarting-group.html
The replication group must therefore be restarted beginning with the most up to date member, that is, the member that has the most transactions executed and certified. You must therefore restart each member to check the transactions, compare all the ...As long as the remaining members are a majority of the group they can elect a new primary and continue to function as a ... Group Replication is designed to ensure that the database service is continuously available, even if ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-internal-data.html
Note This section describes locking information as exposed by the Performance Schema data_locks and data_lock_waits tables, which supersede the INFORMATION_SCHEMA INNODB_LOCKS and INNODB_LOCK_WAITS tables in MySQL 8.0. For similar discussion ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-transactions.html
A number of limitations exist in NDB Cluster with regard to the handling of transactions. LOCK IN SHARE MODE causes shared row locks to be used; FOR UPDATE causes exclusive row locks to be used. See Section 25.6.8.4, “NDB Cluster Backup ...The ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-transporters.html
In NDB 8.0.37 and later, you can obtain similar information about individual transporters from the transporter_details table. Connections to API and management nodes which are configured but not currently connected to the cluster are shown with ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-error-summary-tables.html
SUM_ERROR_HANDLED This column aggregates the number of times the error was handled by an SQL exception handler. FIRST_SEEN, LAST_SEEN Timestamp indicating when the error was first seen and most recently seen. The Performance Schema maintains ...For ...
https://dev.mysql.com/doc/refman/8.0/en/flow-control-functions.html
If all types are temporal, the result is temporal: If all temporal types are DATE, TIME, or TIMESTAMP, the result is DATE, TIME, or TIMESTAMP, respectively. Otherwise, for a mix of temporal types, the result is DATETIME. The CASE statement cannot ...