Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-columns.html
These two statements are equivalent: SHOW COLUMNS FROM mytable FROM mydb; SHOW COLUMNS FROM mydb.mytable; The optional EXTENDED keyword causes the output to include information about hidden columns that MySQL uses internally and are not accessible ... SHOW [EXTENDED] [FULL] {COLUMNS | FIELDS} {FROM | IN} tbl_name [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW COLUMNS displays information about the columns in a given ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.usage.html
--encrypt-password The user-supplied password by which mysqlbackup encrypts the encryption keys for encrypted InnoDB tablespaces. --key-file The pathname of a file that contains the symmetric key used for encryption and decryption. The following ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-ml-train.html
At least one column must act as the primary key to establish the temporal order of logs. If the primary key column (or columns) is not one of the previous required columns (log data, source of log, or label), then you must use the ... Run the ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-ssl-wizard.html
Generate new certificates and self-signed keys: Check this to generate new files, otherwise the existing files are used. For example: [client] ssl-ca=C:\certs\ca-cert.pem ssl-cert=C:\certs\client-cert.pem ssl-key=C:\certs\client-key.pem [mysqld] ...
https://dev.mysql.com/doc/internals/en/getting-index-information.html
The table index information is contained within the key_info structure of the TABLE argument of the create() method. The key parts define the field associated with the key part, whether the key should be packed, and the data type and length of the ... It is preferable for storage engines that support indexing to read the index information provided during a CREATE TABLE operation and store it for future ...
https://dev.mysql.com/doc/internals/en/implementing-records-in-range-method.html
It is defined as follows: ha_rows ha_foo::records_in_range(uint inx, key_range *min_key, key_range *max_key) The inx parameter is the index to be checked. The *min_key and *max_key parameters are key_range structures that indicate the low and high ... The [custom-engine.html#custom-engine-api-reference-records_in_range records_in_range()] method is called by the optimizer to assist in choosing which index on a table to use for a query or ...
https://dev.mysql.com/doc/ndbapi/en/overview-operations.html
In the case where multiple primary key accesses are sent in one batch, those accesses share the cost of setting up the necessary TCP/IP messages and context switches. Unique key accesses are similar to primary key accesses, except that a unique key ... An NdbTransaction consists of a list of operations, each of which is represented by an instance of NdbOperation, NdbScanOperation, NdbIndexOperation, or NdbIndexScanOperation (that is, of NdbOperation or one of its child ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-tde.html
The secrets file contains a Node Master Key (NMK), a key used later to encrypt the different file types used for persistence. cac256e18b2ddf6b5ef82d99a72f18e864b78453cc7fa40bfaf0c40b91122d18 The per-node key hierarchy can be represented as follows: ... The following sections provide information about NDB data node file system ...
https://dev.mysql.com/doc/refman/8.4/en/structured-system-variables.html
MySQL supports one structured variable type, which specifies parameters governing the operation of key caches. A key cache structured variable has these components: key_buffer_size key_cache_block_size key_cache_division_limit ... A structured ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-columns-tab.html
Delete Selected Columns: Select multiple contiguous columns by right-clicking and pressing the Shift key. PK: PRIMARY KEY NN: NOT NULL UQ: UNIQUE INDEX BIN: BINARY UN: UNSIGNED ZF: ZEROFILL AI: AUTO_INCREMENT G: Generated Column This option is ...