Search Results
https://dev.mysql.com/doc/refman/8.4/en/faqs-replication.html
In the following section, we provide answers to questions that are most frequently asked about MySQL Replication. Must the replica be connected to the source all the time? A.14.2. Must I enable networking on my source and replica to enable ...
https://dev.mysql.com/doc/refman/8.4/en/environment-variables.html
MYSQL_HOME The path to the directory in which the server-specific my.cnf file resides. This section lists environment variables that are used directly or indirectly by MySQL. Most of these can also be found in other places in this manual. Options ...
https://dev.mysql.com/doc/refman/8.4/en/windows-create-option-file.html
You can determine its exact location from the value of the WINDIR environment variable using the following command: C:\> echo %WINDIR% MySQL looks for options in each location first in the my.ini file, and then in the my.cnf file. If you need to ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-ssl-wizard.html
An example MySQL configuration file (my.cnf / my.ini) is also generated that utilizes the generated certificates. For example, you must manually edit your MySQL configuration file (my.ini or my.cnf) and define the SSL options. This wizard helps ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-introduction-installation-types.html
my.cnf/my.ini: table_definition_cache: defines the number of table definitions that can be stored in the definition cache. You can change them, if your installation requires it, by editing setenv.sh/setenv.bat, or my.cnf/my.ini. MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.4/en/events-configuration.html
Starting the MySQL server with the --skip-grant-tables option causes event_scheduler to be set to DISABLED, overriding any other value set either on the command line or in the my.cnf or my.ini file (Bug #26807). Events are executed by a special ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-configuring-io-capacity.html
You can set the innodb_io_capacity value in the MySQL option file (my.cnf or my.ini) or modify it at runtime using a SET GLOBAL statement, which requires privileges sufficient to set global system variables. You can set the innodb_flush_sync value ... The InnoDB master thread and other threads perform various tasks in the background, most of which are I/O related, such as flushing dirty pages from the buffer pool and writing changes from the change buffer to the appropriate secondary ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-unix-servers.html
Note The discussion here uses mysqld_safe to launch multiple instances of MySQL. For MySQL installation using an RPM distribution, server startup and shutdown is managed by systemd on several Linux platforms. On these platforms, mysqld_safe is not ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-options.html
MYSQL_READ_DEFAULT_FILE (argument type: char *) Read options from the named option file instead of from my.cnf. MYSQL_READ_DEFAULT_GROUP (argument type: char *) Read options from the named group from my.cnf or the file specified with ... int ...
https://dev.mysql.com/doc/refman/8.4/en/nonpersistible-system-variables.html
For example, put these lines in your server my.cnf file: [mysqld] persist_only_admin_x509_subject="subject-value" The format of the Subject value is the same as used for CREATE USER ... The openssl output shows that the certificate Subject value is: ... SET PERSIST and SET PERSIST_ONLY enable global system variables to be persisted to the mysqld-auto.cnf option file in the data directory (see Section 15.7.6.1, “SET Syntax for Variable ...