WL#697: making mi_delete() to use read cache
Affects: Server-5.0 — Status: Un-Assigned — Priority: Medium
For DELETE, where table scan is used, MyISAM uses read cache: HA_EXTRA_CACHE. mi_delete should use this cache too, so changes will go to disk when the cache is flushed.
Another way to do this is to instead of updating the disk at once, to store all disk changes in a buffer (position, bytes) and then at end sort these and update in one batch.As the delete change is very small, this should be easy to do.
Copyright (c) 2000, 2019, Oracle Corporation and/or its affiliates. All rights reserved.