Search Results
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-tuning.html
Stalled statements generate a lot of extra overhead since they involve extra context switches and in some cases even extra thread creations. This section provides guidelines on determining the best configuration for thread pool performance, as ...
https://dev.mysql.com/doc/refman/8.4/en/view-algorithms.html
In this case, MySQL generates a warning and sets the algorithm to UNDEFINED. The optional ALGORITHM clause for CREATE VIEW or ALTER VIEW is a MySQL extension to standard SQL. For MERGE, the text of a statement that refers to the view and the view ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-options-system-variables.html
mysqlx_document_id_unique_prefix Command-Line Format --mysqlx-document-id-unique-prefix=# System Variable mysqlx_document_id_unique_prefix Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 0 Minimum Value 0 Maximum Value ...
https://dev.mysql.com/doc/refman/8.4/en/xa-restrictions.html
Undo the XA transaction that generated the error message, then restart replication. XA transaction support is limited to the InnoDB storage engine. For “external XA,” a MySQL server acts as a Resource Manager and client programs act as ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/index.html
Abstract This document contains release notes for the changes in MySQL 8.4. For information about changes in a different version of MySQL, see the release notes for that version. For additional MySQL 8.4 documentation, see the MySQL 8.4 Reference ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-metadata-options.html
Some metadata is stored in the backup directory, other metadata is stored in tables within the mysql database of the backed-up instance. --no-history-logging Turns off the recording of backup progress and history in logging tables inside the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-single-file-options.html
--disable-manifest Disable generation of manifest files for a backup operation, which are backup_create.xml and backup_content.xml present in the meta subdirectory. You use them in combination with the mysqlbackup commands backup-to-image, ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/index.html
Abstract This is the user manual for MySQL Enterprise Backup, a commercially licensed backup utility for MySQL databases. It explains the different kinds of backup and restore that can be performed with MySQL Enterprise Backup, and describes the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-backup-optimistic.html
During a hot backup of a huge database (say, in the order of terabytes), huge redo log files could be generated on the server when the backup is in progress. Optimistic backup is a feature for improving performance for backing up and restoring huge ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-redo-log-archiving.html
mysqlbackup may sometimes fail to keep pace with redo log generation on the backed up server while a backup operation is in progress, resulting in lost redo log records due to those records being overwritten. This issue most often occurs when there ...