PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-index-table-table.html
The INNODB_FT_INDEX_TABLE table provides information about the inverted index used to process text searches against the FULLTEXT index of an InnoDB table. Before querying it, set the value of the innodb_ft_aux_table system variable to the name ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-temp-table-info-table.html
Example mysql> CREATE TEMPORARY TABLE t1 (c1 INT PRIMARY KEY) ENGINE=INNODB; mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_TEMP_TABLE_INFO\G *************************** 1. The INNODB_TEMP_TABLE_INFO table provides information about user-created ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-group-state-table.html
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. The TP_THREAD_GROUP_STATE table has these columns: TP_GROUP_ID The thread group ID. There is at most ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-group-stats-table.html
The TP_THREAD_GROUP_STATS table has these columns: TP_GROUP_ID The thread group ID. This number is incremented when a statement starts executing, not when it finishes. QUERIES_QUEUED The number of statements received that were queued for execution.
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-state-table.html
TP_GROUP_ID and TP_THREAD_NUMBER together provide a unique key within the table. The TP_THREAD_STATE table has one row per thread created by the thread pool to handle connections. The TP_THREAD_STATE table has these columns: TP_GROUP_ID The thread ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-adaptive-hash.html
Based on the observed pattern of searches, a hash index is built using a prefix of the index key. The adaptive hash index enables InnoDB to perform more like an in-memory database on systems with appropriate combinations of workload and sufficient ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-backup.html
The key to safe database management is making regular backups. Hot and cold backups are physical backups that copy actual data files, which can be used directly by the mysqld server for faster restore. Using MySQL Enterprise Backup is the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-background.html
The compressed page size is specified through the CREATE TABLE or ALTER TABLE KEY_BLOCK_SIZE parameter. The level of compression is the same regardless of the KEY_BLOCK_SIZE value. As you specify smaller values for KEY_BLOCK_SIZE, you get the I/O ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-tuning-monitoring.html
The INNODB_CMP table reports information about compression activity for each compressed page size (KEY_BLOCK_SIZE) in use. The key statistics to consider are the number of, and amount of time spent performing, compression and uncompression ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-error-handling.html
A duplicate-key error rolls back the SQL statement, if you have not specified the IGNORE option in your statement. InnoDB sometimes rolls back only the statement that failed, other times it rolls back the entire transaction. If you run out of file ...