Search Results
https://dev.mysql.com/doc/refman/9.7/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/refman/9.7/en/server-status-variables.html
Com_stmt_reprepare indicates the number of times statements were automatically reprepared by the server, for example, after metadata changes to tables or views referred to by the statement. This is incremented when a query brings the total memory ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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-enterprise-backup/9.7/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/refman/9.7/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/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/mysql-enterprise-backup/9.7/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 ...
https://dev.mysql.com/doc/ndbapi/en/ndb-column.html
Column::getAutoIncrement() Description This method shows whether the column is an auto-increment column. Return value TRUE if the column is an auto-increment column, FALSE if it is not. Signature void setAutoIncrement ( bool flag ) Parameters A ...
https://dev.mysql.com/doc/refman/9.7/en/option-tracker-component-status-variables.html
option_tracker_usage:Binary Log Incremented every 600 seconds (10 minutes) while binary logging is enabled. option_tracker_usage:Enterprise AUDIT This count is incremented when any Audit Log plugin function is called, or when a new audit output file ... The Option Tracker component supplies a number of status variables, which are described in this ...