Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-select-count.html
--ndb-optimized-node-selection Command-Line Format --ndb-optimized-node-selection Enable optimizations for selection of nodes for transactions. ndb_select_count prints the number of rows in one or more NDB tables. With a single table, the result is ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-show-tables.html
--ndb-optimized-node-selection Command-Line Format --ndb-optimized-node-selection Enable optimizations for selection of nodes for transactions. ndb_show_tables displays a list of all NDB database objects in the cluster. By default, this includes ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-waiter.html
--ndb-optimized-node-selection Command-Line Format --ndb-optimized-node-selection Enable optimizations for selection of nodes for transactions. ndb_waiter repeatedly (each 100 milliseconds) prints out the status of all cluster data nodes until ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndbd.html
--ndb-optimized-node-selection Command-Line Format --ndb-optimized-node-selection Enable optimizations for selection of nodes for transactions. The ndbd binary provides the single-threaded version of the process that is used to handle all the data ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndbinfo-select-all.html
--ndb-optimized-node-selection Command-Line Format --ndb-optimized-node-selection Enable optimizations for selection of nodes for transactions. ndbinfo_select_all is a client program that selects all rows and columns from one or more tables in the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-tips.html
This enables use of EXPLAIN plus SHOW WARNINGS to see why an index is not used, which can be helpful in cases such as when a range_optimizer_max_mem_size violation or type conversion occurs and the optimizer does not use an index even though a key ... This section provides information about techniques for more effective use of mysql and about mysql operational ...
https://dev.mysql.com/doc/refman/8.4/en/resource-groups.html
MySQL supports creation and management of resource groups, and permits assigning threads running within the server to particular groups so that threads execute according to the resources available to the group. Group attributes enable control over ...
https://dev.mysql.com/doc/refman/8.4/en/searching-on-two-keys.html
An OR using a single key is well optimized, as is the handling of AND. The one tricky case is that of searching on two different keys combined with OR: SELECT field1_index, field2_index FROM test_table WHERE field1_index = '1' OR field2_index = '1' ...You can also solve the problem efficiently by using a UNION that combines the output of two separate SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/update.html
If you use a multiple-table UPDATE statement involving InnoDB tables for which there are foreign key constraints, the MySQL optimizer might process tables in an order that differs from that of their parent/child relationship. UPDATE is a DML ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-bulk-load-mysql-server.html
It can do the following: Optimize the loading of data sorted by primary key. MySQL includes a bulk load extension to the LOAD DATA statement. Stored generated columns can be part of secondary indexes and the primary key. Tables can have a ...