Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data.html
mysql> CALL sys.HEATWAVE_LOAD( '[{"db_name": "db_1", "tables": [{ "table_name": "table_1", "engine_attribute": { "file": [{"uri": "oci://bucket_1@tenant_1/data_file_1.csv"}] } }] }]', NULL); While you can specify all parameters in one command, it ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/setting-up-innodb-cluster-and-mysql-router.html
AdminAPI has built-in functionality for creating sandbox instances that are pre-configured to work with InnoDB Cluster, InnoDB ClusterSet, and InnoDB ReplicaSet in a locally deployed scenario. This example contains the following sections: ... In the ...
https://dev.mysql.com/doc/heatwave/en/heatwave-errors.html
Description: This error indicates issues such as memory limits, data type range violations, or interruption of the query by the user. Error number: 1042; Symbol: HW_ER_TOPK_QKRN_CREATION Message: Error - failed to process the sort operation with ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-tips.html
If you prevent the .mysql_history file from being created (see Controlling the History File) and use --histignore="*" to start the mysql client, the interactive history recall facility is disabled fully. The Windows installer creates an item in the ... This section provides information about techniques for more effective use of mysql and about mysql operational ...
https://dev.mysql.com/doc/refman/8.4/en/repair-table.html
EXTENDED If you use the EXTENDED option, MySQL creates the index row by row instead of creating one index at a time with sorting. This option tells MySQL not to trust the information in the .MYI file header and to re-create it using information from ...[QUICK] [EXTENDED] [USE_FRM] REPAIR TABLE repairs a possibly corrupted table, for certain storage engines ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-system-tables.html
The first index is GEN_CLUST_INDEX, which is a clustered index created by InnoDB if the table does not have a user-defined clustered index. There are six columns, three of which are hidden columns created by InnoDB (DB_ROW_ID, DB_TRX_ID, and ... You ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-row-format.html
Records in the clustered index contain fields for all user-defined columns. Records in the clustered index contain fields for all user-defined columns. When a table is created with ROW_FORMAT=DYNAMIC, InnoDB can store long variable-length column ...
https://dev.mysql.com/doc/refman/8.4/en/expressions.html
This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in expressions. Expression Syntax Expression Term Notes Temporal Intervals Expression Syntax The ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-auto-increment-handling.html
InnoDB follows the same procedure when initializing the auto-increment counter for a newly created table that has a user-specified auto-increment value greater than 0. To make this clear, consider an example that uses this table: CREATE TABLE t1 ( ... InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL statements that add rows to tables with AUTO_INCREMENT ...
https://dev.mysql.com/doc/refman/8.4/en/lock-instance-for-backup.html
LOCK INSTANCE FOR BACKUP permits DDL operations that only affect user-created temporary tables. In effect, files that belong to user-created temporary tables can be created, renamed, or removed while a backup lock is held. The BACKUP_ADMIN privilege ... LOCK INSTANCE FOR BACKUP UNLOCK INSTANCE LOCK INSTANCE FOR BACKUP acquires an instance-level backup lock that permits DML during an online backup while preventing operations that could result in an inconsistent ...