Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysqlimport.html
--delete, -D Command-Line Format --delete Empty the table before importing the text file. The mysqlimport client provides a command-line interface to the LOAD DATA SQL statement. Most options to mysqlimport correspond directly to clauses of LOAD ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-list.html
In MySQL 8.4, all rows relating to employees working at stores in that region can be deleted with the query ALTER TABLE employees TRUNCATE PARTITION pWest, which can be executed much more efficiently than the equivalent DELETE statement DELETE FROM ... List partitioning in MySQL is similar to range partitioning in many ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-pruning.html
Consider this statement: DELETE FROM t4 WHERE region_code BETWEEN 4 AND 12; The range in the WHERE clause covers 9 values (4, 5, 6, 7, 8, 9, 10, 11, 12), but t4 has only 8 partitions. The optimization known as partition pruning is based on a ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-range.html
(See Bug #42849.) Range partitioning is particularly useful when one or more of the following conditions is true: You want or need to delete “old” data. If you are using the partitioning scheme shown previously for the employees table, you can ... A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-memory.html
To replicate this effect to replicas, the first time that the source uses a given MEMORY table after startup, it logs an event that notifies replicas that the table must be emptied by writing a DELETE or TRUNCATE TABLE statement for that table to ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-row-searches.html
When a replica using row-based replication format applies an UPDATE or DELETE operation, it must search the relevant table for the matching rows. If the algorithm is able to select a primary key or a unique index where every column in the index has ...The algorithm used to carry out this process uses one of the table's indexes to carry out the search as the first choice, and a hash table if there are no suitable ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-replica.html
When the limit is reached, the I/O (receiver) thread stops reading binary log events from the source server until the SQL thread has caught up and deleted some unused relay logs. Note that this limit is not absolute: There are cases where the SQL ...
https://dev.mysql.com/doc/refman/8.4/en/sql-mode.html
DELETE: IGNORE causes MySQL to ignore errors during the process of deleting rows. Strict SQL mode applies to the following statements under conditions for which some value might be out of range or an invalid row is inserted into or deleted from a ...
https://dev.mysql.com/doc/refman/8.4/en/table-locking.html
To give a specific INSERT, UPDATE, or DELETE statement lower priority, use the LOW_PRIORITY attribute. If you have problems with mixed SELECT and DELETE statements, the LIMIT option to DELETE may help. InnoDB tables use row-level locking so that ...
https://dev.mysql.com/doc/refman/8.4/en/telemetry-metrics-meter-metrics.html
delete Handler_delete ASYNC COUNTER The number of times that rows have been deleted from tables discover Handler_discover ASYNC COUNTER The number of times that tables have been discovered. rows_deleted Innodb_rows_deleted ASYNC COUNTER The number ... The following server metrics are registered by default: mysql.stats Metrics mysql.stats.com Metrics mysql.stats.connection Metrics mysql.perf_schema Metrics mysql.stats.handler Metrics mysql.stats.myisam Metrics mysql.stats.ssl Metrics mysql.inno Metrics mysql.inno.buffer_pool Metrics mysql.inno.data Metrics mysql.x Metrics mysql.x.stmt Metrics The maximum number of metric instruments which can be created is set by ...