Search Results
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-autopilot-shape-advisor.html
The system administrator should then make sure the DB system shape can accommodate the recommended buffer pool size and number of CPU cores. If the current buffer pool or CPU size is smaller than the predicted requirements, although MySQL can ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-updating-egress-endpoints.html
Updating Egress Endpoints for a Egress PrivateLink 6.3.4 Updating Egress Endpoints for a Egress PrivateLink You need to update the Egress Endpoints if the service in your account is listening on a different port, or you want to make it accessible ...Use the MySQL HeatWave Console to update the Egress Endpoints of a Egress ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-create-table-select.html
SELECT statement is not permitted when the sql_require_primary_key system variable is enabled. SELECT statement is executed, the SELECT query is offloaded to MySQL HeatWave for processing, while the table is created in the DB System. However, if the ... This topic describes how to create a new table and insert data using a SELECT ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-rag-table.html
Note In versions older than MySQL 9.2.1, to alter an existing table or create a new table, MySQL requires you to set the sql-require-primary-key system variable to 0. By default, the routine performs a global search across all the available vector ... The ML_RAG_TABLE routine runs multiple retrieval-augmented generation (RAG) queries in a batch, in ...
https://dev.mysql.com/doc/refman/9.7/en/myisamchk-memory.html
myisamchk uses no more memory than its memory-related variables are set to. If TMPDIR points to a memory file system, out of memory errors can easily occur. If this happens, run myisamchk with the --tmpdir=dir_name option to specify a directory ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-partitioning.html
A data placement key cannot be defined on a dictionary-encoded string column but are permitted on variable-length encoded columns. When data is loaded into MySQL HeatWave, it is partitioned by the table primary key and sliced horizontally for ...
https://dev.mysql.com/doc/relnotes/mysql-cluster-manager/8.4/en/news-8-4-3.html
(Bug #36954160) Client: mcm allowed setting the mysqld system variables telemetry.otel_exporter_otlp_traces_max_tls and telemetry.otel_exporter_otlp_traces_min_tls to an empty string, which was not allowed by the mysqld node and caused the node to ...With this fix, setting the variables to empty strings are no longer allowed by ... Version 8.4.3 is the ...
https://dev.mysql.com/doc/refman/9.7/en/derived-condition-pushdown-optimization.html
A condition cannot be pushed down if the derived table's SELECT list contain any assignments to user variables. When a derived table cannot be merged into the outer query (for example, if the derived table uses aggregation), pushing the outer WHERE ...
https://dev.mysql.com/doc/refman/9.7/en/derived-table-optimization.html
Similarly, you can use the derived_merge flag of the optimizer_switch system variable. The optimizer handles derived tables, view references, and common table expressions the same way: It avoids unnecessary materialization whenever possible, which ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-optimizer-trace-table.html
The optimizer_trace_max_mem_size variable sets a limit on the total amount of memory used by all currently remembered traces. The OPTIMIZER_TRACE table provides information produced by the optimizer tracing capability for traced statements. The ...