Search Results
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]] ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-filtering.html
The AUDIT_ABORT_EXEMPT privilege is available to permit a user account’s queries to always be executed even if an “abort” item would block them. Note For audit log filtering to work as described here, the audit log plugin and the accompanying ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-monitoring.html
You can monitor the status and progress of a cloning operation on the recipient MySQL server instance using the clone_status and clone_progress Performance Schema tables. Note The clone_status and clone_progress Performance Schema tables can be used ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-remote.html
The clone plugin supports the following syntax for cloning remote data; that is, cloning data from a remote MySQL server instance (the donor) and transferring it to the MySQL instance where the cloning operation was initiated (the recipient). CLONE ...