Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-modifying-tables.html
When an InnoDB table is loaded into MySQL HeatWave Cluster, DDL operations such as ALTER TABLE, RENAME TABLE, TRUNCATE TABLE, and DROP TABLE are permitted. While any of these operations are being executed, queries involving the modified table are ...If you are explicitly trying to use the secondary engine, these queries generate an offload ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-progress-reporting.html
The following sys schema views provide progress reporting for long-running transactions: processlist session x$processlist x$session Assuming that the required instruments and consumers are enabled, the progress column of these views shows the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-troubleshooting-datadict.html
mysql> ALTER TABLE sakila.actor DISCARD TABLESPACE; Copy the orphan .ibd file from your backup directory to the new database directory. Information about table definitions is stored in the InnoDB data dictionary. Cannot Open Datafile With ...If you ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-sets.html
utf8mb3 is also displayed in place of utf8 in columns of Information Schema tables, and in the output of SQL SHOW statements. To determine the pad attribute for a collation, use the INFORMATION_SCHEMA COLLATIONS table, which has a PAD_ATTRIBUTE ...
https://dev.mysql.com/doc/refman/8.4/en/forcing-innodb-recovery.html
If you encounter a runaway rollback caused by a failing mass import or ALTER TABLE, you can kill the mysqld process and set innodb_force_recovery to 3 to bring the database up without the rollback, and then DROP the table that is causing the runaway ... To investigate database page corruption, you might dump your tables from the database with SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-consistent-read.html
Consistent read does not work over ALTER TABLE operations that make a temporary copy of the original table and delete the original table when the temporary copy is built. This exception causes the following anomaly: If you update some rows in a ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-start.html
myisam_max_sort_file_size The maximum size of the temporary file that MySQL is permitted to use while re-creating a MyISAM index (during REPAIR TABLE, ALTER TABLE, or LOAD DATA). The following options to mysqld can be used to change the behavior of ...bulk_insert_buffer_size The size of the tree cache used in bulk insert ...
https://dev.mysql.com/doc/refman/8.4/en/temporary-files.html
The optional EXTENDED modifier causes SHOW TABLES to list hidden tables created by failed ALTER TABLE statements. The maximum disk space required is determined by the following expression: (length of what is sorted + sizeof(row pointer)) * number of ... On Unix, MySQL uses the value of the TMPDIR environment variable as the path name of the directory in which to store temporary ...
https://dev.mysql.com/doc/refman/8.4/en/drop-index.html
This statement is mapped to an ALTER TABLE statement to drop the index. They have the same meaning as for the ALTER TABLE statement. For more information, see Section 15.1.9, “ALTER TABLE Statement” MySQL NDB Cluster supports online operations ...algorithm_option: ALGORITHM [=] {DEFAULT | INPLACE | COPY} lock_option: LOCK [=] {DEFAULT | NONE | SHARED | EXCLUSIVE} DROP INDEX drops the index named index_name from the table ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-defining-secondary-engine.html
Then, the MySQL HeatWave query processing engine (RAPID) is set as the secondary engine for the table, using ALTER TABLE statement. Defining Secondary Engine For each table that you want to load into MySQL HeatWave Cluster, you must define the MySQL ...