Search Results
https://dev.mysql.com/doc/refman/8.4/en/set-variable.html
The following procedure uses the increment procedure parameter and counter local variable: CREATE PROCEDURE p(increment INT) BEGIN DECLARE counter INT DEFAULT 0; WHILE counter < 10 DO -- ... SET counter = counter + increment; END WHILE; END; System ...variable: { user_var_name | param_name | local_var_name | {GLOBAL | @@GLOBAL.} system_var_name | {PERSIST | @@PERSIST.} system_var_name | {PERSIST_ONLY | @@PERSIST_ONLY.} system_var_name | [SESSION | ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-options-variables.html
ndb_autoincrement_prefetch_sz Command-Line Format --ndb-autoincrement-prefetch-sz=# System Variable ndb_autoincrement_prefetch_sz Scope Global, Session Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 512 Minimum Value 1 Maximum Value ...If the SQL node and the data node use the same host name or IP address, this fact is detected automatically, so that the preference is to send reads to the same ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/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/8.4/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/heatwave-aws/en/heatwave-aws-relnotes.html
2025-06-25: New Way to List Available GenAI Models MySQL HeatWave GenAI now supports automated discovery and listing of all available in-database and AWS Bedrock LLMs and embedding models starting with MySQL 9.3.2. It assures that when the primary ... Release Notes 23 Release Notes Release notes for MySQL HeatWave on AWS 2025-08-20: Storage Resizing for High Availability DB Systems It is now possible to resize the storage of high availability DB ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-enterprise-backup.html
For example, on Linux distributions that use systemd: s3> systemctl stop mysqld Preserve the two configuration files in the corrupted server's data directory, auto.cnf and mysqld-auto.cnf (if it exists), by copying them to a safe location outside of ... MySQL Enterprise Backup is a commercially-licensed backup utility for MySQL Server, available with MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.4/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 ...In ... 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/8.4/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/mysql-monitor/8.0/en/mem-events.html
For these advisors, you can schedule events to automatically be closed when the event moves from notification status back to the OK state. When auto-close is enabled, the event remains open while the condition that triggered the event is still in ...
https://dev.mysql.com/doc/refman/8.4/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 ...