Search Results
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-connection-compression.html
Increases in the compression effort do not have a linear relationship to increases in the compression ratio. The default compression levels used by X Plugin in MySQL 8.4 have been selected through performance testing as being a good trade-off ... X ...
https://dev.mysql.com/doc/refman/8.4/en/xa-statements.html
To perform XA transactions in MySQL, use the following statements: XA {START|BEGIN} xid [JOIN|RESUME] XA END xid [SUSPEND [FOR MIGRATE]] XA PREPARE xid XA COMMIT xid [ONE PHASE] XA ROLLBACK xid XA RECOVER [CONVERT XID] For XA START, the JOIN and ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-3.html
(Bug #36978193) Binary packages that include curl rather than linking to the system curl library have been upgraded to use curl 8.9.1. This differs from previous behavior which always showed a consistent snapshot of locks held by individual ... C ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-capacity-options.html
When an incremental backup is restored with the --skip-binlog option, mysqlbackup renames any binary log files that have already been restored onto the server by adding to them the .old extension. --skip-final-rescan Skip the final rescan for InnoDB ... These options limit the resources used by the backup process, in order to minimize backup overhead for busy or huge databases, or specify behaviors of the process when encountering resource ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-commands-update.html
There are two types of operations to bring your backup data up-to-date: Apply-log Operation After a backup job was first completed, the backup data might not be in a consistent state, because data could have been inserted, updated, or deleted while ...During a backup, mysqlbackup also copies the accumulated InnoDB log to a file called ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-performance.html
Note that files copied under the --no-locking setting cannot be guaranteed to have consistent data. Although the mysqlbackup command supports the options --protocol=tcp, --protocol=socket, and --protocol=pipe, these options do not have a significant ... This section describes the performance considerations for backing up a database with MySQL Enterprise ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/bugs.corruption.html
170225 10:46:26 PCR1 ERROR: Page at offset 0 in D:/temp/5.7_source/test/emp2.ibd seems corrupt! A corruption problem can have different causes. If the problem persists after the database server and the storage device have been restarted, you might ...Here are some suggestions for dealing with it: The problem can occur if the MySQL server is too ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/glossary.html
These techniques have different characteristics in terms of size and representation of the backup data, and speed (especially speed of the restore operation). (Hot backups have the least interference, cold backups the most.) See Also cold backup, ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-backup-optimistic.html
Optimistic backup is a feature for improving performance for backing up and restoring huge databases in which only a small number of tables are modified frequently. During a hot backup of a huge database (say, in the order of terabytes), huge redo ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-performance-space-overview.html
To choose the strategy that best fits your needs, you have to understand the nature of each kind of backups that MySQL Enterprise Backup can perform, for which this section is giving a brief overview. When connected to a running MySQL server, MySQL ... When it comes to formulating your backup strategy, performance and storage space are the key ...