Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-distributed-recovery.html
When this process is complete, the joining member has caught up with the remaining servers in the group, and it begins to participate normally in the group. As state transfer from the binary log is based on classic asynchronous replication, it might ... Whenever a member joins or rejoins a replication group, it must catch up with the transactions that were applied by the group members before it joined, or while it was ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-backup.html
Hot and cold backups are physical backups that copy actual data files, which can be used directly by the mysqld server for faster restore. Cold Backups If you can shut down the MySQL server, you can make a physical backup that consists of all files ... The key to safe database management is making regular ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-crash-recovery.html
If the server is run with external locking enabled, you can use myisamchk to check tables at any time. In this case, if the server tries to update a table that myisamchk is using, the server waits for myisamchk to finish before it continues. If you ... This section describes how to check for and deal with data corruption in MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldumpslow.html
-h host_name Type String Default Value * Host name of MySQL server for *-slow.log file name. -i name Type String Name of server instance (if using mysql.server startup script). The MySQL slow query log contains information about queries that take a ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-transaction-management.html
To optimize InnoDB transaction processing, find the ideal balance between the performance overhead of transactional features and the workload of your server. The default MySQL setting AUTOCOMMIT=1 can impose performance limitations on a busy ...For ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-memory-model.html
The buffers are global to the server, so the instruments are displayed only in the memory_summary_global_by_event_name table, and not in other memory_summary_by_xxx_by_event_name tables. Memory used depends on the load actually seen, not the load ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-memory-summary-tables.html
Operation counts help to understand or tune the overall pressure the server is putting on the memory allocator, which has an impact on performance. It has these effects: In general, truncation resets the baseline for statistics, but does not change ...Allocating a single byte one million times is not the same as allocating one million bytes a single time; tracking both sizes and counts can expose the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-binlog-encryption-scope.html
Existing binary log files and relay log files that were present on the server when you started encryption are not encrypted. When binary log encryption is active on the server, temporary files used to hold the binary log cache are encrypted using ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks-recover.html
If a privilege check against the PRIVILEGE_CHECKS_USER account fails, the transaction is not executed and replication stops for the channel. Details of the error and the last applied transaction are recorded in the Performance Schema ...
https://dev.mysql.com/doc/refman/8.4/en/telemetry-metrics.html
The Server Telemetry Metrics Service and the Server Metrics Instrument Service enable you to register and query telemetry meters, metrics, and metric measurements, in order to periodically export these measurements using the OpenTelemetry protocol.