Search Results
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-commands-restore.html
To restore selected tables: See the general requirements described in Section 5.1.4, “Table-Level Recovery (TLR)”. When restoring a single-file backup created with the option setting --use-tts=with-minimum-locking, the folder specified with ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-incremental-options.html
In general, optimistic incremental backups are faster than full-scan backups when not many tables in the database have been modified. Just like with the --incremental option, only InnoDB tables are backed up incrementally. It saves you from having ... For an overview of incremental backups and usage examples for these options, see Section 4.3.3, “Making a Differential or Incremental Backup” and Section 5.1.3, “Restoring an Incremental ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-progress-report-options.html
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 ...The argument of the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup.compressed.html
After the InnoDB tablespace files are compressed during backup, they receive the .ibz extension. To avoid wasting CPU cycles without saving additional disk space, --compress does not attempt to compress tables that were already-compressed on the ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-auto-reconnect.html
Loses the association of the client with the Performance Schema threads table row that determines connection thread instrumentation. If the client reconnects after a disconnect, the session is associated with a new row in the threads table and the ... The MySQL client library can perform an automatic reconnection to the server if it finds that the connection is down when you attempt to send a statement to the server to be ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-insert-id.html
Use this function after you have performed an INSERT statement into a table that contains an AUTO_INCREMENT field, or have used INSERT or UPDATE to set a column value with LAST_INSERT_ID(expr). If LAST_INSERT_ID(expr) occurred in the statement, ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-list-fields.html
MYSQL_RES * mysql_list_fields(MYSQL *mysql, const char *table, const char *wild) Description Note mysql_list_fields() is deprecated and is subject to removal in a future version of MySQL. Returns an empty result set for which the metadata provides ...Instead, use mysql_real_query() or mysql_query() to execute a SHOW COLUMNS ...
https://dev.mysql.com/doc/relnotes/mysql-shell/8.4/en/news-8-4-4.html
(Bug #35282392) The ReplicaSet metadata schema table, INSTANCES, was not populated properly when upgrading the metadata schema to version 2.2.0. As of this release, if locking the MySQL system tables fails with an Access Denied error, a warning is ... AdminAPI Bugs Fixed Utilities Added or Changed Functionality Utilities Bugs Fixed Functionality Added or Changed Bugs Fixed AdminAPI Bugs Fixed replicationLag of ReplicaSet.status() returned null if replication was ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/adminapi-locking.html
The following tables list the locking per AdminAPI operation: DBA Locking: lists the locks for dba.operationName operations. Table 6.1 DBA Operation Locks Operation Lock Type configureInstance() Exclusive on the target instance createCluster() ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-monitoring.html
You can monitor the status of AutoML by querying the rapid_ml_status variable or by querying the ML_STATUS column of the performance_schema.rpd_nodes table. mysql> SHOW GLOBAL STATUS LIKE 'rapid_ml_status'; +-----------------+-------+ | ...Query ...