Search Results
https://dev.mysql.com/doc/refman/8.4/en/persisted-system-variables.html
SET can also be used to persist certain global system variables to the mysqld-auto.cnf file in the data directory, to affect server operation for subsequent startups. To augment administrative capabilities for server configuration beyond what is ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-backup-optimistic.html
Notes An optimistic backup cannot be performed for an incremental backup or a backup using transportable tablespaces (TTS). Optimistic backup is a feature for improving performance for backing up and restoring huge databases in which only a small ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/security-advisors-ref.html
Default frequency 06:00:00 Default auto-close enabled no Account Requires Unavailable Authentication Plug-ins MySQL supports many forms of authentication as of the 5.5 release, including external authentication mechanisms using PAM, or Windows ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-system-variables.html
group_replication_auto_increment_increment Command-Line Format --group-replication-auto-increment-increment=# System Variable group_replication_auto_increment_increment Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 7 ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-files-backed-up-summary.html
ibbackup_ibd_files Records names of the .ibd files and their space IDs during an incremental backup. During a restore, the information in the file is used to delete the tables from the full backup that has been removed between the time of the full ... The following table shows the different types of files that are included in a single-file backup image or a directory ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/admin-advisors-reference.html
Default frequency 06:00:00 Default auto-close enabled yes Binary Log Debug Information Disabled The binary log captures DML, DDL, and security changes that occur and stores these changes in a binary format. Default frequency 06:00:00 Default ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/performance-advisors-ref.html
Default frequency 00:05:00 Default auto-close enabled no Database File I/O Global Summary Exposes the current summary of file I/O by wait type globally from the sys.x$io_global_by_wait_by_latency view. Also, tables that have TEXT or BLOB columns are ...For optimal performance, transactions that move through the binary log should be contained within the binary log ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-selective-load.html
If a table with the engine_attribute option set is already loaded, then Auto Parallel Load lets you edit the engine_attribute option value only if Lakehouse Incremental Load is enabled. This topic contains the following sections: Before You Begin ...
https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html
The default value is autosized to 128, plus 1 for a value of max_connections up to 500, plus 1 for every increment of 20 over 500 in the max_connections value, capped to a limit of 2000. insert_id The value to be used by the following INSERT or ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/glossary.html
Thus, even when you primarily do partial or incremental backups, you might periodically do a full backup. incremental backup A backup that captures only data changed since the previous backup. The incremental backup data must be merged with the ...