Search Results
https://dev.mysql.com/doc/refman/8.4/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.4/en/mysql-cluster-programs-ndb-select-all.html
This option can be used only in conjunction with the -o (--order) option. --order=index_name, -o index_name Orders the output according to the index named index_name. --tupscan, -t Scan the table in the order of the tuples. ndb_select_all prints ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/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 ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-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' ... ApiFailureHandlingTimeout: Maximum time for API node failure handling before ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-compressed-connections-8020.html
The order in which you specify the compression algorithms is the order of preference in which MySQL Shell proposes them, but the server might not be influenced by this preference, depending on the protocol and the server configuration. The above ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-bulk-load-mysql-server.html
IN PRIMARY KEY ORDER: Use when the data is already sorted. For a file series, the primary keys in each file must be disjoint and in ascending order from one file to the next. MySQL includes a bulk load extension to the LOAD DATA statement. It can ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-statements.html
Query iterceptors are chainable: the results returned by the current interceptor will be passed on to the next in the chain, from left-to-right in the order specified in this property. This results in better performance when dealing with time zone ...