Search Results
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-channel.html
If the source server contains data, import existing data into the DB System: Export the data from the MySQL source server (see Exporting Data Using MySQL Shell for instructions) and: If using GTID-based replication: Capture the value of the source ...Replication positioning: Configure the Source GTID settings: Use GTID auto-positioning : Select this option when the system variable, gtid_mode, is set to ON on the ... Creating ...
https://dev.mysql.com/doc/refman/8.4/en/general-thread-states.html
Execution of init_command The thread is executing statements in the value of the init_command system variable. If this state is being caused by requests for external locks and you are not using multiple mysqld servers that are accessing the same ...
https://dev.mysql.com/doc/refman/8.4/en/option-files.html
A server started with the persisted_globals_load system variable disabled does not read mysqld-auto.cnf. MYSQL_HOME is an environment variable containing the path to the directory in which the server-specific my.cnf file resides. To specify an ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-replication.html
Verify that the skip_networking system variable has not been enabled in the configuration file for either server. How do I tell whether a replication source server is using statement-based or row-based binary logging format? Check the value of the ...How can I use replication to improve performance of my system? Set up one server as the source and direct all writes to ...
https://dev.mysql.com/doc/refman/8.4/en/version-tokens-reference.html
System variables: version_tokens_session Command-Line Format --version-tokens-session=value System Variable version_tokens_session Scope Global, Session Dynamic Yes SET_VAR Hint Applies No Type String Default Value NULL The session value of this ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.backup.html
240426 13:01:24 RDR1 INFO: Reading all global variables from the server. 240426 13:01:24 RDR1 INFO: Completed reading of all 623 global variables from the server. 240426 13:01:23 MAIN INFO: MySQL server version is '8.4.0-commercial' 240426 13:01:23 ... In the following illustration, we back up an entire MySQL instance to a single file using the backup-to-image command, which appears at the end of the sample ...
https://dev.mysql.com/doc/refman/8.4/en/windows-installation.html
Table 2.4 Default MySQL Installation Layout for Microsoft Windows Directory Contents of Directory Notes bin mysqld server, client, and utility programs %PROGRAMDATA%\MySQL\MySQL Server 8.4\ Log files, databases The Windows system variable ...Users ... MySQL is available for Microsoft Windows 64-bit operating systems ...There are different methods to install MySQL on Microsoft Windows: the MSI, the standard binary distribution (packaged as a compressed file) containing all of the ...
https://dev.mysql.com/doc/refman/8.4/en/show-replica-status.html
This is the same as the value for the global gtid_executed system variable on this server, as well as the value for Executed_Gtid_Set in the output of SHOW BINARY LOG STATUS on this server. However, because the file positions are not being regularly ... SHOW REPLICA STATUS [FOR CHANNEL channel] This statement provides status information on essential parameters of the replica ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-logging-configuration.html
Naming Conventions for Audit Log Files To configure the audit log file name, set the audit_log_file system variable at server startup. Selecting Audit Log File Format To configure the audit log file format, set the audit_log_format system variable ...A flush task configured using the audit_log_flush_interval_seconds system variable has a value of zero by default, which means the task is not scheduled to ... This section describes how to configure audit logging characteristics, such as ...
https://dev.mysql.com/doc/refman/8.4/en/grant.html
(Alternatively, if you have the UPDATE privilege for the grant tables in the mysql system schema, you can grant any account any privilege.) When the read_only system variable is enabled, GRANT additionally requires the CONNECTION_ADMIN privilege (or ...Normally, a database administrator first uses CREATE USER to create an account and define its nonprivilege characteristics such as its password, whether it uses secure connections, and limits on access to server resources, then uses GRANT to define its ...