Search Results
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-genai-byo-embedding-tables.html
OutputTableName: the name of the table where you want to create a new column to store the generated outputs. If the specified table doesn't exist, a new table is created. It allows you to create tables which point to external data sources and ...A ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-conflict-resolution.html
You must create any exceptions table before creating the data table with which it is to be used. Conflict Resolution Exceptions Table To use the NDB$OLD() conflict resolution function, it is also necessary to create an exceptions table corresponding ... Requirements Source Column Control Conflict Resolution Control Conflict Resolution Functions Conflict Resolution Exceptions Table Conflict Detection Status Variables Examples When using a replication setup involving multiple sources (including circular replication), it is possible that different sources may try to update the same row on the replica with different ...
https://dev.mysql.com/doc/refman/8.4/en/check-table.html
With FOR UPGRADE, the server checks each table to determine whether there have been any incompatible changes in any of the table's data types or indexes since the table was created. option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED ...The last row has a Msg_type value of status and the Msg_text normally should be ...
https://dev.mysql.com/doc/refman/8.4/en/general-thread-states.html
After create This occurs when the thread creates a table (including internal temporary tables), at the end of the function that creates the table. This state is used even if the table could not be created due to some error. This state occurs after ...altering table The server is in the process of executing an in-place ALTER ... The following list describes thread State values that are associated with ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-json.html
External tables use table-level and column-level ENGINE_ATTRIBUTE options of the CREATE TABLE statement to specify the parameters needed to process data stored externally in Object Storage. CREATE EXTERNAL TABLE table_name (col_name data_type ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-byo-embedding-tables.html
Create a table that satisfies the following criteria: To qualify as a valid embedding table, the table must contain the following columns: A string column containing the text segments. OutputTableName: the name of the table where you want to create ... As of MySQL 9.2.1, MySQL HeatWave GenAI lets you use tables containing your own vector embedding to run retrieval-augemented generation (RAG) with vector ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbd-definition.html
(NDB 8.4.0) This parameter specifies the directory where all files created for metadata, REDO logs, UNDO logs (for Disk Data tables), and data files are placed. Consider this table definition: CREATE TABLE example ( a INT NOT NULL, b INT NOT NULL, c ...Information about configuration parameters specific to NDB Cluster Disk Data tables can be found later in this section (see Disk Data Configuration ...
https://dev.mysql.com/doc/refman/8.4/en/explain-output.html
Using temporary (JSON property: using_temporary_table) To resolve the query, MySQL needs to create a temporary table to hold the result. EXPLAIN returns a row of information for each table used in the SELECT statement. It lists the tables in the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-options-variables.html
--ndb-default-column-format=[FIXED|DYNAMIC] Command-Line Format --ndb-default-column-format={FIXED|DYNAMIC} System Variable ndb_default_column_format Scope Global Dynamic Yes SET_VAR Hint Applies No Type Enumeration Default Value FIXED Valid Values ...(It is neither necessary nor desirable to use this option together with --initialize.) --ndb-allow-copying-alter-table=[ON|OFF] Command-Line Format --ndb-allow-copying-alter-table[={OFF|ON}] System Variable ndb_allow_copying_alter_table Scope Global, Session Dynamic Yes SET_VAR Hint Applies No Type Boolean Default Value ON Let ALTER TABLE and other DDL statements use copying operations on NDB ...
https://dev.mysql.com/doc/refman/8.4/en/merge-table-problems.html
The following are known problems with MERGE tables: MERGE child tables are locked through the parent table. If the parent is a temporary table, it is not locked, and thus the child tables are also not locked; this means that parallel use of the ...