Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-configuring-io-capacity.html
For busy systems capable of higher I/O rates, you can set a higher value to help the server handle the background maintenance work associated with a high rate of row changes. You can set the innodb_io_capacity value in the MySQL option file (my.cnf ...InnoDB attempts to perform these tasks in a way that does not adversely affect the normal working of the ... The InnoDB master thread and other threads perform various tasks in the background, most of which are I/O related, such as flushing ...
https://dev.mysql.com/doc/refman/8.4/en/charset-errors.html
If the server sends the error message to a client program, the server converts it from UTF-8 to the character set specified by the character_set_results system variable. This section describes how the MySQL server uses character sets for ...For ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-failure-handling.html
Concurrent DDL on the donor is blocked only if the clone_block_ddl variable is set to ON (the default setting is OFF). If the cloning operation is unable to obtain a DDL lock within the time limit specified by the clone_ddl_timeout variable, an ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-repair.html
myisamchk also has variables that you can set to control memory allocation that may improve performance. If you are going to repair a table from the command line, you must first stop the mysqld server. Note that when you do mysqladmin shutdown on a ... The discussion in this section describes how to use myisamchk on MyISAM tables (extensions .MYI and ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids.html
For information about MySQL Server options and variables relating to GTID-based replication, see Section 19.1.6.5, “Global Transaction ID System Variables”. In addition, once a transaction with a given GTID is committed on a given server, any ...
https://dev.mysql.com/doc/refman/8.4/en/replication.html
Replication enables data from one MySQL database server (known as a source) to be copied to one or more MySQL database servers (known as replicas). In this environment, all writes and updates must take place on the source server. The original type ...Replication is asynchronous by default; replicas do not need to be connected permanently to receive updates from a ...
https://dev.mysql.com/doc/refman/8.4/en/telemetry-trace-install.html
This section describes the installation of the server and client OpenTelemetry support. Installing Client Plugin The Telemetry plugin for the MySQL client can be enabled with a command line switch, --telemetry_client or from a configuration option, ...
https://dev.mysql.com/doc/refman/8.4/en/not-enough-file-handles.html
To tell mysqld to keep open fewer files at a time, you can make the table cache smaller by reducing the value of the table_open_cache system variable (the default value is 64). To change the number of file descriptors available to mysqld, you can ...
https://dev.mysql.com/doc/relnotes/mysql-operator/en/news-8-0-33-2.0.9.html
For example, "mysql/mysql-operator" becomes "container-registry.oracle.com/mysql/community-operator" with similar changes for the router, server, and operating system. Known Limitation Functionality Added or Changed Bugs Fixed Known Limitation A ...
https://dev.mysql.com/doc/refman/8.4/en/datetime.html
The current time zone is available as the value of the time_zone system variable. (This does not occur for other types such as DATETIME.) By default, the current time zone for each connection is the server's time. For more information, see Section ...This section describes their characteristics, how they are similar, and how they ...