Search Results
https://dev.mysql.com/doc/refman/8.4/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/8.4/en/information-schema-innodb-tablespaces-brief-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_TABLESPACES_BRIEF table provides space ID, name, path, flag, and space type metadata for ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tablespaces-table.html
SERVER_VERSION The MySQL version that created the tablespace, or the MySQL version into which the tablespace was imported, or the version of the last major MySQL version upgrade. The value can be considered a “creation” marker or “certified” ... The INNODB_TABLESPACES table provides metadata about InnoDB file-per-table, general, and undo ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/en/information-schema-tp-thread-state-table.html
For example, if an application uses this query: SELECT * FROM INFORMATION_SCHEMA.TP_THREAD_STATE; The application should use this query instead: SELECT * FROM performance_schema.tp_thread_state; The TP_THREAD_STATE table has one row per thread ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-best-practices.html
Run the server with the --sql_mode=NO_ENGINE_SUBSTITUTION option to prevent tables from being created with storage engines that you do not want to use. Specify a primary key for every table using the most frequently queried column or columns, or an ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression.html
Using the compression features of InnoDB, you can create tables where the data is stored in compressed form. This section provides information about the InnoDB table compression and InnoDB page compression features. The page compression feature is ...