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/mysql-ai/9.5/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 ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-prepare-data-split.html
Overview The TRAIN_TEST_SPLIT routine takes your datasets and prepares new tables for training and testing machine learning models. Two new tables in the same database are created with the following names: [original_table_name]_train ... You can ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-training.html
The training dataset used with ML_TRAIN must reside in a table on the MySQL server. AutoML supports tables up to 10 GB in size with a maximum of 100 million rows and or 1017 columns. mysql> CALL sys.ML_TRAIN('table_name', 'target_column_name', ...