Search Results
https://dev.mysql.com/doc/refman/8.4/en/subquery-materialization.html
The optimizer uses materialization to enable more efficient subquery processing. Materialization speeds up query execution by generating a subquery result as a temporary table, normally in memory. The first time MySQL needs the subquery result, it ...
https://dev.mysql.com/doc/refman/8.4/en/table-cache.html
When you execute a mysqladmin status command, you should see something like this: Uptime: 426 Running threads: 1 Questions: 11082 Reloads: 1 Open tables: 12 The Open tables value of 12 can be somewhat puzzling if you have fewer than 12 tables.
https://dev.mysql.com/doc/refman/8.4/en/trigger-syntax.html
To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER Statement”. Here is a simple example that associates a ...
https://dev.mysql.com/doc/refman/8.4/en/what-is-mysql.html
MySQL, the most popular Open Source SQL database management system, is developed, distributed, and supported by Oracle Corporation. The MySQL website (http://www.mysql.com/) provides the latest information about MySQL software. It may be anything ...
https://dev.mysql.com/doc/refman/8.4/en/where-optimization.html
This section discusses optimizations that can be made for processing WHERE clauses. The examples use SELECT statements, but the same optimizations apply for WHERE clauses in DELETE and UPDATE statements. Note Because work on the MySQL optimizer is ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-api.html
ArbitrationDelay: When asked to arbitrate, arbitrator waits this many milliseconds before voting. AutoReconnect: Specifies whether an API node should reconnect fully when disconnected from cluster. ConnectBackoffMaxTime: Specifies longest time in ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-mgmd.html
ArbitrationDelay: When asked to arbitrate, arbitrator waits this long before voting (milliseconds). ExtraSendBufferMemory: Memory to use for send buffers in addition to any allocated by TotalSendBufferMemory or SendBufferMemory.
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-other.html
AllowUnresolvedHostNames: When false (default), failure by management node to resolve host name results in fatal error; when true, unresolved host names are reported as warnings only. Checksum: If checksum is enabled, all signals between nodes are ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-create-cluster.html
create cluster {--package=|-P }package_name {--processhosts=|-R }process_host_list cluster_name [(--import|-m) cluster_name] [--verbose | -v] process_host_list: process_name[:node_id]@host[,process_name@host[,...]] process_name: ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-list-packages.html
The output contains three columns; these are described in the following list: Package. This can sometimes be empty when a package includes MySQL NDB Cluster installations that are in different locations on different hosts (see next example). The ...