Search Results
https://dev.mysql.com/doc/refman/8.4/en/outer-join-simplification.html
At the parser stage, queries with right outer join operations are converted to equivalent queries containing only left join operations. Table expressions in the FROM clause of a query are simplified in many cases. When the optimizer evaluates plans ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/plugin-types.html
Searches are specified as before, with no changes needed for queries. The plugin API enables creation of plugins that implement several capabilities: Loadable functions (UDFs) Storage engines Full-text parsers Daemons INFORMATION_SCHEMA tables ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-genai-generate-content.html
The following sections in this topic describe how to generate new text-based content using the GenAI feature of MySQL AI: Before You Begin Generating Content Running Batch Queries What's Next Before You Begin Review the GenAI requirements and ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/performance-advisors-ref.html
Default frequency 00:01:00 Default auto-close enabled no Excessive Number of Long Running Processes Most applications and databases are designed to execute queries very quickly. If many queries are taking a long time to execute (more than a few ...
https://dev.mysql.com/doc/heatwave/en/heatwave-system-variables.html
The number of entries permitted in the statistics cache by default is 65536, which is enough to store statistics for 4000 to 5000 unique queries of medium complexity. secondary_engine_cost_threshold System Variable secondary_engine_cost_threshold ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-syntax.html
Only run Advisor on multiple schemas if the queries access tables in multiple schemas. exclude_query: Defines the IDs of queries to exclude when Advisor analyzes query statistics. query_insights: Provides runtime information for successfully ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-optimization.html
If the WHERE clause contains range predicates (see the discussion of the range join type in Section 10.8.1, “Optimizing Queries with EXPLAIN”), a Loose Index Scan looks up the first key of each group that satisfies the range conditions, and ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-buffer-pool-tables.html
The InnoDB INFORMATION_SCHEMA buffer pool tables provide buffer pool status information and metadata about the pages within the InnoDB buffer pool. The InnoDB INFORMATION_SCHEMA buffer pool tables include those listed below: mysql> SHOW TABLES FROM ...
https://dev.mysql.com/doc/refman/8.4/en/range-optimization.html
In MySQL 8.4, index dive skipping is possible for queries that satisfy all these conditions: The query is for a single table, not a join on multiple tables. Range Optimization of Row Constructor Expressions The optimizer is able to apply the range ... The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value ...
https://dev.mysql.com/doc/refman/8.4/en/with.html
At the beginning of subqueries (including derived table subqueries): SELECT ... This is useful for queries that perform transitive closures, to avoid infinite loops. For queries that execute and thus recurse slowly or in contexts for which there is ... A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that statement, possibly multiple ...