Search Results
https://dev.mysql.com/doc/refman/8.4/en/telemetry-metrics-meter-metrics.html
opened_tables Opened_tables ASYNC COUNTER The number of tables that have been opened prepared_stmt_count Prepared_stmt_count ASYNC GAUGE COUNTER The current number of prepared statements queries Queries ASYNC COUNTER The number of statements ... The ...binlog_stmt_cache_disk_use Binlog_stmt_cache_disk_use ASYNC COUNTER The number of nontransaction statements that used the binary log statement cache but that exceeded the value of binlog_stmt_cache_size and used a temporary file to store those ...
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. DBAs can set the global SQL mode to match site server operating requirements, ...Modes affect the SQL syntax MySQL supports and the data validation checks it ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-command-options.html
For information about option files used by MySQL programs, see Section 6.2.2.2, “Using Option Files”. --otel_log_level Controls which opentelemetry logs are printed in the server logs --otel_resource_attributes See corresponding OpenTelemetry ...
https://dev.mysql.com/doc/refman/8.4/en/using-systemd.html
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 program. One implication of the non-use ...If you install MySQL from a source distribution on a platform that uses systemd, obtain systemd support for MySQL by configuring the distribution using the -DWITH_SYSTEMD=1 CMake ...
https://dev.mysql.com/doc/refman/8.4/en/version-tokens-usage.html
A scenario in which Version Tokens can be useful is a system that accesses a collection of MySQL servers but needs to manage them for load balancing purposes by monitoring them and adjusting server assignments according to load changes. Such a ...
https://dev.mysql.com/doc/refman/8.4/en/log-file-maintenance.html
See Section 15.7.8.3, “FLUSH Statement”, Section 6.5.2, “mysqladmin — A MySQL Server Administration Program”, and Section 6.5.4, “mysqldump — A Database Backup Program”. As described in Section 7.4, “MySQL Server Logs”, MySQL ...
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 ... Note The discussion here uses mysqld_safe to launch multiple instances of ...
https://dev.mysql.com/doc/refman/8.4/en/added-deprecated-removed.html
Options and Variables Introduced in MySQL 8.4 Options and Variables Deprecated in MySQL 8.4 Options and Variables Removed in MySQL 8.4 This section lists server variables, status variables, and options that were added for the first time, have been ...Com_show_binary_log_status: Count of SHOW BINARY LOG STATUS statements; use instead of ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-connect.html
Using an Encrypted Connection MySQL client programs attempt to establish an encrypted connection if the server supports encrypted connections. The user accounts created previously are used to connect to the server. In this deployment, the --ssl ...
https://dev.mysql.com/doc/refman/8.4/en/connecting.html
For a client program to connect to the MySQL server, it must use the proper connection parameters, such as the name of the host where the server is running and the user name and password of your MySQL account. Client programs determine what type of ... This section describes use of command-line options to specify how to establish connections to the MySQL server, for clients such as mysql or ...