Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-create-table-manually-task.html
If you choose not to Create an External Table Using Lakehouse Auto Parallel Load, you can create the table manually. Create External Table Manually Example To demonstrate how to create an external table manually, the following example specifies a ...To use this file, visit Bank Marketing and download the bank+marketing.zip ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-schema.html
Stage Event tables, which store event data for InnoDB ALTER TABLE and buffer pool load operations. For more information, see Section 17.16.1, “Monitoring ALTER TABLE Progress for InnoDB Tables Using Performance Schema”, and Monitoring Buffer ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-selection.html
This option always follows the name of the table to which the partition or partitions belong. Each name in this list must be the name of an existing partition or subpartition of the specified table; if any of the partitions or subpartitions are not ... Explicit selection of partitions and subpartitions for rows matching a given WHERE condition is ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-data-load-prerequisites.html
You can manually convert tables by using the following ALTER TABLE statement: mysql> ALTER TABLE tbl_name ENGINE=InnoDB; The tables you intend to load must be defined with a primary key. You can add a primary key using the following syntax: mysql> ...Prepare Data Before loading data, ensure that you meet the following requirements: The tables you intend to load must be set to ENGINE=InnoDB ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-airportdb-quickstart.html
This quickstart contains the following sections: AirportDB Requirements Download AirportDB Data Load AirportDB into DB system Load AirportDB into MySQL HeatWave Cluster Run AirportDB Queries Additional AirportDB Queries Unload AirportDB Tables ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-info.html
Methods of obtaining such information include the following: Using the SHOW CREATE TABLE statement to view the partitioning clauses used in creating a partitioned table. Using the SHOW TABLE STATUS statement to determine whether a table is ... This ...
https://dev.mysql.com/doc/refman/8.4/en/replica-logs-status.html
The connection metadata repository is written to the slave_master_info table in the mysql system schema, and the applier metadata repository is written to the slave_relay_log_info table in the mysql system schema. A warning message is issued if ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-import.html
db_name is the name of the database where the table into which to import the data is found; file_name is the name of the CSV file from which to read the data; this must include the path to this file if it is not in the current directory. The name of ... ndb_import imports CSV-formatted data, such as that produced by mysqldump --tab, directly into NDB using the NDB ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/performance-advisors-ref.html
These features also require the use of the ROW_FORMAT=[DYNAMIC|COMPRESSED] in CREATE TABLE and ALTER TABLE statements. This advisor has no configurable thresholds and is used to populate the graphs and tables of the Database File I/O report. For ...
https://dev.mysql.com/doc/refman/8.4/en/invisible-indexes.html
ALTER INDEX operation: ALTER TABLE t1 ALTER INDEX i_idx INVISIBLE; ALTER TABLE t1 ALTER INDEX i_idx VISIBLE; Information about whether an index is visible or invisible is available from the Information Schema STATISTICS table or SHOW INDEX output.