Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-result-outputfile.html
Exported query results are in CSV, Parquet, or JSON (As of MySQL 9.3.1) format. The number of output files and size of individual files depends on the amount of data generated by the query. The names for the output files are auto-generated and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-running-queries.html
When MySQL HeatWave is enabled and the data you want to query is loaded, queries that qualify are automatically offloaded from the DB System to MySQL HeatWave for accelerated processing. Simply run the query from a client, application, or interface ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-usage.html
This is also true for statements executed by MySQL client programs including mysqlbinlog, mysqladmin, and mysqldump; for this reason, you should grant SKIP_QUERY_REWRITE to the user account or accounts used by these utilities to connect to MySQL.
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-installation.html
To install or uninstall the Rewriter query rewrite plugin, choose the appropriate script located in the share directory of your MySQL installation: install_rewriter.sql: Choose this script to install the Rewriter plugin and its associated elements.
https://dev.mysql.com/doc/refman/8.4/en/optimizing-queries-myisam.html
Some general tips for speeding up queries on MyISAM tables: To help MySQL better optimize queries, use ANALYZE TABLE or run myisamchk --analyze on a table after it has been loaded with data. (For unique indexes, this is always 1.) MySQL uses this ...This updates a value for each index part that indicates the average number of rows that have the same ...
https://dev.mysql.com/doc/refman/8.4/en/query-attribute-components.html
The query_attributes component uses this service to provide access to query attributes within SQL statements. Purpose: Implements the mysql_query_attribute_string() function that takes an attribute name argument and returns the attribute value as a ... A component service provides access to query attributes (see Section 11.6, “Query ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin.html
MySQL supports query rewrite plugins that can examine and possibly modify SQL statements received by the server before the server executes them. MySQL distributions include a postparse query rewrite plugin named Rewriter and scripts for installing ...These elements work together to provide statement-rewriting capability: A server-side plugin named Rewriter examines statements and may rewrite them, based on its in-memory cache of rewrite ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/formatting-queries-reference.html
It is possible to format the query result with wiki markup. This enables you to display information from the query directly in the event generated by the advisor. This example lists the user name and host for all accounts without a defined password. See Section 31.1.7, “Wiki Format” for more information on the supported wiki ...
https://dev.mysql.com/doc/c-api/8.4/en/query-results.html
In addition to the result set returned by a query, you can also get the following information: mysql_affected_rows() returns the number of rows affected by the last query when doing an INSERT, UPDATE, or DELETE. With mysql_store_result(), ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results.html
As of MySQL 9.1.1-u1, you can export your query results on DB System tables and external Lakehouse tables to Object Storage. This feature is available for MySQL HeatWave on OCI and MySQL HeatWave on AWS. The capability to convert the output into ...