PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/internal-locking.html
To avoid deadlocks when performing multiple concurrent write operations on a single InnoDB table, acquire necessary locks at the start of the transaction by issuing a SELECT ... This ensures that updates to a table are not “starved” even when ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-okv-plugin.html
Example (using the SQL interface): SELECT keyring_key_generate('MyKey', 'AES', 32); SELECT keyring_key_remove('MyKey'); For information about the characteristics of key values permitted by keyring_okv, Section 6.4.4.6, “Supported Keyring Key Types ... Note The keyring_okv plugin is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-example-data.html
Running SELECT queries on the SQL node is no different from running them on any other instance of a MySQL server. mysqli_connect_error()); $query = "SELECT Name, Population FROM City ORDER BY Population DESC LIMIT 5"; # if no errors... Note The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-blob-tool.html
--ndb-optimized-node-selection Command-Line Format --ndb-optimized-node-selection Enable optimizations for selection of nodes for transactions. This tool can be used to check for and remove orphaned BLOB column parts from NDB tables, as well as to ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-config.html
--ndb-optimized-node-selection Command-Line Format --ndb-optimized-node-selection Enable optimizations for selection of nodes for transactions. This tool extracts current configuration information for data nodes, SQL nodes, and API nodes from one ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-delete-all.html
--ndb-optimized-node-selection Command-Line Format --ndb-optimized-node-selection Enable optimizations for selection of nodes for transactions. In some cases, this can be much faster than DELETE or even TRUNCATE TABLE. Usage ndb_delete_all -c ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-drop-table.html
--ndb-optimized-node-selection Command-Line Format --ndb-optimized-node-selection Enable optimizations for selection of nodes for transactions. Usage ndb_drop_table -c connection_string tbl_name -d db_name Options that can be used with ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-index-stat.html
--ndb-optimized-node-selection Command-Line Format --ndb-optimized-node-selection Enable optimizations for selection of nodes for transactions. ndb_index_stat provides per-fragment statistical information about indexes on NDB tables. This includes ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-mgm.html
--ndb-optimized-node-selection Command-Line Format --ndb-optimized-node-selection Enable optimizations for selection of nodes for transactions. The ndb_mgm management client process is actually not needed to run the cluster. Its value lies in ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-mgmd.html
--ndb-optimized-node-selection Command-Line Format --ndb-optimized-node-selection Enable optimizations for selection of nodes for transactions. The management server is the process that reads the cluster configuration file and distributes this ...