Search Results
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-6.html
As a result, temporary table field references from previous executions were not cleared, leading to attempts to insert duplicate keys into temporary tables triggering the error Can't write; duplicate key in table. Note These release notes were ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-capacity-options.html
However, subsequent apply-log operations on the backups will take more time to complete, as the unused pages are inserted back into the tables during the operations. These options limit the resources used by the backup process, in order to minimize ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-commands-update.html
There are two types of operations to bring your backup data up-to-date: Apply-log Operation After a backup job was first completed, the backup data might not be in a consistent state, because data could have been inserted, updated, or deleted while ...During a backup, mysqlbackup also copies the accumulated InnoDB log to a file called ...
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. This section describes the performance considerations for backing up a database with MySQL ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-rotate-log.html
rotate log [{--hosts=|-h }host_list] [site_name] host_list: host[,host[,...]] Rotate mcmd logs for the connected MySQL Cluster Manager agent, for agents running on certain hosts, or for agents on all hosts in a management site.
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-mcmd.html
You can comment out a line by inserting a leading hash character (#). Invoking this executable starts the MySQL Cluster Manager Agent, to which you can connect using the mcm client (see Section 4.3, “Starting the MySQL Cluster Manager Client” ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-asynchronous-interface-usage.html
CREATE DATABASE db; USE db; CREATE TABLE test_table (id INT NOT NULL); INSERT INTO test_table VALUES (10), (20), (30); CREATE USER 'testuser'@'localhost' IDENTIFIED BY 'testpass'; GRANT ALL ON db.* TO 'testuser'@'localhost'; Create a file named ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-interface-usage.html
Otherwise, it sends an okay status and the number of rows changed, deleted, or inserted. To prepare and execute a statement, an application follows these steps: Create a prepared statement handler with mysql_stmt_init(). To prepare the statement on ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-num-rows.html
For statements such as INSERT, UPDATE, or DELETE, the number of affected rows can be obtained with mysql_affected_rows(). uint64_t mysql_num_rows(MYSQL_RES *result) Description Returns the number of rows in the result set. The use of ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-bind-param.html
bool mysql_stmt_bind_param(MYSQL_STMT *stmt, MYSQL_BIND *bind) Description mysql_stmt_bind_param() is used to bind input data for the parameter markers in the SQL statement that was passed to mysql_stmt_prepare(). The client library expects the ...