PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-parameters-table.html
Parameter information is similar to the contents of the param_list column in the mysql.proc table. The PARAMETERS table has these columns: SPECIFIC_CATALOG The name of the catalog to which the routine containing the parameter belongs. The ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-group-state-table.html
The TP_THREAD_GROUP_STATE table has these columns: TP_GROUP_ID The thread group ID. The TP_THREAD_GROUP_STATE table has one row per thread group in the thread pool. Each row provides information about the current state of a group. There is at most ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-state-table.html
The TP_THREAD_STATE table has these columns: TP_GROUP_ID The thread group ID. The xxx_WAIT columns of the TP_THREAD_GROUP_STATS table accumulate counts for each wait type. The TP_THREAD_STATE table has one row per thread created by the thread pool ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-background.html
There is a hard limit on how small KEY_BLOCK_SIZE can be for a table, based on the lengths of the key columns for each of its indexes. For extracting or updating the column values, MySQL also creates an uncompressed page in the buffer pool with the ... Because processors and cache memories have increased in speed more than disk storage devices, many workloads are ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-files-table.html
This query retrieves metadata about the InnoDB system tablespace from columns of the Information Schema FILES table that are pertinent to InnoDB tablespaces. FILES columns that are not relevant to InnoDB always return NULL, and are excluded from the ... The Information Schema FILES table provides metadata about all InnoDB tablespace types including file-per-table tablespaces, general tablespaces, the system tablespace, temporary table tablespaces, and undo tablespaces (if ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-benefits.html
InnoDB can handle composing and decomposing multiple column values into a single memcached item value, reducing the amount of string parsing and concatenation required in your application. For example, you can store the string value 2|4|6|8 in the ...The combination of InnoDB tables and memcached offers advantages over using either by ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-dml.html
key refers to the column listed under key_columns, and val refers to the column listed under value_columns. Benchmarks suggest that the daemon_memcached plugin speeds up DML operations (inserts, updates, and deletes) more than it speeds up queries.
https://dev.mysql.com/doc/refman/5.7/en/innodb-next-key-locking.html
The so-called phantom problem occurs within a transaction when the same query produces different sets of rows at different times. For example, if a SELECT is executed twice, but returns a row the second time that was not returned the first time, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-limitations.html
Tables created before MySQL 5.6 that include temporal columns (DATE, DATETIME or TIMESTAMP) and have not been rebuilt using ALGORITHM=COPY do not support ALGORITHM=INPLACE. The following limitations apply to online DDL operations: The table is ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl.html
These clauses are placed at the end of the statement, separated from the table and column specifications by commas. For example: ALTER TABLE tbl_name ADD PRIMARY KEY (column), ALGORITHM=INPLACE, LOCK=NONE; The LOCK clause is useful for fine-tuning ... The online DDL feature provides support for in-place table alterations and concurrent ...