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/innodb-online-ddl-operations.html
The secondary index entries are pre-sorted, and so can be loaded in order. Reordering columns To reorder columns, use FIRST or AFTER in CHANGE or MODIFY operations. Modifying STORED column order ALTER TABLE t1 MODIFY COLUMN c2 INT GENERATED ALWAYS ... Online support details, syntax examples, and usage notes for DDL operations are provided under the following topics in this ...
https://dev.mysql.com/doc/refman/8.0/en/internal-temporary-tables.html
Evaluation of statements that contain an ORDER BY clause and a different GROUP BY clause, or for which the ORDER BY or GROUP BY contains columns from tables other than the first table in the join queue. Evaluation of DISTINCT combined with ORDER BY ... In some cases, the server creates internal temporary tables while processing ...
https://dev.mysql.com/doc/refman/8.0/en/ldap-pluggable-authentication.html
OpenLDAP uses configuration options in this order of precedence: Configuration specified by the LDAP client. This part of the authentication string lists group names in the order grp1, grp2, grp3. The LDAP plugin compares that list with the set of ... Note LDAP pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html
Use of a column with RAND() values in an ORDER BY or GROUP BY clause may yield unexpected results because for either clause a RAND() expression can be evaluated multiple times for the same row, each time returning a different result. ABS(X) Returns ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-membership.html
The succession_order column shows the place in the succession queue that the current node views itself as having. In addition, the current president should see itself as 1 in the order of succession, the successor node should see itself as 2, and so ... The membership table describes the view that each data node has of all the others in the cluster, including node group membership, president node, arbitrator, arbitrator successor, arbitrator connection states, and other ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-params-ndbd.html
BuildIndexThreads: Number of threads to use for building ordered indexes during system or node restart. Setting this parameter to 0 disables multithreaded building of ordered indexes. HeartbeatOrder: Sets order in which data nodes check each others' ... The listings in this section provide information about parameters used in the [ndbd] or [ndbd default] sections of a config.ini file for configuring NDB Cluster data ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-documents-find.html
mysql-js> db.countryinfo.find().fields( mysqlx.expr('{"Name": upper(Name), "GNPPerCapita": GNP*1000000/demographics.Population}')).limit(2) { "Name": "ARUBA", "GNPPerCapita": 8038.834951456311 } { "Name": "AFGHANISTAN", "GNPPerCapita": ... You can ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-documents-find.html
mysql-py> db.countryinfo.find().fields( mysqlx.expr('{"Name": upper(Name), "GNPPerCapita": GNP*1000000/demographics.Population}')).limit(2) { "Name": "ARUBA", "GNPPerCapita": 8038.834951456311 } { "Name": "AFGHANISTAN", "GNPPerCapita": ... You can ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-digests.html
Consider these statements: SELECT * FROM orders WHERE customer_id=10 AND quantity>20 SELECT * FROM orders WHERE customer_id = 20 AND quantity > 100 To normalize these statements, the parser replaces data values by ? and adjusts whitespace. Both ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-timing.html
The time a statement (or stage) takes to execute is in general orders of magnitude larger than the time it takes to execute a single wait. The extra “overhead” compared to the CYCLE timer is not significant, because the overhead caused by ...