Search Results
https://dev.mysql.com/doc/refman/8.4/en/using-encrypted-connections.html
Instructions for creating any required certificate and key files are available in Section 8.3.3, “Creating SSL and RSA Certificates and Keys”. Should you need to create the required certificate and key files, see Section 8.3.3, “Creating SSL ... Several configuration parameters are available to indicate whether to use encrypted connections, and to specify the appropriate certificate and key ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-documents-index.html
If a collection is large and queries on a specific field are common, then consider creating an index on a specific field inside a document. For example, the following query performs better with an index on the Population field: mysql-py> ... Indexes ...
https://dev.mysql.com/doc/internals/en/event-data-for-specific-event-types.html
In MySQL 4.0 and 4.1, such events are written only to the first binary log file that mysqld creates after startup. Log files created subsequently (when someone issues a FLUSH LOGS statement or the current binary log file becomes too large) do not ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-post-install.html
Post-installation setup involves creating a safe directory for import and export operations, configuring server startup options, initializing the data directory, starting MySQL using systemd, resetting the password for the MySQL root@localhost user ...By default, a user who has the FILE privilege can read any file on the server host that is either world-readable or readable by the MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/json-search-functions.html
The functions in this section perform search or comparison operations on JSON values to extract data from them, report whether data exists at a location within them, or report the path to data within them. JSON_CONTAINS(target, candidate[, path]) ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-relnotes.html
2025-07-22: Running SQL statements as Asynchronous Tasks Now Supported For MySQL 9.3.1 and later, MySQL HeatWave on AWS now supports creating asynchronous tasks for long-running queries and commands, allowing them to run in the background as ...
https://dev.mysql.com/doc/refman/8.4/en/function-resolution.html
This occurs even when the function name is used in nonexpression context: mysql> CREATE TABLE count(i INT); ERROR 1064 (42000): You have an error in your SQL syntax ... To minimize the dependency of SQL code on the IGNORE_SPACE setting, use these ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-operations.html
For ALGORITHM=COPY, the mysqld NDB Cluster handler performs the following actions: Tells the data nodes to create an empty copy of the table, and to make the required schema changes to this copy. Online operations are noncopying; that is, they do ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-nutshell.html
BEFORE_8_2_0 causes the server to print DISABLE ON SLAVE (now deprecated) instead of DISABLE ON REPLICA in the output of SHOW CREATE EVENT. Added the following columns to the tp_thread_state table: TIME_OF_ATTACH, MARKED_STALLED, STATE, EVENT_COUNT, ... This section summarizes what has been added to, deprecated in, changed, and removed from MySQL 8.4 since MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations.html
Tables employing user-defined partitioning do not preserve the SQL mode in effect at the time that they were created. Therefore, a change in the SQL mode at any time after the creation of partitioned tables may lead to major changes in the behavior ... This section discusses current restrictions and limitations on MySQL partitioning ...