Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-supported-file-formats.html
Parquet File Format Review the following about Parquet files: Parquet Types Lakehouse Limitations for the Parquet File Format As of MySQL 9.5.0, you can choose how to map columns from Parquet files to external tables by setting the match_columns_by ... Review the various file formats supported for loading structured, semi-structured, and unstructured data in MySQL HeatWave from different ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-digests.html
In this case, the difference in the second column name is lost and both statements are considered the same. The statement event tables (events_statements_current, events_statements_history, and events_statements_history_long) have columns for ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-source.html
auto_increment_increment and auto_increment_offset affect AUTO_INCREMENT column behavior as follows: auto_increment_increment controls the interval between successive column values. The highest value present in the col column prior to the INSERT is ... This section describes the server options and system variables that you can use on replication source ...
https://dev.mysql.com/doc/refman/8.4/en/trigger-syntax.html
(Such a SET statement has no effect in an AFTER trigger because the row change has already occurred.) In a BEFORE trigger, the NEW value for an AUTO_INCREMENT column is 0, not the sequence number that is generated automatically when the new row ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-data-locks-table.html
The Performance Schema collects information that is already available in the server, so there is no memory or CPU overhead to generate this information or need for parameters that control its collection. The data_locks table has these columns: ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-statements-current-table.html
The events_statements_current table has these columns: THREAD_ID, EVENT_ID The thread associated with the event and the thread current event number when the event starts. END_EVENT_ID This column is set to NULL when the event starts and updated to ...The table stores one row per thread showing the current status of the thread's most recent monitored statement event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-examples.html
For NDB tables, it is also possible to change the storage type used for a table or column. row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ...For MyISAM ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-fulltext-index.html
Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those columns. When a full-text index is dropped, the FTS_DOC_ID column that was created for the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-debugging-queries.html
If the query is supported by MySQL HeatWave, the Extra column in the EXPLAIN output shows the following text: Using secondary engine RAPID; otherwise, that text does not appear. For MySQL HeatWave on OCI, see Generating a Node Count Estimate in the ... This topic describes how to debug queries that fail to offload to MySQL HeatWave for ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-model-import.html
The table to import should have the following columns, and their recommended parameters: chunk_id: INT AUTO_INCREMENT PRIMARY KEY model_object: LONGTEXT NOT NULL model_metadata: JSON DEFAULT NULL See Model Metadata. Use the ML_MODEL_IMPORT routine ...