Search Results
https://dev.mysql.com/doc/refman/8.4/en/is-null-optimization.html
This optimization does not occur in cases when the column might produce NULL anyway (for example, if it comes from a table on the right side of a LEFT JOIN). MySQL can perform the same optimization on col_name IS NULL that it can use for col_name = ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-basics.html
NDB Cluster tables are normally stored completely in memory rather than on disk (this is why we refer to NDB Cluster as an in-memory database). However, some NDB Cluster data can be stored on disk; see Section 25.6.11, “NDB Cluster Disk Data ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-computer-definition.html
The [computer] section has no real significance other than serving as a way to avoid the need of defining host names for each node in the system. Id Version (or later) NDB 8.4.0 Type or units string Default [...] Range ... Restart Type Initial ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-mgm-definition.html
The [ndb_mgmd] section is used to configure the behavior of the management server. If multiple management servers are employed, you can specify parameters common to all of them in an [ndb_mgmd default] section. [mgm] and [mgm default] are older ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-mgm.html
All options that can be used with ndb_mgm are shown in the following table. The ndb_mgm management client process is actually not needed to run the cluster. Its value lies in providing a set of commands for checking the cluster's status, starting ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-sign-keys.html
Management of TLS keys and certificates in implemented in NDB Cluster as the executable utility program ndb_sign_keys, which can normally be found in the MySQL bin directory. --CA-tool Command-Line Format --CA-tool=name Type File name Default Value ...The program performs such functions as creating, signing, and retiring keys and certificates, and normally works as follows: ndb_sign_keys connects to ndb_mgmd and fetches the cluster' ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-waiter.html
Options that can be used with ndb_waiter are shown in the following table. ndb_waiter repeatedly (each 100 milliseconds) prints out the status of all cluster data nodes until either the cluster reaches a given status or the --timeout limit is ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-javascript-download.html
The world_x Schema The world_x example schema contains the following JSON collection and relational tables: Collection countryinfo: Information about countries in the world. As part of this quick-start guide, an example schema is provided which is ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-download.html
The world_x Schema The world_x example schema contains the following JSON collection and relational tables: Collection countryinfo: Information about countries in the world. As part of this quick-start guide, an example schema is provided which is ...
https://dev.mysql.com/doc/refman/8.4/en/numeric-type-attributes.html
If you store values larger than the display width in an integer column that has the ZEROFILL attribute, you may experience problems when MySQL generates temporary tables for some complicated joins. Typically this is value+1, where value is the ...