Search Results
https://dev.mysql.com/doc/refman/8.4/en/connection-compression-control.html
Compression control applies to connections to the server by client programs and by servers participating in source/replica replication or Group Replication. The group_replication_recovery_compression_algorithms and ... Connections to the server can ...
https://dev.mysql.com/doc/refman/8.4/en/data-directory-initialization.html
Either create the account if it does not exist (see Create a mysql User and Group), or substitute the name of a different existing login account that you plan to use for running the server. Also make sure to specify as necessary other parameters ...
https://dev.mysql.com/doc/refman/8.4/en/derived-tables.html
This does not work: SELECT AVG(SUM(column1)) FROM t1 GROUP BY column1; However, this query provides the desired information: SELECT AVG(sum_column1) FROM (SELECT SUM(column1) AS sum_column1 FROM t1 GROUP BY column1) AS t1; Notice that the column ...
https://dev.mysql.com/doc/refman/8.4/en/drop-tablespace.html
mysql> DROP UNDO TABLESPACE undo_003; NDB Example This example shows how to drop an NDB tablespace myts having a data file named mydata-1.dat after first creating the tablespace, and assumes the existence of a log file group named mylg (see Section ... DROP [UNDO] TABLESPACE tablespace_name This statement drops a tablespace that was previously created using CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/extensions-to-ansi.html
You don't need to name all selected columns in the GROUP BY clause. You can specify ASC and DESC with GROUP BY, not just with ORDER BY. MySQL Server supports some extensions that you are not likely to find in other SQL DBMSs. Be warned that if you ...
MySQL 8.4 Reference Manual :: A.11 MySQL 8.4 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
https://dev.mysql.com/doc/refman/8.4/en/faqs-cjk.html
This set of Frequently Asked Questions derives from the experience of MySQL's Support and Development groups in handling many inquiries about CJK (Chinese-Japanese-Korean) issues. Where can I get help with CJK and related issues in MySQL? The ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-mysql-cluster.html
For this reason, if you do run multiple data nodes on a single machine, it is extremely important that they be set up in such a way that the failure of this machine does not cause the loss of all the data nodes in a given node group. When all data ... In the following section, we answer questions that are frequently asked about MySQL NDB Cluster and the NDB storage ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-st-spatial-reference-systems-table.html
Entries in the ST_SPATIAL_REFERENCE_SYSTEMS table are based on the European Petroleum Survey Group (EPSG) data set, except for SRID 0, which corresponds to a special SRS used in MySQL that represents an infinite flat Cartesian plane with no units ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 28.1 INFORMATION_SCHEMA Tables Table Name Description Deprecated ADMINISTRABLE_ROLE_AUTHORIZATIONS Grantable ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-init-startup-configuration.html
You can place InnoDB options in the [mysqld] group of any option file that your server reads when it starts. The innodb_redo_log_capacity variable supersedes the innodb_log_file_size and innodb_log_files_in_group variables, which are deprecated.