Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysqlslap.html
Run all the load statements, then run all the queries in the query file with five clients (five times each): mysqlslap --concurrency=5 --iterations=5 --query=query.sql --create=create.sql --delimiter=";" mysqlslap supports the following options, ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-rag.html
The ML_RAG routine runs retrieval-augmented generation which aims to generate more accurate responses for your queries. This topic contains the following sections: Before You Begin Retrieving Context and Generating Relevant Content Retrieving ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-learn-with-genai.html
Use NL2ML to generate AutoML queries that you can copy and run. To generate AutoML queries, NL2ML leverages the databases, tables, and table columns in the DB System. MySQL 9.4.1 adds the following updates to NL2ML: Additional data preparation ...
https://dev.mysql.com/doc/refman/8.4/en/set-operations.html
With the optional ALL keyword, duplicate-row removal does not occur and the result includes all matching rows from all queries in the union. Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-single.html
This section lists all NDB errors, ordered by NDB error code. Each listing also includes the error's NDB error type, the corresponding MySQL Server error, and the text of the error message. TO,Transaction had timed out when trying to commit it // ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-troubleshooting.html
MySQL HeatWave is designed for fast execution of large analytic queries. Smaller, simpler queries, such as those that use indexes for quick lookups, often execute faster on the MySQL DB System. To avoid offloading inexpensive queries to MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-tpch-quickstart.html
The tpch Analytics Quickstart shows how to import data into the DB System using the MySQL Shell Parallel Table Import Utility, manually loading data into MySQL HeatWave Cluster, and running queries. This quickstart contains the following sections: ...We recommend that you always run the latest version of MySQL Shell, which is currently MySQL version ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-how-to-import-onnx.html
This topic describes how to import an external ONNX model. Ways to Import External ONNX Model You have the following ways to import an external ONNX model. Import model as a string: For smaller models, you can copy the encoded string and paste it ...
https://dev.mysql.com/doc/refman/8.4/en/derived-table-optimization.html
(For an example, see Section 10.2.2.2, “Optimizing Subqueries with Materialization”.) If merging would result in an outer query block that references more than 61 base tables, the optimizer chooses materialization instead. Even for queries that ...The optimizer handles derived tables, view references, and common table expressions the same way: It avoids unnecessary materialization whenever possible, which enables pushing down conditions from the outer query to derived tables and produces more efficient execution ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-examples.html
Note There may be inconsistencies between queries shown in the INFORMATION_SCHEMA PROCESSLIST and INNODB_TRX tables. This section describes the use of locking information as exposed by the Performance Schema data_locks and data_lock_waits tables.