Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-a-session-object.html
All previous examples used the getSchema() or getDefaultSchema() methods of the Session object, which return a Schema object. Most examples make use of the X DevAPI ability to chain all object constructions, enabling you to get to the Schema object ...
https://dev.mysql.com/doc/heatwave/en/heatwave-status-variables.html
The network is disabled and user operations cannot be offloaded to RAPID. Data is tracked in megabytes and is a cumulative total of data scanned since the MySQL HeatWave Cluster was last started. The counter is reset to 0 when the MySQL HeatWave ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-about-analytics.html
When a MySQL HeatWave Cluster is enabled, queries that meet certain prerequisites are automatically offloaded from the DB System to the MySQL HeatWave Cluster for accelerated processing. Queries are issued from a MySQL client or application that ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-encoding.html
Using the right string column encodings can reduce the amount of memory required on MySQL HeatWave nodes and improve query performance. MySQL HeatWave supports two string column encoding types: variable-length and dictionary. MySQL HeatWave applies ...
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 ...