Search Results
https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html
This prevents most The table tbl_name is full errors for SELECT operations that require a large temporary table, but also slows down queries for which in-memory tables would suffice. If any user connection uses more than this amount, all queries ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
Error number: 3550; Symbol: ER_IS_QUERY_INVALID_CLAUSE; SQLSTATE: HY000 Message: Information schema queries do not support the '%s' clause. Error number: 3954; Symbol: ER_MISPLACED_INTO; SQLSTATE: HY000 Message: Misplaced INTO clause, INTO is not ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-hints.html
Changes to this variable affect execution of all subsequent queries; to affect one query differently from another, it is necessary to change optimizer_switch before each one. If subqueries subq1 and subq2 are converted to semijoins, tables t4@subq1 ... One means of control over optimizer strategies is to set the optimizer_switch system variable (see Section 10.9.2, “Switchable ...
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. This topic contains the following sections: Before You Begin Retrieve Context and Generate Relevant Content Retrieve Context ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-faq.html
C.7: Why does monitoring a MySQL instance with FEDERATED tables cause extra connections, and decreased performance? When the agent starts, it executes a discovery process that performs a number of INFORMATION_SCHEMA queries that gather table ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-byo-embedding-tables.html
To Run Batch Queries, add the natural-language queries to a column in a new or existing table. To use the name of an embedding model that is not available in MySQL HeatWave for running RAG, also add the vector embeddings of the input queries to a ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-byo-embedding-tables.html
For Running Batch Queries, add the natural-language queries to a column in a new or existing table. To use the name of an embedding model that is not available in GenAI for running RAG, also add the vector embeddings of the input queries to a column ... GenAI lets you use tables containing your own vector embedding to run retrieval-augmented generation (RAG) with vector ...
https://dev.mysql.com/doc/refman/8.4/en/explain-output.html
select_type Value JSON Name Meaning SIMPLE None Simple SELECT (not using UNION or subqueries) PRIMARY None Outermost SELECT UNION None Second or later SELECT statement in a UNION DEPENDENT UNION dependent (true) Second or later SELECT statement in a ... The EXPLAIN statement provides information about how MySQL executes ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-file-formats.html
This data is available in the slow query log for qualifying queries, and in the context of the audit log it similarly helps to detect outliers for activity analysis. The MySQL server calls the audit log plugin to write an audit record to its log ...
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, ...