Search Results
https://dev.mysql.com/doc/refman/8.4/en/explain.html
Obtaining Execution Plan Information The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, UPDATE, and TABLE statements. MySQL 8.4 supports an additional INTO option with ...In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query execution plan (that is, an explanation of how MySQL would execute a ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool.html
When InnoDB reads a page into the buffer pool, it initially inserts it at the midpoint (the head of the old sublist). For efficiency of high-volume read operations, the buffer pool is divided into pages that can potentially hold multiple rows. This ... The buffer pool is an area in main memory where InnoDB caches table and index data as it is ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-rag.html
The ML_RAG routine runs retrieval-augmented generation which aims to generate more accurate responses for your queries. 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 ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-genai-rag.html
The examples in this topic use the vector store table demo_embeddings created in the section Ingesting Files into a Vector Store. While Lakehouse provides in-memory query processing on data in Object Storage, it does not load data into a DB System ... 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-genai-generate-embeddings.html
For example: mysql>SELECT sys.ML_EMBED_ROW(@text, JSON_OBJECT("model_id", "all_minilm_l12_v2")) into @text_embedding; The routine returns a VECTOR, and this commad stores it in the @text_embedding variable. This section describes how to generate ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-option-tables.html
ndb_log_binlog_index: Insert mapping between epochs and binary log positions into ndb_binlog_index table. ndb-blob-read-batch-bytes: Specifies size in bytes that large BLOB reads should be batched into. ndb-blob-write-batch-bytes: Specifies size in ... The following list includes command-line options, system variables, and status variables applicable within mysqld when it is running as an SQL node in an NDB ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-mysqld.html
ndb_log_binlog_index: Insert mapping between epochs and binary log positions into ndb_binlog_index table. ndb-blob-read-batch-bytes: Specifies size in bytes that large BLOB reads should be batched into. ndb-blob-write-batch-bytes: Specifies size in ...ndb-cluster-connection-pool-nodeids: Comma-separated list of node IDs for connections to cluster used by MySQL; number of nodes in list must match value set for ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-genai-generate-embeddings.html
For example: mysql> SELECT sys.ML_EMBED_ROW(@text, JSON_OBJECT("model_id", "all_minilm_l12_v2")) into @text_embedding; The routine returns a VECTOR, and this command stores it in the @text_embedding variable. This section describes how to generate ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-genai-run-chat.html
In this topic, the HEATWAVE_CHAT routine uses the vector store table demo_embeddings created in the section Ingesting Files into a Vector Store for context retrieval. While I couldn't find specific information on the exact algorithms used by ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-tools-with-wordexcel.html
For example, to insert information from a table in the World test database into an Excel spreadsheet, using the DSN samples shown in Section 5.5, “Configuring Connector/ODBC”: Create a new Worksheet. Figure 5.34 Microsoft Query Wizard: Selecting ...Within Microsoft Excel, you can execute queries on your MySQL server and import the data directly into an Excel Worksheet, presenting the data as a series of rows and ...