Search Results
https://dev.mysql.com/doc/refman/8.4/en/invisible-columns.html
As an illustration of when invisible columns may be useful, suppose that an application uses SELECT * queries to access a table, and must continue to work without modification even if the table is altered to add a new column that the application ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns-range.html
However, the order of the column names in the partitioning column list and the value lists does not have to be the same as the order of the table column definitions in the main part of the CREATE TABLE statement. As with table partitioned by RANGE, ... Range columns partitioning is similar to range partitioning, but enables you to define partitions using ranges based on multiple column ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-system-variables.html
Even when the Performance Schema is disabled, it continues to populate the global_variables, session_variables, global_status, and session_status tables. This occurs as necessary to permit the results for the SHOW VARIABLES and SHOW STATUS ...The ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-how-to-import-onnx.html
Import model as a string: For smaller models, you can copy the encoded string and paste it into a session variable or temporary table column. Import model directly from a table: For larger models, you can load the entire file into a table with the ... This topic describes how to import an external ONNX ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-about-auto-parallel-load.html
Auto Parallel Load is a feature of MySQL HeatWave that automates many of the steps for loading data, which include the following: Excluding schemas, tables, and columns that cannot be loaded. Defining RAPID as the secondary engine for tables that ...Requirements and Privileges for Auto Parallel Load To run Auto Parallel Load in normal mode, the MySQL HeatWave Cluster must be ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-mysql-cluster.html
See Section 25.6.11, “NDB Cluster Disk Data Tables”, for more information. You must also remember to account for any column indexes as follows: Each primary key or hash index created for an NDBCLUSTER table requires 21−25 bytes per record. In ... In the following section, we answer questions that are frequently asked about MySQL NDB Cluster and the NDB storage ...
https://dev.mysql.com/doc/refman/8.4/en/load-data.html
INTO Statement”.) To write data from a table to a file, use SELECT ... To read the file back into a table, use LOAD DATA. If you use LOAD DATA on an empty MyISAM table, all nonunique indexes are created in a separate batch (as for REPAIR TABLE).
https://dev.mysql.com/doc/refman/8.4/en/innodb-auto-increment-handling.html
InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL statements that add rows to tables with AUTO_INCREMENT columns. To use the AUTO_INCREMENT mechanism with an InnoDB table, an ...The ...
https://dev.mysql.com/doc/heatwave/en/heatwave-errors.html
If the issue persists, reload the table and retry the query with use_secondary_engine session variable set to FORCED. Error number: 1010; Symbol: HW_ER_SUBQUERY_TRANSFORM Message: The subquery, [%s], cannot be transformed into a semi-join, anti-join ... The following list contains all current MySQL HeatWave errors in numerical ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-vector-store-load.html
This section describes how to generate vector embeddings for files or folders stored in Object Storage, and load the embeddings into a vector store table. To set up a new vector store using an object URI, perform the following steps: To create the ...If not already done, create an Oracle Cloud Infrastructure (OCI) bucket for storing files that you want to ingest into the vector ...