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/mathematical-functions.html
One implication of this behavior is that for equal argument values, RAND(N) returns the same value each time, and thus produces a repeatable sequence of column values. Use of a column with RAND() values in an ORDER BY or GROUP BY clause may yield ...
https://dev.mysql.com/doc/refman/8.0/en/explain.html
Obtaining Execution Plan Information The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. EXPLAIN ANALYZE can be used with SELECT statements, as ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-usage.html
The following general considerations apply when choosing key lengths and encryption algorithms: The strength of encryption for private and public keys increases with the key size, but the time for key generation increases as well. Key string values ...If you install the legacy functions then upgrade to MySQL 8.0.30 or later, the functions you created remain available, are supported, and continue to work in the same ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-examples.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-overview-requirements.html
NDB Cluster requires communication between data nodes and API nodes (including SQL nodes), as well as between data nodes and other data nodes, to execute queries and updates. In addition, to maintain consistency and service despite the silent ...
https://dev.mysql.com/doc/refman/8.0/en/what-is-mysql.html
We use the phrase “the SQL standard” to mean the current version of the SQL Standard at any time. It is the only cloud service that combines transactions, real-time analytics across data warehouses and data lakes, and machine learning in one ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-usage-differences.html
(To update the cached values at any time for a given table, use ANALYZE TABLE.) If there are no cached statistics or statistics have expired, statistics are retrieved from storage engines when querying table statistics columns. Previously, it was ...
https://dev.mysql.com/doc/refman/8.0/en/sorted-index-builds.html
InnoDB performs a bulk load instead of inserting one index record at a time when creating or rebuilding indexes. In the first phase, the clustered index is scanned, and index entries are generated and added to the sort buffer. When the sort buffer ...This method of index creation is also known as a sorted index ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-security-mysql-privileges.html
This includes all MySQL privilege types (SELECT privilege, UPDATE privilege, DELETE privilege, and so on) granted on the database, table, and column level. In this section, we discuss how the MySQL privilege system works in relation to NDB Cluster ...It is important to keep in mind that, by default, the MySQL grant tables use the InnoDB storage ...
https://dev.mysql.com/doc/refman/8.0/en/replication-asynchronous-connection-failover.html
When you add a group member to the source list and define it as part of a managed group, the asynchronous connection failover mechanism updates the source list to keep it in line with membership changes, adding and removing group members ...The list ... Beginning with MySQL 8.0.22, you can use the asynchronous connection failover mechanism to automatically establish an asynchronous (source to replica) replication connection to a new source after the existing connection from a replica to its source ...