Search Results
https://dev.mysql.com/doc/refman/8.4/en/monitor-alter-table-performance-schema.html
In order of occurrence, ALTER TABLE stage events include: stage/innodb/alter table (read PK and internal sort): This stage is active when ALTER TABLE is in the reading-primary-key phase. stage/innodb/alter table (merge sort): This stage is repeated ... You can monitor ALTER TABLE progress for InnoDB tables using Performance ...For information about Performance Schema stage event instruments and ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-multiple-buffer-pools.html
When the InnoDB buffer pool is large, many data requests can be satisfied by retrieving from memory. Multiple buffer pool instances are configured using the innodb_buffer_pool_instances configuration option, and you might also adjust the ... For ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/restore.external-tablespaces.html
When a backup contains external InnoDB tablespaces that resided outside of the backed-up server's data directory, you can restore them to locations different from their original ones by updating their path names in the tablespace_tracker file ...
https://dev.mysql.com/doc/refman/8.4/en/sys-innodb-buffer-stats-by-schema.html
These views summarize the information in the INFORMATION_SCHEMA INNODB_BUFFER_PAGE table, grouped by schema. Warning Querying views that access the INNODB_BUFFER_PAGE table can affect performance. The innodb_buffer_stats_by_schema and ...Do not ...
https://dev.mysql.com/doc/refman/8.4/en/sys-innodb-buffer-stats-by-table.html
These views summarize the information in the INFORMATION_SCHEMA INNODB_BUFFER_PAGE table, grouped by schema and table. Warning Querying views that access the INNODB_BUFFER_PAGE table can affect performance. The innodb_buffer_stats_by_table and ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-deadlocks-handling.html
It explains how to organize database operations to minimize deadlocks and the subsequent error handling required in applications. Deadlocks are a classic problem in transactional databases, but they are not dangerous unless they are so frequent that ... This section builds on the conceptual information about deadlocks in Section 17.7.5.2, “Deadlock ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-index-table-table.html
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 contains the FULLTEXT index (for example, test/articles). Before querying it, set the value of the ... The ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-virtual-table.html
The INNODB_VIRTUAL table provides metadata about InnoDB virtual generated columns and columns upon which virtual generated columns are based. CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL, `c` int(11) GENERATED ALWAYS AS ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-truncate-table-reclaim-space.html
To reclaim operating system disk space when truncating an InnoDB table, the table must be stored in its own .ibd file. For a table to be stored in its own .ibd file, innodb_file_per_table must enabled when the table is created. This is in contrast ...When a table is truncated, it is dropped and re-created in a new .ibd file, and the freed space is returned to the operating ...Additionally, there ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-cluster-metric-mysqlserver-clusteractivity-category.html
Lists the InnoDB Cluster Activity metrics and provides a brief description of each. MySQL Server Has Been Restarted To perform useful work, a database server must be up-and-running continuously. Opened Files (Delta) The number of files that have ...