Search Results
https://dev.mysql.com/doc/refman/8.4/en/query-log.html
To specify the initial general query log state explicitly, use --general_log[={0|1}]. The general query log is a general record of what mysqld is doing. The server writes information to this log when clients connect or disconnect, and it logs each ...
https://dev.mysql.com/doc/refman/8.4/en/range-optimization.html
The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value intervals. The following sections describe conditions under which the optimizer uses range access. Additionally, for ...
https://dev.mysql.com/doc/refman/8.4/en/reloading-delimited-text-dumps.html
For backups produced with mysqldump --tab, each table is represented in the output directory by an .sql file containing the CREATE TABLE statement for the table, and a .txt file containing the table data. To reload a table, first change location ...
https://dev.mysql.com/doc/refman/8.4/en/replica-io-thread-states.html
Waiting for master update Waiting for source update The initial state before Connecting to master or Connecting to source. The following list shows the most common states you see in the State column for a replication I/O (receiver) thread on a ...
https://dev.mysql.com/doc/refman/8.4/en/replica-sql-thread-states.html
Waiting for the next event in relay log The initial state before Reading event from the relay log. The following list shows the most common states you may see in the State column for a replication SQL thread on a replica server. Monitoring tools ...
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover.html
Servers and groups can easily be added to or removed from the InnoDB ClusterSet deployment after the initial setup when demand changes. You can use the asynchronous connection failover mechanism to establish an asynchronous (source-to-replica) ...
https://dev.mysql.com/doc/refman/8.4/en/replication-binlog-encryption-encryption-keys.html
The file password is encrypted using AES-CBC (AES Cipher Block Chaining mode) with the 256-bit binary log encryption key and a random initialization vector (IV), and is stored in the log file's file header. The binary log encryption keys used to ...
https://dev.mysql.com/doc/refman/8.4/en/replication-binlog-encryption.html
When you first start the server with encryption enabled, a new binary log encryption key is generated before the binary log and relay logs are initialized. MySQL binary log files and relay log files can be encrypted, helping to protect these files ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-variables.html
The lower_case_table_names setting can only be configured when initializing the server. sql_mode is also replicated except for the NO_DIR_IN_CREATE mode; the replica always preserves its own value for NO_DIR_IN_CREATE, regardless of changes to it on ...
https://dev.mysql.com/doc/refman/8.4/en/replication-functions-synchronization.html
The function returns NULL if the replication SQL thread is not started, the replica's source information is not initialized, the arguments are incorrect, or an error occurs. The functions listed in this section are used for controlling ...