Search Results
https://dev.mysql.com/doc/refman/8.4/en/with.html
A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that statement, possibly multiple times. The following discussion describes how to write ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-performance.html
For best backup performance and minimal impact on database processing: Do not run long INSERT, UPDATE, or DELETE queries at the time of the backup run. Each table and its associated indexes are represented by a .ibd file that is deleted or emptied ... This section describes the performance considerations for backing up a database with MySQL Enterprise ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/glossary.html
The database might be entirely shut down, or in a read-only state when applications are attempting to insert, update, or delete data. These terms are commonly used in information about the MySQL Enterprise Backup product. Files with this extension ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-files-backed-up-summary.html
During a restore, the information in the file is used to delete the tables from the full backup that has been removed between the time of the full backup and the time of the incremental backup. Warnings If the tracker file is deleted from the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.restore.html
Also delete all files inside the directories specified by the --innodb_data_home_dir, --innodb_log_group_home_dir, and --innodb_undo_directory options for restore, if the directories are different from the data directory. To restore a MySQL ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-install-agent-windows-service.html
You can remove the service using the SC DELETE command and the name of the service—in this case MCM—that was used in the SC CREATE command. If the service is running at the time that SC DELETE is executed, the removal of the service takes effect ... Important Installation of the MySQL Cluster Manager agent as a service is ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/global-error-reference.html
Error number: 37; Symbol: EE_FAILED_TO_DELETE_TIMER; Message: Failed to delete timer (OS errno %d). This document lists “global” error messages that are shared in the sense that they can be produced by the MySQL server or by MySQL client ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-basic-function-reference.html
The following table summarizes the functions available in the C API basic interface. For greater detail, see the descriptions in Section 5.4, “C API Basic Function Descriptions”.
https://dev.mysql.com/doc/c-api/8.4/en/c-api-basic-interface-usage.html
For each non-SELECT query (for example, INSERT, UPDATE, DELETE), you can find out how many rows were changed (affected) by calling mysql_affected_rows(). If mysql_field_count() returns zero, the statement returned no data (indicating that it was an ... Application programs should use this general outline for interacting with MySQL by means of the client library: Initialize the MySQL client library by calling ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-function-reference.html
The following table summarizes the functions available for prepared statement processing. For greater detail, see the descriptions in Section 6.4, “C API Prepared Statement Function Descriptions”.