Search Results
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-23-u2.html
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 Functions. (WL #14479) MySQL HeatWave now uses a priority-based ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-autopilot-shape-advisor-sql.html
Autopilot Shape Advisor with a MySQL Client 17.3.2 Autopilot Shape Advisor with a MySQL Client Auto Shape Prediction records predictions in the shape_predictions table in the mysql_autopilot schema on the MySQL server. This is a system schema that ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connection-compression-xdevapi.html
Connector/J supports data compression for X DevAPI connections when working with MySQL Server 8.0.19 and later. General details about this feature can be found in Connection Compression with X Plugin. For details on how to configure connection ...
https://dev.mysql.com/doc/refman/8.4/en/cache-index.html
| tbl_name PARTITION (partition_list) } IN key_cache_name tbl_index_list: tbl_name [{INDEX|KEY} (index_name[, index_name] ...)] partition_list: { partition_name[, partition_name] ... | ALL } The CACHE INDEX statement assigns table indexes to a ...
https://dev.mysql.com/doc/refman/8.4/en/charset-introducer.html
A character string literal, hexadecimal literal, or bit-value literal may have an optional character set introducer and COLLATE clause, to designate it as a string that uses a particular character set and collation: [_charset_name] literal [COLLATE ...
https://dev.mysql.com/doc/refman/8.4/en/create-logfile-group.html
CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] [UNDO_BUFFER_SIZE [=] undo_buffer_size] [REDO_BUFFER_SIZE [=] redo_buffer_size] [NODEGROUP [=] nodegroup_id] [WAIT] [COMMENT [=] 'string'] ENGINE [=] ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-search-ngram.html
The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a limitation when working with ideographic languages that do not use word delimiters. To address this limitation, ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-adding-instances.html
At this point, the group has one member in it, server s1, which has some data in it. It is now time to expand the group by adding the other two servers configured previously. 20.2.1.6.1 Adding a Second Instance In order to add a second instance, ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-message-compression.html
For messages sent between online group members, Group Replication enables message compression by default. Whether a specific message is compressed depends on the threshold that you configure using the group_replication_compression_threshold system ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-offline-upgrade.html
To perform an offline upgrade of a Group Replication group, you remove each member from the group, perform an upgrade of the member and then restart the group as usual. In a multi-primary group you can shutdown the members in any order. In a ...