Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-query-plan-improvement.html
When a new query shares query execution plan nodes with previously executed queries, the statistics collected from previously executed queries are used instead of estimated statistics, which improves query execution plans, cost estimations, ... The ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-reference.html
Rewriter_number_rewritten_queries The number of queries rewritten by the Rewriter query rewrite plugin since it was loaded. Users communicate with the plugin by modifying the set of rules stored in this table. The plugin communicates information to ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-json-non-json.html
The option to export query results as an ND-JSON file is available as of MySQL 9.3.1. This topic contains the following sections: Before You Begin Syntax Parameter Descriptions Examples What's Next Before You Begin Review the following: Overview of ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-query-analyzer-ref.html
The Query Analyzer provides a point-in-time snapshot of queries on the monitored database, enabling you to monitor SQL statements executed on a MySQL server and see details of each query, number of executions, and execution times. Each row within ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-overview.html
This section provides an overview of exporting query results to Object Storage. Methods to Export Query Results You can export query results in the following ways. See OCIFS Documentation to learn more about OCIFS file format and its specifications. Pre-Authenticated Request (PAR): Create a temporary URL that is the export destination for the query ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-query-expansion.html
Full-text search supports query expansion (and in particular, its variant “blind query expansion”). This is generally useful when a search phrase is too short, which often means that the user is relying on implied knowledge that the full-text ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-query.html
ccnx.query('DROP TABLE IF EXISTS t') ccnx.query('CREATE TABLE t (i INT NOT NULL AUTO_INCREMENT PRIMARY KEY)') ccnx.query('INSERT INTO t (i) VALUES (NULL),(NULL),(NULL)') ccnx.query('SELECT LAST_INSERT_ID()') row = ccnx.fetch_row() ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-privatelink-query.html
Creating a Query PrivateLink 6.1.1 Creating a Query PrivateLink Use the MySQL HeatWave Console to create a Query PrivateLink to provide connectivity for applications running in your AWS account to MySQL HeatWave on AWS DB Systems using private IP ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-queries.html
To tune queries for InnoDB tables, create an appropriate set of indexes on each table. Follow these guidelines for InnoDB indexes: Because each InnoDB table has a primary key (whether you request one or not), specify a set of primary key columns ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/precondition-queries-reference.html
Precondition queries determine that specific conditions are true before executing the main query. For example, they are used in the default advisors to check the MySQL server version, because some main queries cannot be executed on older versions of ...The following is an example of a precondition query which checks the version of the MySQL server: <precondition> <![CDATA[SELECT @@version NOT LIKE '5.0%' AND @@version NOT LIKE '5.1%']]> </precondition> If the server version is higher than 5.1, the precondition returns true and the main query is ...