Search Results
https://dev.mysql.com/doc/heatwave/en/hw-automl-privileges.html
mysql> GRANT CREATE, DROP, INSERT, SELECT, ALTER, DELETE, UPDATE ON database_name.* TO 'user_name'@'%'; Lakehouse and Tracking/Monitoring Privileges You need the following privileges to access external Lakehouse tables that have machine learning ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing.html
To run Autopilot Indexing for OLTP workloads, the user must have the following MySQL privileges: The PROCESS privilege. Autopilot Indexing obtains workloads from the statement digest history stored in the Performance Schema, evaluates them, and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-analyzing-tables.html
Check if you have the SELECT and INSERT privileges for the table that you want to analyze. As of MySQL 9.3.0, you can use the ANALYZE TABLE statement to analyze tables loaded into MySQL HeatWave and update table statistics. Before You Begin Ensure ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-task-manage-routine.html
For applications that have multiple application users, and there is no direct mapping between MySQL users and application users, you can use the application-level (app) variants of the asynchronous task routines. The sections in this topic describe ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-query-plan-improvement.html
A query execution plan may have nodes for table scans, JOIN, GROUP BY and other operations. The Auto Query Plan Improvement feature collects and stores query plan statistics in a statistics cache when a query is executed in MySQL HeatWave. When a ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-bulk-load-mysql-server.html
Tables can have a combination of multiple stored and virtual generated columns. MySQL includes a bulk load extension to the LOAD DATA statement that is only available in MySQL HeatWave on AWS. It can do the following: Optimize the loading of data ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-change-propagation.html
Tables that have become stale due to change propagation failures resulting from out-of-code errors are automatically reloaded. After tables are loaded into MySQL HeatWave, data changes are automatically propagated from DB System tables to their ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-connect-to-db-sys.html
Connect to the DB System After you have created and configured your DB System, connect to the DB System. This topic provides links to relevant documents that describe how to connect to a MySQL HeatWave DB System. For MySQL HeatWave on Oracle Cloud ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-create-temp-table.html
Before You Begin Create a MySQL HeatWave Temporary Table Comparing Query Execution Times What's Next Before You Begin To create a MySQL HeatWave temporary table, you must have the CREATE TEMPORARY TABLES privilege. As of MySQL 9.3.0, you can create ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-data-compression.html
Specifically, decompression operations have a minor effect on query runtimes, on the rate at which queries are offloaded to MySQL HeatWave during change propagation, and on recovery time from Object Storage. MySQL HeatWave compresses data as it is ...