Search Results
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-1.html
(Bug #36550125) Previous refactoring incorrectly removed the connection locking performed when processing incoming connection requests, which ledto a race condition between the thread adding new connections and the connection handler thread ...It ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-commands-restore.html
When restoring a single-file backup created with the option setting --use-tts=with-minimum-locking, the folder specified with --backup-dir is also used for extracting temporarily all the tables in the backup and for performing an apply-log operation ... The restore operations restores the data files from a backup to their original locations on the database server, or to other desired ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-progress-report-options.html
Compression meter: It indicates the sliding average of the compression ratio, which is defined for each block of data that is compressed as (orig_size - compressed_size) / orig_size. For example: compression: 40% This means that after compression, ... There are two options for controlling the progress reporting function of mysqlbackup: --show-progress and --progress-interval: --show-progress[={stderr|stdout|file:FILENAME|fifo:FIFONAME|table|variable}] Command-Line Format --show-progress[=destinations] Type Enumeration Valid Values stderrstdoutfile:FILENAMEfifo:FIFONAMEtablevariable The option instructs mysqlbackup to periodically output short progress reports known as progress indicators on its ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/exec-option.html
The --exec-when-locked option of mysqlbackup lets you specify a command (together with the desired command arguments) to run near the end of the backup while the database's non-InnoDB tables are still locked. This command can copy or create ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-backup-optimistic.html
Optimistic backup is a feature for improving performance for backing up and restoring huge databases in which only a small number of tables are modified frequently. During a hot backup of a huge database (say, in the order of terabytes), huge redo ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-change-user.html
(See Section 3.6.8, “Automatic Reconnection Control”.) It always performs a ROLLBACK of any active transactions, closes and drops all temporary tables, and unlocks all locked tables. It resets session system variables to the values of the ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-reset-connection.html
int mysql_reset_connection(MYSQL *mysql) Description Resets the connection to clear the session state. mysql_reset_connection() has effects similar to mysql_change_user() or an auto-reconnect except that the connection is not closed and reopened, ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-8.html
(WL #10620) X DevAPI: To support row locks for the find() method of the X DevAPI, the FindStatement and the SelecStatement interfaces have been extended with the following methods: lockExclusive(), which works like SELECT ... Version 8.0.8 ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-general-features-connection-sharing.html
Certain features will leave the connection in a state that blocks it from being shared when idle. and SQL_CALC_FOUND_ROWS User variables Temporary tables Prepared statements Note Transactions and LOCK TABLES also block connection sharing until the ... MySQL Router enables server connections to be pooled and ...
https://dev.mysql.com/doc/mysql-router/9.4/en/router-read-write-splitting-statements.html
Such as: GET_LOCK() FOR UPDATE|SHARE LOCK IN SHARE MODE Some functions can produce a write from within a read-only statement. The following Transaction and Locking statements: BEGIN, START TRANSACTION , XA, SAVEPOINT, ROLLBACK, COMMIT. The ...