Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-fulltext-index.html
mysql> CREATE TABLE opening_lines ( FTS_DOC_ID BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, opening_line TEXT(500), author VARCHAR(200), title VARCHAR(200) ) ENGINE=InnoDB; If you choose to define the FTS_DOC_ID column yourself, you are ...
https://dev.mysql.com/doc/refman/8.4/en/json-creation-functions.html
mysql> SELECT JSON_ARRAY(1, "abc", NULL, TRUE, CURTIME()); +---------------------------------------------+ | JSON_ARRAY(1, "abc", NULL, TRUE, CURTIME()) | +---------------------------------------------+ | [1, "abc", null, true, "11:30:24.000000"] | ... The functions listed in this section compose JSON values from component ...
https://dev.mysql.com/doc/refman/8.4/en/json-utility-functions.html
The key and the value of an object member are separated by a colon followed by a space (': '). Special characters in string scalars and key names are escaped employing the same rules used by the JSON_QUOTE() function. This section documents utility ...
https://dev.mysql.com/doc/refman/8.4/en/limit-optimization.html
In this case, as we can see from the EXPLAIN output, it uses the table's primary key. row *************************** id: 1 select_type: SIMPLE table: t partitions: NULL type: range possible_keys: i key: i key_len: 8 ref: NULL rows: 14 filtered: ...
https://dev.mysql.com/doc/refman/8.4/en/merge-storage-engine.html
There it is indexed but not as a PRIMARY KEY because a MERGE table cannot enforce uniqueness over the set of underlying tables. The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be ...
https://dev.mysql.com/doc/refman/8.4/en/myisampack.html
When the table is used later, the server reads into memory the information needed to decompress columns. This results in much better performance when accessing individual rows, because you only have to uncompress exactly one row. MySQL uses mmap() ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-unsupported.html
A number of features supported by other storage engines are not supported for NDB tables. Trying to use any of these features in NDB Cluster does not cause errors in or of itself; however, errors may occur in applications that expects the features ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-counters.html
A primary-key read counts as one operation, as does a primary-key update. LOCAL_WRITES and LOCAL_READS are primary-key operations using a transaction coordinator in a node that also holds the primary fragment replica of the record. The counters ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-import.html
--ai-increment=# Command-Line Format --ai-increment=# Type Integer Default Value 1 Minimum Value 1 Maximum Value 4294967295 For a table with a hidden primary key, specify the autoincrement increment, like the auto_increment_increment system variable ... ndb_import imports CSV-formatted data, such as that produced by mysqldump --tab, directly into NDB using the NDB ...
https://dev.mysql.com/doc/refman/8.4/en/nonpersistible-system-variables.html
To use X.509, clients must specify the --ssl-key and --ssl-cert options to connect. SET PERSIST and SET PERSIST_ONLY enable global system variables to be persisted to the mysqld-auto.cnf option file in the data directory (see Section 15.7.6.1, ...