Search Results
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 */ ...
https://dev.mysql.com/doc/refman/8.4/en/alter-user.html
ALTER USER permits these resource_option values: MAX_QUERIES_PER_HOUR count, MAX_UPDATES_PER_HOUR count, MAX_CONNECTIONS_PER_HOUR count For all accounts named by the statement, these options restrict how many queries, updates, and connections to the ... ALTER USER [IF EXISTS] user [auth_option] [, user [auth_option]] ...