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-cmp-table.html
Pages are compressed whenever an empty page is created or the space for the uncompressed modification log runs out. The INNODB_CMP and INNODB_CMP_RESET tables provide status information on operations related to compressed InnoDB tables. The ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-default-stopword-table.html
The INNODB_FT_DEFAULT_STOPWORD table holds a list of stopwords that are used by default when creating a FULLTEXT index on InnoDB tables. This is not used if you override the default stopword processing with either the ...For information about the ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-index-cache-table.html
The INNODB_FT_INDEX_CACHE table provides token information about newly inserted rows in a FULLTEXT index. Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that ...
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-sys-datafiles-table.html
If a file-per-table tablespace is created in a location outside the MySQL data directory, the path value is a fully qualified directory path. The INNODB_SYS_DATAFILES table provides data file path information for InnoDB file-per-table and general ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-trx-table.html
These IDs are not created for transactions that are read only and nonlocking. The INNODB_TRX table provides information about every transaction currently executing inside InnoDB, including whether the transaction is waiting for a lock, when the ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-ndb-transid-mysql-connection-map-table.html
For this table to be created, the MySQL Server must be a binary supplied with the NDB Cluster distribution, or one built from the NDB Cluster sources with NDB storage engine support enabled. The ndb_transid_mysql_connection_map table provides a ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-group-state-table.html
This is where most threads end up when the thread group has created more threads than needed for normal operation. The TP_THREAD_GROUP_STATE table has one row per thread group in the thread pool. Each row provides information about the current ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-adaptive-hash.html
If there are numerous threads waiting on rw-latches created in btr0sea.c, consider increasing the number of adaptive hash index partitions or disabling the adaptive hash index. The adaptive hash index enables InnoDB to perform more like an ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-benefits.html
You can create and drop indexes and perform other DDL operations with much less impact on performance and availability. InnoDB tables have the following benefits: If the server unexpectedly exits because of a hardware or software issue, regardless ...