PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/partitioning-pruning.html
MySQL can apply partition pruning to SELECT, DELETE, and UPDATE statements. 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 ...The core concept behind partition pruning is relatively simple, and can be described as “Do not scan partitions where there can be no matching ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/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 (from MySQL 5.7.32) TRUNCATE TABLE statement ... When a replication source server shuts down and restarts, its MEMORY tables become ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-replica.html
When the limit is reached, the replication I/O thread stops reading binary log events from the source until the replication SQL thread has caught up and deleted some unused relay logs. Note that this limit is not absolute: There are cases where the ... This section explains the server options and system variables that apply to replicas and contains the following: Startup Options for Replicas Options for Logging Replica Status to Tables System Variables Used on Replicas Specify the options either on the command line or in an option ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/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/5.7/en/alter-table-problems.html
(You may want to move them elsewhere instead of deleting them.) ALTER TABLE works in the following way: Create a new table named A-xxx with the requested structural changes. If you get a duplicate-key error when using ALTER TABLE to change the ...
https://dev.mysql.com/doc/refman/5.7/en/change-master-to.html
Prior to MySQL 5.7.4, CHANGE MASTER TO deletes all relay log files and starts a new one, unless you specify RELAY_LOG_FILE or RELAY_LOG_POS. If both threads are stopped, all relay log files are deleted unless at least one of RELAY_LOG_FILE or ...] ...
https://dev.mysql.com/doc/refman/5.7/en/create-event.html
CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ... The event does ...
https://dev.mysql.com/doc/refman/5.7/en/information-functions.html
This applies to statements such as UPDATE, INSERT, or DELETE (as before), but now also to statements such as ALTER TABLE and LOAD DATA. For REPLACE statements, the affected-rows value is 2 if the new row replaced an old row, because in this case, ...