Search Results
https://dev.mysql.com/doc/refman/8.4/en/insert.html
| TABLE table_name | VALUES row_constructor_list } [ON DUPLICATE KEY UPDATE assignment_list] value: {expr | DEFAULT} value_list: value [, value] ... INSERT with an ON DUPLICATE KEY UPDATE clause enables existing rows to be updated if a row to be ...
https://dev.mysql.com/doc/refman/8.4/en/json-attribute-functions.html
The functions in this section return attributes of JSON values. An error occurs if the argument is not a valid JSON document. An empty array, empty object, or scalar value has depth 1. A nonempty array containing only elements of depth 1 or ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-okv-plugin.html
For example: STANDBY_SERVER=host_ip:port_num,host_ip:port_num,host_ip:port_num,host_ip:port_num Ensure that the list of standby servers is kept short, accurate, and up to date, and servers that are no longer valid are removed. For example: ... Note ...
https://dev.mysql.com/doc/refman/8.4/en/lateral-derived-tables.html
A derived table cannot normally refer to (depend on) columns of preceding tables in the same FROM clause. A derived table may be defined as a lateral derived table to specify that such references are permitted. Nonlateral derived tables are ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-table-info.html
If you start the MySQL server with external locking disabled, myisamchk may report an error for a table that is updated while it runs. This may be updated after a table is loaded (or greatly changed) with myisamchk -a. If this is not updated at all, ... To obtain a description of a MyISAM table or statistics about it, use the commands shown ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-disk-data-objects.html
Once table ts_1 has been created as shown, you can perform INSERT, SELECT, UPDATE, and DELETE statements on it just as you would with any other MySQL table. NDB Cluster Disk Data storage is implemented using the following objects: Tablespace: Acts ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbd-definition.html
In setting values for these, it is important to understand how DataMemory is used, as it usually needs to be updated to reflect actual usage by the cluster. The entire amount specified by this value is allocated in memory, so it is extremely ... The ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-dict-obj-tree.html
The dict_obj_tree table provides a tree-based view of table information from the dict_obj_info table. This is intended primarily for use in testing, but can be useful in visualizing hierarchies of NDB database objects. This means that you must know ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-tls.html
NDB Transporter connections secured by TLS use TLS mutual authentication, in which each node validates the certificate of its peer. A node's own certificate file contains the entire chain of trust it uses to validate the certificates of its peers. A ... This section discusses the implementation and use of Transport Layer Security (TLS) to secure network communications in MySQL NDB ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-nutshell.html
When this feature is enabled for a given histogram, it is updated whenever ANALYZE TABLE is run on the table to which it belongs. In addition, automatic recalculation of persistent statistics by InnoDB (see Section 17.8.10.1, “Configuring ... This ...