Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing-syntax.html
If a target schema is not specified, Advisor analyzes all user defined schemas. Autopilot Indexing uses the following syntax: mysql> CALL sys.autopilot_index_advisor ([options]); options: { JSON_OBJECT('key','value'[,'key','value'] ...) ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-report-table.html
From MySQL version 8.0.32 onwards, the heatwave_advisor_report table, is deprecated and replaced with the heatwave_autopilot_report table in the sys schema. When MySQL runs Advisor, it sends detailed output to the heatwave_advisor_report table in ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-add-task-log.html
You can use this routine with an application-level task as well and it does not require an application-managed user ID. The add_task_log routine add a log entry for the task with the specified ID. Syntax mysql> CALL mysql_tasks.add_task_log( IN ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-autopilot-report-table.html
It contains data from the last execution of Advisor or Auto Parallel Load. Data is only available for the current session and is lost when the session terminates or when the server shuts down. When Advisor or Auto Parallel Load run, they send ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-bulk-load-mysql-server.html
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 sorted by primary key. Monitor bulk load progress with the Performance Schema (As ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-data-load-prerequisites.html
For users of MySQL HeatWave on AWS, the number of parallel read threads is also optimized when loading data from the MySQL HeatWave Console. This topic describes how to prepare your data for loading into MySQL HeatWave. Prepare Data Before loading ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-data-scanned.html
MySQL HeatWave tracks the amount of base relation data scanned by all queries collectively and by individual queries. Base relation data depends on the table schema, number of rows in each table, and DML operations on a MySQL table. Features like ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-loading-data.html
Load data using the MySQL HeatWave Console: applicable to MySQL HeatWave on AWS users. MySQL HeatWave provides the following methods to load data to MySQL HeatWave: Automatic loading: loads tables and partitions based on usage. Loading data using ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-performance-monitoring.html
MySQL HeatWave on AWS users can monitor MySQL HeatWave on the Performance page in the MySQL HeatWave Console. The MySQL Performance Schema collects statistics on the usage of MySQL HeatWave. Use SQL queries to access this data and check the system ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-exec-stats-table.html
For MySQL HeatWave AutoML, this contains the MySQL HeatWave AutoML routine that the user runs. The rpd_exec_stats table stores query execution statistics produced by MySQL HeatWave nodes in JSON format. One row of execution statistics is stored for ...