Search Results
https://dev.mysql.com/doc/refman/8.4/en/document-store-concepts.html
JSON Document Collection CRUD Operations JSON Document A JSON document is a data structure composed of key-value pairs and is the fundamental structure for using MySQL as document store. Mogae", "GovernmentForm": "Republic" }, "demographics": { ...
https://dev.mysql.com/doc/refman/8.4/en/grant-tables.html
The attribute value is an array of elements that each have Database and Restrictions keys indicating the name of a restricted database and the applicable restrictions on it (see Section 8.2.12, “Privilege Restriction Using Partial Revokes”). The ... The mysql system database includes several grant tables that contain information about user accounts and the privileges held by ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-config-table.html
The INNODB_FT_CONFIG table has these columns: KEY The name designating an item of metadata for an InnoDB table containing a FULLTEXT index. The key names and their meanings include: optimize_checkpoint_limit: The number of seconds after which an ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-partitions-table.html
PARTITION_METHOD One of the values RANGE, LIST, HASH, LINEAR HASH, KEY, or LINEAR KEY; that is, one of the available partitioning types as discussed in Section 26.2, “Partitioning Types”. SUBPARTITION_METHOD One of the values HASH, LINEAR HASH, ...Each row in this table corresponds to an individual partition or subpartition of a partitioned ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-transaction-isolation-levels.html
For other search conditions, InnoDB locks the index range scanned, using gap locks or next-key locks to block insertions by other sessions into the gaps covered by the range. For information about gap locks and next-key locks, see Section 17.7.1, ...
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/lock-tables.html
If you lock a table explicitly with LOCK TABLES, any tables related by a foreign key constraint are opened and locked implicitly. For foreign key checks, a shared read-only lock (LOCK TABLES READ) is taken on related tables. Locking MyISAM tables ...
https://dev.mysql.com/doc/refman/8.4/en/metadata-locking.html
Locks might be acquired in a different order for implicitly used tables (such as tables in foreign key relationships that also must be locked). Metadata locks are extended, as necessary, to tables related by a foreign key constraint to prevent ...
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() ...