Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/transaction-handling.html
Transactions can be used to group operations into an atomic unit. Either all operations of a transaction succeed when they are committed, or none. It is possible to roll back a transaction as long as it has not been committed. Transactions can be ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/understanding-automatic-document-ids.html
This sections describes in detail how document IDs are generated and how to interpret them. X DevAPI relies on server-based document ID generation, which results in sequentially increasing document IDs across all clients. InnoDB uses the document ...
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-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-analyzing-tables.html
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 that the enable_secondary_engine_statistics system variables is set to ON. Check if you ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-exec-prepared-stmt.html
The execute_prepared_stmt_async routine creates a task that executes SQL statements asynchronously within an event stored in the schema_name schema. schema_name (VARCHAR(255)): specifies the schema to run the given SQL statements. If the schema is ...
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-column-limits.html
MySQL HeatWave has the following column limits: As of MySQL 9.2.2, the maximum column width is 4192192 bytes. In previous versions of MySQL, the maximum column width is 65532 bytes. This includes the size of all the data and column metadata stored ...
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-genai-overview.html
MySQL HeatWave GenAI is a feature of MySQL HeatWave that lets you communicate with unstructured data in MySQL HeatWave using natural-language queries. It uses a familiar SQL interface which makes it is easy to use for content generation, ...