Search Results
https://dev.mysql.com/doc/mysqld-version-reference/en/optvar-changes-9-7.html
The following list details the changes to specific options and variables within MySQL 9.7. audit_log_filter_recovery_mode Introduced in version 9.7.0 audit_log.filter_recovery_mode Introduced in version 9.7.0 audit_log.rotate_on_time Introduced in ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/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/8.4/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/8.4/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/8.4/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 The maximum number of metric instruments which can be created is set by ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/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/mysql-secure-deployment-guide/8.0/en/secure-deployment-connect.html
The user accounts created previously are used to connect to the server. Using an Encrypted Connection MySQL client programs attempt to establish an encrypted connection if the server supports encrypted connections. In this deployment, the --ssl ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-command-options.html
This option applies only if the server was started with the named_pipe system variable enabled to support named-pipe connections. This option applies only if the server was started with the shared_memory system variable enabled to support ...(MySQL ... mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option ...