Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysqldump.html
--delete-source-logs Command-Line Format --delete-source-logs On a replication source server, delete the binary logs by sending a PURGE BINARY LOGS statement to the server after performing the dump operation. --delete-master-logs Command-Line Format ... The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-navigator.html
Delete Statement: Copies a DELETE statement in the form DELETE FROM `world`.`country` WHERE <{where_condition}>;. Create Statement: Copies a CREATE statement in the form DELETE FROM `world`.`country` WHERE <{where_condition}>;. Delete with ... The ...
https://dev.mysql.com/doc/workbench/en/wb-vertical-toolbar.html
9.1.2.2.3 The Eraser Tool Use the eraser tool to delete objects from the EER Diagram canvas. Change the mouse pointer to the eraser tool, then click the object you wish to delete. Depending upon your settings, the delete dialog box should open, ...
https://dev.mysql.com/doc/ndbapi/en/overview-operations.html
It is important to remember that: Deletes can neither read nor set values, but only delete them. 1.4.2.3.4 Using Scans to Update or Delete Rows Scanning can also be used to update or delete rows. (When iterating through the result set:) For each ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-comparison.html
Figure 3.6 NDB Clusters View Figure 3.7 NDB Clusters Detail View For more information, see Chapter 17, Asset Management Deleting Assets from the Inventory It is now possible to delete assets from the MySQL Enterprise Monitor inventory from the user ... This section provides a high-level overview of the differences between this release and its ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-mysql-instance-instance-details.html
The monitored instance section (untitled) lists all the instances currently monitored by this installation and enables you to delete and edit instance configuration. Deleting Instances To delete an instance, or multiple instances, select the ...
https://dev.mysql.com/doc/refman/8.4/en/general-thread-states.html
deleting from main table The server is executing the first part of a multiple-table delete. It is deleting only from the first table, and saving columns and offsets to be used for deleting from the other (reference) tables. deleting from reference ... The following list describes thread State values that are associated with general query processing and not more specialized activities such as ...
https://dev.mysql.com/doc/refman/8.4/en/truncate-table.html
Logically, TRUNCATE TABLE is similar to a DELETE statement that deletes all rows, or a sequence of DROP TABLE and CREATE TABLE statements. To achieve high performance, TRUNCATE TABLE bypasses the DML method of deleting data. Thus, it does not cause ...However, TRUNCATE TABLE operations on tables that use a storage engine which supports atomic DDL are either fully committed or rolled back if the server halts during their ...
https://dev.mysql.com/doc/workbench/en/wb-generating-sql.html
-- To preview the rows to be deleted, use Select Row Dependencies START TRANSACTION; -- Provide the values of the primary key of the row to delete. MySQL Workbench can be used to generate SQL, most typically as either INSERT statements or SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/atomic-ddl.html
For tables that do not use a storage engine which supports atomic DDL, table deletion occurs outside of the atomic DROP TABLE or DROP DATABASE transaction. Such table deletions are written to the binary log individually, which limits the discrepancy ...An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes associated with a DDL operation into a single, atomic ...