PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-statistics-table.html
If the index is the primary key, the name is always PRIMARY. The STATISTICS table has these columns: TABLE_CATALOG The name of the catalog to which the table containing the index belongs. TABLE_SCHEMA The name of the schema (database) to which the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-change-buffer.html
Change buffering is not supported for a secondary index if the index contains a descending index column or if the primary key includes a descending index column. Configuring Change Buffering When INSERT, UPDATE, and DELETE operations are performed ... The change buffer is a special data structure that caches changes to secondary index pages when those pages are not in the buffer ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-usage.html
After the innodb_file_per_table and innodb_file_format options are configured, specify the ROW_FORMAT=COMPRESSED clause or KEY_BLOCK_SIZE clause, or both, in a CREATE TABLE or ALTER TABLE statement to create a compressed table in a file-per-table ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-fulltext_index-tables.html
mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_CONFIG; +---------------------------+-------+ | KEY | VALUE | +---------------------------+-------+ | optimize_checkpoint_limit | 180 | | synced_doc_id | 8 | | stopword_table_name | | | use_stopword ...INNODB_FT_BEING_DELETED: Provides a snapshot of the INNODB_FT_DELETED table; it is used only during an OPTIMIZE TABLE maintenance ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-temp-table-info.html
Create a simple InnoDB temporary table: mysql> CREATE TEMPORARY TABLE t1 (c1 INT PRIMARY KEY) ENGINE=INNODB; Query INNODB_TEMP_TABLE_INFO to view the temporary table metadata. mysql> CREATE TEMPORARY TABLE t1 (c1 INT PRIMARY KEY) ENGINE=INNODB; ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-intro.html
You can map multiple columns into the “value” part of the key-value store, with column values delimited by a user-specified separator character. For example, you can change the port that memcached listens on, reduce the maximum number of ... The ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html
Information about table definitions is stored both in the .frm files, and in the InnoDB data dictionary. If you move .frm files around, or if the server crashes in the middle of a data dictionary operation, these sources of information can become ...
https://dev.mysql.com/doc/refman/5.7/en/join.html
index_hint: { USE {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] ([index_list]) | {IGNORE|FORCE} {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] (index_list) } index_list: index_name [, index_name] ... MySQL supports the following JOIN syntax for the ...
https://dev.mysql.com/doc/refman/5.7/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. row *************************** ... This section documents utility functions that act on JSON values, or strings that can be parsed as JSON ...
https://dev.mysql.com/doc/refman/5.7/en/lock-tables.html
Locking MyISAM tables speeds up inserting, updating, or deleting on them because MySQL does not flush the key cache for the locked tables until UNLOCK TABLES is called. LOCK {TABLE | TABLES} tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] ...