Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-auto-increment-values.html
AUTO_INCREMENT columns can be used in MySQL for generating primary key or id values, but are not limited to these uses. This section explains how to retrieve AUTO_INCREMENT values when adding rows using X DevAPI. X DevAPI provides the ...
https://dev.mysql.com/doc/heatwave/en/heatwave-status-variables.html
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 Cluster is restarted (when the rapid_bootstrap state changes from OFF or IDLE ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing-examples.html
To evaluate all user defined schemas: mysql> CALL sys.autopilot_index_advisor(NULL); To evaluate selected schemas: mysql> CALL sys.autopilot_index_advisor(JSON_OBJECT('target_schema',JSON_ARRAY('schema1','schema2', ...))); An example of the output ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing-execution.html
Autopilot Indexing provides recommendations for schemas with a representative workload that has at least five queries in the SQL statement digest history in the Performance Schema. Autopilot Indexing only evaluates SQL statements in the SQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-arithmetic-operators.html
All arithmetic operators are supported with variable-length encoded string columns, see Section 5.8.1.4, “Encoding String Columns”.
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-apptask-kill.html
The kill_app_task routine kills an active or scheduled task using its task ID. Syntax mysql> SELECT mysql_tasks.kill_app_task( IN 'app_user_id' VARCHAR(255), IN 'task_id' VARCHAR(36); Following are kill_app_task parameters: app_user_id ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-exec.html
As of MySQL 9.3.1, you can run SQL statements as asynchronous tasks that run in the background. This lets your current session to continue without waiting for these SQL statements or tasks to complete. It is particularly helpful for long-running ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-comparison-functions-operators.html
The VARLEN Support column identifies functions and operators that support variable-length encoded string columns. Table 5.3 Comparison Functions and Operators Name VARLEN Support Description BETWEEN ... Yes Check whether a value is within a range of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-create-table-select.html
This topic describes how to create a new table and insert data using a SELECT query. When the query is offloaded to MySQL HeatWave, it is processed faster, improving the overall performance of the operation. SELECT statement is not permitted when ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-flow-control-functions-operators.html
The VARLEN Support column identifies functions and operators that support variable-length encoded string columns.