Search Results
https://dev.mysql.com/doc/refman/8.4/en/cache-index.html
The key cache referred to in a CACHE INDEX statement can be created by setting its size with a parameter setting statement or in the server parameter settings. A key cache must exist before you assign indexes to it, or an error occurs: mysql> CACHE ...| 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] ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-conversion.html
As long as no 4-byte characters are sent from the server, there should be no problems. Conversely, applications that expect to send 4-byte characters must ensure that the server understands them. The server must be recent enough to recognize ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-limitations.html
The clone plugin is subject to these limitations: An instance cannot be cloned from a different MySQL server series. The X Protocol port specified by mysqlx_port is not supported for remote cloning operations (when specifying the port number of the ...For example, you cannot clone between MySQL 8.0 and MySQL 8.4, but can clone within a series such as MySQL 8.4.1 and MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/ddl-rewriter-installation.html
To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). If necessary, configure the plugin directory location by setting the value of plugin_dir at ...
https://dev.mysql.com/doc/refman/8.4/en/entering-queries.html
Make sure that you are connected to the server, as discussed in the previous section. Here is a simple query that asks the server to tell you its version number and the current date. We'll get to others later.) When you issue a query, mysql sends ...Doing so does not in itself select any database to work with, but that is ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-rotation.html
If you flush the error log using a FLUSH ERROR LOGS or FLUSH LOGS statement, or a mysqladmin flush-logs command, the server closes and reopens any error log file to which it is writing. If the location of the error log file is not writable by the ...To rename an error log file, do so manually before ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-syslog.html
This section describes how to configure error logging using the built-in filter, log_filter_internal, and the system log sink, log_sink_syseventlog, to take effect immediately and for subsequent server startups. To enable the system log sink, first ... It is possible to have mysqld write the error log to the system log (the Event Log on Windows, and syslog on Unix and Unix-like ...
https://dev.mysql.com/doc/refman/8.4/en/example-auto-increment.html
This enables multiple-row inserts to be reproduced correctly on other servers in a replication setup. How AUTO_INCREMENT behaves depending on the NO_AUTO_VALUE_ON_ZERO SQL mode: Section 7.1.11, “Server SQL Modes”. Setting the AUTO_INCREMENT ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-deploying-in-single-primary-mode.html
Each of the MySQL server instances in a group can run on an independent physical host machine, which is the recommended way to deploy Group Replication. This section explains how to create a replication group with three MySQL Server instances, each ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-distributed-recovery.html
When this process is complete, the joining member has caught up with the remaining servers in the group, and it begins to participate normally in the group. As state transfer from the binary log is based on classic asynchronous replication, it might ... Whenever a member joins or rejoins a replication group, it must catch up with the transactions that were applied by the group members before it joined, or while it was ...