Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-files-table.html
The FILES table provides information about the files in which MySQL tablespace data is stored. In NDB Cluster, this table also provides information about the files in which NDB Cluster Disk Data tables are stored. For additional information ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-buffer-page-table.html
The INNODB_BUFFER_PAGE table provides information about each page in the InnoDB buffer pool. For related usage information and examples, see Section 17.15.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”. Do not query this table on a ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-tables-table.html
The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. If there are no cached statistics or statistics have expired, statistics are retrieved from storage engines when querying table ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-benefits.html
Performance benefits are not limited to large tables with long-running queries. InnoDB tables have the following benefits: If the server unexpectedly exits because of a hardware or software issue, regardless of what was happening in the database at ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-data-encryption.html
This column can be queried to identify tables that reside in encrypted file-per-table tablespaces. InnoDB supports data-at-rest encryption for file-per-table tablespaces, general tablespaces, the mysql system tablespace, redo logs, and undo logs.
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-optimizer-statistics.html
This section describes how to configure persistent and non-persistent optimizer statistics for InnoDB tables. Persistent optimizer statistics are persisted across server restarts, allowing for greater plan stability and more consistent query ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-ro-txn.html
You can still make changes to session-specific temporary tables in a read-only transaction, or issue locking queries for them, because those changes and locks are not visible to any other transaction. InnoDB can avoid the overhead associated with ...
https://dev.mysql.com/doc/refman/8.4/en/invisible-columns.html
An invisible column is normally hidden to queries, but can be accessed if explicitly referenced. As an illustration of when invisible columns may be useful, suppose that an application uses SELECT * queries to access a table, and must continue to ...
https://dev.mysql.com/doc/refman/8.4/en/monitor-alter-table-performance-schema.html
You can monitor ALTER TABLE progress for InnoDB tables using Performance Schema. There are seven stage events that represent different phases of ALTER TABLE. Each stage event reports a running total of WORK_COMPLETED and WORK_ESTIMATED for the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-disk-data-objects.html
NDB Cluster Disk Data storage is implemented using the following objects: Tablespace: Acts as containers for other Disk Data objects. A tablespace contains one or more data files and one or more undo log file groups. Undo log file: Contains undo ...