Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-optimization.html
Applications that monitor databases may make frequent use of INFORMATION_SCHEMA tables. To write queries for these tables most efficiently, use the following general guidelines: Try to query only INFORMATION_SCHEMA tables that are views on data ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locks-set.html
If you have no indexes suitable for your statement and MySQL must scan the entire table to process the statement, every row of the table becomes locked, which in turn blocks all inserts by other users to the table. For example, in a UNION, scanned ... A locking read, an UPDATE, or a DELETE generally set record locks on every index record that is scanned in the processing of an SQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-rag.html
As of MySQL 9.2.1, for context retrieval, the ML_RAG routine uses the name of the embedding model used to embed the input query to find relevant vector store tables that contain vector embeddings from the same embedding model. The examples in this ... The ML_RAG routine runs retrieval-augmented generation which aims to generate more accurate responses for your ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-manually.html
After creating an external table manually and specifying the files to load into the table, you have the option (as of MySQL 9.6.0) to validate a load command before loading data into the external table. This topic contains the following sections: ...As of MySQL 9.6.0, you have the option to validate a load operation before loading ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-page-compression.html
InnoDB supports page-level compression for tables that reside in file-per-table tablespaces. Page compression is enabled by specifying the COMPRESSION attribute with CREATE TABLE or ALTER TABLE. Enabling Page Compression To enable page compression, ...Supported Platforms Page compression requires sparse file and hole punching ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-parallel-load.html
| | Sufficient HeatWave cluster memory available to load all tables. If Auto Parallel Load fails with an error, inspect the errors with a query to the heatwave_autopilot_report table. mysql> SELECT log FROM sys.heatwave_autopilot_report WHERE ...
https://dev.mysql.com/doc/refman/8.4/en/identifier-qualifiers.html
For example, this statement creates a table using the unqualified name t1: CREATE TABLE t1 (i INT); Because t1 includes no qualifier to specify a database, the statement creates the table in the default database. This statement creates a table using ...An unqualified name is permitted in contexts where interpretation of the name is ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-application-error.html
Having a table without primary key uses an autoincremented hidden key, i.e. The following list enumerates all NDB errors of type AE (Application error). NDB error code 5002 MySQL error DMEC Error message The process has wrong type. NDB error code ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-train-in-isolated-environment.html
In contrast, the ML_PREDICT_TABLE and ML_PREDICT_ROW routines perform inference by applying a pre-trained machine learning model to input data and generate predictions. Group Replication requires that all tables have a primary key, so to ... The ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-overview.html
The SQL language itself is intended to work independently of any data structures or media underlying the schemas, tables, rows, or columns with which it works. Partitioning takes this notion a step further, by enabling you to distribute portions of ... This section provides a conceptual overview of partitioning in MySQL ...