Search Results
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/restore-upgrade.html
Important You may encounter technical challenges during a server upgrade or downgrade, and it is beyond the function of MySQL Enterprise Backup, as a backup tool, to ensure a successful server upgrade or downgrade. Users interested in the topic are ...Perform any other additional upgrade steps that might be required for your platform or distribution as documented in the MySQL reference ...
https://dev.mysql.com/doc/refman/9.7/en/telemetry-metrics-meter-metrics.html
tc_log_page_waits Tc_log_page_waits ASYNC COUNTER For the memory-mapped implementation of the recovery log, this variable increments each time the server was not able to commit a transaction and had to wait for a free page in the log. external_lock ... The following server metrics are registered by default: mysql.stats Metrics mysql.stats.com Metrics mysql.stats.connection Metrics mysql.perf_schema Metrics mysql.stats.handler Metrics mysql.stats.myisam Metrics mysql.stats.ssl Metrics mysql.inno Metrics mysql.inno.buffer_pool Metrics mysql.inno.data Metrics mysql.x Metrics mysql.x.stmt Metrics mysql.mle Metrics The maximum number of metric instruments which can be created is set by ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-key-migration.html
Pausing keyring operations during an online migration is accomplished by connecting to the running server and setting its global keyring_operations system variable to OFF before key copying and ON after key copying. This is typically the value of ...
https://dev.mysql.com/doc/refman/9.7/en/using-systemd.html
Arrange for systemd to set environment variables for the MySQL server process. You can set the following parameters in override.conf: To set the number of file descriptors available to the MySQL server, use LimitNOFILE in override.conf rather than ...For example, mysqld_safe can handle server restarts, but systemd provides the same capability, and does so in a manner consistent with management of other services rather than by using an application-specific ...
https://dev.mysql.com/doc/refman/9.7/en/sql-mode.html
The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system variable. (See Section 7.1.8, “Server System Variables”.) Strict SQL mode is in ...
https://dev.mysql.com/doc/refman/9.7/en/time-zone-support.html
Time Zone Variables Populating the Time Zone Tables Staying Current with Time Zone Changes Time Zone Leap Second Support Time Zone Variables MySQL Server maintains several time zone settings: The server system time zone. When the server starts, it ...If you start the server using mysqld_safe, its --timezone option provides another way to set the system time ... This section describes the time zone settings maintained by MySQL, how to load the system tables ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/innodb-clusterset-cluster-repair.html
Depending on the issues or maintenance requirements for the cluster, the following operations are available for you to work with its member servers. Unless otherwise stated, use Cluster and ClusterSet objects that you fetched with an InnoDB Cluster ...For more details of the command, see Section 8.4.4, “Adding Instances to an InnoDB ...
https://dev.mysql.com/doc/refman/9.7/en/multiple-unix-servers.html
For MySQL installation using an RPM distribution, server startup and shutdown is managed by systemd on several Linux platforms. For information about using systemd to handle multiple MySQL instances, see Section 2.5.9, “Managing MySQL Server with ...One way is to run multiple MySQL instances on Unix is to compile different servers with different default TCP/IP ports and Unix socket files so that each one listens on different network ...
https://dev.mysql.com/doc/refman/9.7/en/log-file-maintenance.html
In addition, the server flushes the binary log automatically when current binary log file size reaches the value of the max_binlog_size system variable. To specify an alternative expiration period, use the binlog_expire_logs_seconds system variable.
https://dev.mysql.com/doc/refman/9.7/en/connecting.html
Client programs determine what type of connection to make as follows: If the host is not specified or is localhost, a connection to the local host occurs: On Windows, the client connects using shared memory, if the server was started with the ...If ... This section describes use of command-line options to specify how to establish connections to the MySQL server, for clients such as mysql or ...