Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-nutshell.html
To clear the host cache, issue TRUNCATE TABLE performance_schema.host_cache or mysqladmin flush-hosts. This section summarizes what has been added to, deprecated in, changed, and removed from MySQL 8.4 since MySQL 8.0. A companion section lists ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump.html
While a --single-transaction dump is in process, to ensure a valid dump file (correct table contents and binary log coordinates), no other connection should use the following statements: ALTER TABLE, CREATE TABLE, DROP TABLE, RENAME TABLE, TRUNCATE ... The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-logging.html
If you specify a value for innodb_log_write_ahead_size that is larger than the innodb_page_size value, the innodb_log_write_ahead_size setting is truncated to the innodb_page_size value. Consider the following guidelines for optimizing redo ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations.html
ANALYZE, CHECK, OPTIMIZE, REPAIR, and TRUNCATE operations are supported with subpartitions. This section discusses current restrictions and limitations on MySQL partitioning support. The following constructs are not permitted in partitioning ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management.html
There are a number of ways using SQL statements to modify partitioned tables; it is possible to add, drop, redefine, merge, or split existing partitions using the partitioning extensions to the ALTER TABLE statement. There are also ways to obtain ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-accounts-table.html
For a description of how the Performance Schema maintains rows in this table, including the effect of TRUNCATE TABLE, see Section 29.12.8, “Performance Schema Connection Tables”. The accounts table contains a row for each account that has ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-clone-progress-table.html
The clone_progress table shows progress information for the current or last executed cloning operation only. The stages of a cloning operation include DROP DATA, FILE COPY, PAGE_COPY, REDO_COPY, FILE_SYNC, RESTART, and RECOVERY. The table therefore ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-clone-status-table.html
The clone_status table shows the status of the current or last executed cloning operation only. The table only ever contains one row of data, or is empty. The clone_status table has these columns: ID A unique cloning operation identifier in the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-cond-instances-table.html
The cond_instances table has these indexes: Primary key on (OBJECT_INSTANCE_BEGIN) Index on (NAME) TRUNCATE TABLE is not permitted for the cond_instances table. The cond_instances table lists all the conditions seen by the Performance Schema while ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-data-lock-waits-table.html
The data_lock_waits table has these indexes: Index on (REQUESTING_ENGINE_LOCK_ID, ENGINE) Index on (BLOCKING_ENGINE_LOCK_ID, ENGINE) Index on (REQUESTING_ENGINE_TRANSACTION_ID, ENGINE) Index on (BLOCKING_ENGINE_TRANSACTION_ID, ENGINE) Index on ...