PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/innodb-auto-increment-handling.html
To make this clear, consider an example that uses this table: CREATE TABLE t1 ( c1 INT(11) NOT NULL AUTO_INCREMENT, c2 VARCHAR(10) DEFAULT NULL, PRIMARY KEY (c1) ) ENGINE=InnoDB; Suppose that there are two transactions running, each inserting rows ... InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL statements that add rows to tables with AUTO_INCREMENT ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-autocommit-commit-rollback.html
$> mysql test mysql> CREATE TABLE customer (a INT, b CHAR (20), INDEX (a)); Query OK, 0 rows affected (0.00 sec) mysql> -- Do a transaction with autocommit turned on. If autocommit mode is enabled, each SQL statement forms a single transaction on ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-compression-tuning.html
Whether to adjust the size of the buffer pool based on run-time performance characteristics, such as the amount of time the system spends compressing and uncompressing data. When to Use Compression In general, compression works best on tables that ... Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-fulltext-index.html
Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those columns. The words are fully sorted and partitioned among the six index tables based on the ...A full-text index is defined as part of a CREATE TABLE statement or added to an existing table using ALTER TABLE or CREATE ...
https://dev.mysql.com/doc/refman/9.7/en/insert.html
Inserting a string into a string column (CHAR, VARCHAR, TEXT, or BLOB) that exceeds the column maximum length. INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name ...
https://dev.mysql.com/doc/refman/9.7/en/internal-temporary-tables.html
Presence of any string column with a maximum length larger than 512 (bytes for binary strings, characters for nonbinary strings) in the SELECT list, if UNION or UNION ALL is used. The TempTable storage engine provides efficient storage for VARCHAR ... In some cases, the server creates internal temporary tables while processing ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/json-search-functions.html
An error occurs if the json_doc argument is not a valid JSON document, any path argument is not a valid path expression, one_or_all is not 'one' or 'all', or escape_char is not a constant expression. Within the search_str search string argument, the ... The functions in this section perform search or comparison operations on JSON values to extract data from them, report whether data exists at a location within them, or report the path to data within ...
https://dev.mysql.com/doc/refman/9.7/en/json-table-functions.html
This section contains information about JSON functions that convert JSON data to tabular data. JSON_TABLE(expr, path COLUMNS (column_list) [AS] alias) Extracts data from a JSON document and returns it as a relational table having the specified ...
https://dev.mysql.com/doc/refman/9.7/en/json.html
MySQL handles strings used in JSON context using the utf8mb4 character set and utf8mb4_bin collation. Strings in other character sets are converted to utf8mb4 as necessary. (For strings in the ascii or utf8mb3 character sets, no conversion is needed ...The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON ...