Search Results
https://dev.mysql.com/doc/refman/8.4/en/alter-server.html
ALTER SERVER server_name OPTIONS (option [, option] ...) Alters the server information for server_name, adjusting any of the options permitted in the CREATE SERVER statement. For example, to update the USER option: ALTER SERVER s OPTIONS (USER ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-copying-to-other-server.html
On Server 1: $> mysqldump --databases db1 > dump.sql Copy the dump file from Server 1 to Server 2. On Server 2: $> mysql < dump.sql Use of --databases with the mysqldump command line causes the dump file to include CREATE DATABASE and USE ...
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/mysql-cluster-manager/8.4/en/mcm-issues-mysql-server.html
MySQL Cluster Manager does not track dependencies between mysqld attributes (MySQL server options and system variables). When using the mysql client or other MySQL client applications, many MySQL system options and variables can be named using ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-source.html
This section describes the server options and system variables that you can use on replication source servers. On the source and each replica, you must set the server_id system variable to establish a unique replication ID. These system variables ...It is not possible to restrict the effects of these two variables to a single table; these variables control the behavior of all AUTO_INCREMENT columns in all tables on the MySQL ...For each server, you ...
https://dev.mysql.com/doc/refman/8.4/en/server-administration.html
MySQL Server (mysqld) is the main program that does most of the work in a MySQL installation.
https://dev.mysql.com/doc/refman/8.4/en/ipv6-server-config.html
Set the bind_address system variable at server startup to specify the TCP/IP connections that a server instance accepts. For more information, see the bind_address description in Section 7.1.8, “Server System Variables”. The MySQL server ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-increase-dbsystem-storage.html
Increasing DB System Storage 3.4.7 Increasing DB System Storage You can increase the DB System storage by updating the data storage size of a DB System, by backup and restore, or by export and import. Increasing Storage by Updating the Data Storage ...Caution:You can only increase the data storage size once every 6 ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-navigator-management-server-status.html
As the next figure shows, this includes viewing the server's running state (stopped/running), available features, primary server directories, replication state, and security settings for authentication and SSL. You can access this window from either ... Get an immediate view into the basic health indicators and counters for your MySQL ...
https://dev.mysql.com/doc/heatwave-aws/en/hw-aws-server-versions.html
MySQL Server Versions 3.1.2.1 MySQL Server Versions The MySQL versioning model consists of two release tracks, Innovation and Long-Term-Support (LTS)/Bugfix, to suit your application and environment needs. Server Versioning Supported MySQL Server ...Both of the release tracks are production-grade quality and supported by MySQL HeatWave ...