Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/agent-advisors-reference.html
However, when the Query Analyzer is enabled, the Agent can use significantly more memory to monitor and analyze whatever queries you direct through it. In this case, the amount of memory used depends on the number of unique normalized queries, ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-acl-best-open-ref.html
This scenario has the following role types: Manager: responsible for all monitored assets, advisor configuration, group configuration, query analysis, event handling and communications. Complete access.) DBA: responsible for monitored assets, query ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-encoding-string-columns.html
This topic describes how to encode string columns to improve the performance of queries that access them. For example, it is permitted for a column description to be specified alongside a column encoding keyword string: COMMENT 'column_description ...This topic contains the following sections: Before You Begin Supported Encoding Types Select the Encoding Type Define String Column Encoding View String Column Encoding What's Next Before You Begin Review the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-run-chat.html
When you run MySQL HeatWave Chat, it automatically loads the default LLM. By default, MySQL HeatWave Chat searches for an answer to a query across all ingested documents by automatically discovering available vector stores, and returns the answer ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-23-u2.html
(WL #14479) MySQL HeatWave now uses a priority-based scheduling mechanism based on query cost estimates to schedule queries for execution. The scheduling mechanism prioritizes short running queries over long running queries to reduce overall query ... Functionality Added or Changed Support was added for the following aggregate functions: STD() STDDEV() STDDEV_POP() STDDEV_SAMP() VAR_POP() VAR_SAMP() VARIANCE() See Aggregate ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-26-u2.html
CAST() of FLOAT and DOUBLE values to DECIMAL (Bug #33163625, Bug #33138534, WL #14714) The new hw_data_scanned global status variable tracks the total cumulative megabytes scanned by successfully executed MySQL HeatWave queries. Functionality Added ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-3-0.html
MySQL HeatWave GenAI MySQL HeatWave Lakehouse MySQL HeatWave MySQL HeatWave GenAI MySQL HeatWave GenAI now supports partial failures with better error reporting in batch queries that are run using the ML_GENERATE_TABLE, ML_RAG_TABLE, and ... Note ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-statements.html
Statement objects allow you to execute basic SQL queries and retrieve the results through the ResultSet class, which is described later. To create a Statement instance, you call the createStatement() method on the Connection object you have ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-troubleshooting.html
The issue will affect all queries, not just those from Connector/J. This section explains the symptoms and resolutions for the most commonly encountered issues with applications using MySQL Connector/J. Questions 16.1: When I try to connect to the ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-examples.html
For NDB tables, it is also possible to change the storage type used for a table or column. row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ...