Advanced MySQL 8

Splitting the big DELETE or INSERT queries

There would be times when the cleaning of old data is a requirement from a business or data-retention perspective, and in those situations, it is always recommended to split them into multi-threaded so there is a smaller set of queries, rather than one big fat query. If the retention policy is well-built and maintained, then this situation may not exist at all. Or even if there is a batch process to perform these kinds of operations on a regular basis, such as daily, this also might cause an outage to your application.

For example, if a business wanted all of those 100K test accounts that are not being used in the production environment to be deleted, then, in that case, there are multiple options ...