Search Results
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.
https://dev.mysql.com/doc/refman/8.4/en/join.html
index_hint: { USE {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] ([index_list]) | {IGNORE|FORCE} {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] (index_list) } index_list: index_name [, index_name] ... MySQL supports the following JOIN syntax for the ...
https://dev.mysql.com/doc/refman/8.4/en/limit-optimization.html
In some cases, a GROUP BY can be resolved by reading the index in order (or doing a sort on the index), then calculating summaries until the index value changes. In this case, LIMIT row_count does not calculate any unnecessary GROUP BY values. If ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-windows-services.html
In this case, you can use the [mysqld1] group for 5.7.9 and the [mysqld2] group for 8.4.6. In this case, each file should list options using a [mysqld] group. On Windows, a MySQL server can run as a Windows service. The procedures for installing, ...