Search Results
https://dev.mysql.com/doc/refman/8.4/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. For information about the default InnoDB stopword list and how to define your own stopword lists, see Section ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tables-table.html
For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_TABLES table has these columns: TABLE_ID An identifier for the InnoDB table. NAME The name of the table, preceded by ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-trx-table.html
The INNODB_TRX table provides information about every transaction currently executing inside InnoDB, including whether the transaction is waiting for a lock, when the transaction started, and the SQL statement the transaction is executing, if any.
https://dev.mysql.com/doc/refman/8.4/en/information-schema-mysql-firewall-users-table.html
The MYSQL_FIREWALL_USERS table provides a view into the in-memory data cache for MySQL Enterprise Firewall. It lists names and operational modes of registered firewall account profiles. It is used in conjunction with the mysql.firewall_users system ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-plugins-table.html
The PLUGINS table has these columns: PLUGIN_NAME The name used to refer to the plugin in statements such as INSTALL PLUGIN and UNINSTALL PLUGIN. PLUGIN_STATUS The plugin status, one of ACTIVE, INACTIVE, DISABLED, DELETING, or DELETED. PLUGIN_TYPE ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-schemata-table.html
A schema is a database, so the SCHEMATA table provides information about databases. The SCHEMATA table has these columns: CATALOG_NAME The name of the catalog to which the schema belongs. The following statements are equivalent: SELECT SCHEMA_NAME ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-st-spatial-reference-systems-table.html
The ST_SPATIAL_REFERENCE_SYSTEMS table provides information about available spatial reference systems (SRSs) for spatial data. Entries in the ST_SPATIAL_REFERENCE_SYSTEMS table are based on the European Petroleum Survey Group (EPSG) data set, ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-triggers-table.html
To see information about a table's triggers, you must have the TRIGGER privilege for the table. The TRIGGERS table has these columns: TRIGGER_CATALOG The name of the catalog to which the trigger belongs. TRIGGER_SCHEMA The name of the schema ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-analyze-table-complexity.html
ANALYZE TABLE complexity for InnoDB tables is dependent on: The number of pages sampled, as defined by innodb_stats_persistent_sample_pages. The number of indexed columns in a table The number of partitions. If a table has no partitions, the number ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-and-mysql-replication.html
It is possible to use replication in a way where the storage engine on the replica is not the same as the storage engine on the source. For example, you can replicate modifications to an InnoDB table on the source to a MyISAM table on the replica.