Search Results
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/backup-capacity-options.html
For compression or incremental backup operations, the buffer size is slightly more than 16MB to accommodate the headers. One additional buffer is used for single-file incremental backup and single-file compressed backup. For the following ... These ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/meb-encrypted-innodb.html
For a series of incremental backups, if a component other than component_keyring_encrypted_file is being used on the server, users can provide a different value for --encrypt-password for any of the full or incremental backup in the backup sequence.
https://dev.mysql.com/doc/refman/9.7/en/innodb-parameters.html
innodb_autoextend_increment Command-Line Format --innodb-autoextend-increment=# System Variable innodb_autoextend_increment Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 64 Minimum Value 1 Maximum Value 1000 Unit ...It ... InnoDB Startup Options InnoDB System Variables System variables that are true or false can be enabled at server startup by naming them, or disabled by using a --skip- ...
https://dev.mysql.com/doc/refman/9.7/en/blackhole-storage-engine.html
Blackhole Engine and Auto Increment Columns The BLACKHOLE engine is a no-op engine. This should be borne in mind when considering the behavior of primary key columns that auto increment. The engine does not automatically increment field values, and ... The BLACKHOLE storage engine acts as a “black hole” that accepts data but throws it away and does not store ...
https://dev.mysql.com/doc/refman/9.7/en/bnl-bka-optimization.html
An incremental join buffer contains only columns from rows of the table produced by the second join operand. That is, it is incremental to a row from the first operand buffer. If B2 is an incremental join buffer, it contains the interesting columns ... In MySQL, a Batched Key Access (BKA) Join algorithm is available that uses both index access to the joined table and a join ...
https://dev.mysql.com/doc/refman/9.7/en/call.html
Metadata changes to objects referred to by stored programs are detected and cause automatic reparsing of the affected statements when the program is next executed. CALL sp_name([parameter[,...]]) CALL sp_name[()] The CALL statement invokes a stored ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-system-variables.html
The Performance Schema automatically sizes the values of several of its parameters at server startup if they are not set explicitly. performance_schema_accounts_size Command-Line Format --performance-schema-accounts-size=# System Variable ...
https://dev.mysql.com/doc/refman/9.7/en/change-replication-source-to.html
When the receiver thread is stopped, you can execute CHANGE REPLICATION SOURCE TO using any of the options for this statement (in any allowed combination) except RELAY_LOG_FILE, RELAY_LOG_POS, SOURCE_DELAY, or SOURCE_AUTO_POSITION = 1 even when the ...] CHANGE REPLICATION SOURCE TO changes the parameters that the replica server uses for connecting to the source and reading data from the ...
https://dev.mysql.com/doc/refman/9.7/en/option-files.html
A server started with the persisted_globals_load system variable disabled does not read mysqld-auto.cnf. Management of mysqld-auto.cnf should be left to the server and not performed manually. As used to find mysqld-auto.cnf, its default value is the ... Most MySQL programs can read startup options from option files (sometimes called configuration ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-enterprise-backup-online-backup.html
The Schedule subtab optionally sets a backup schedule for both full and incremental backups. A full backup is slower than the incremental backup that merges with a full backup. A common scenario is to set a full backup as weekly, and an incremental ... This section describes how to configure a backup profile that defines what should be backed up, where the backup should be stored, and when (the frequency) it should be backed ...