Wrote a follow-up on my laravel-telescope-flusher package with real benchmark numbers. `telescope:clear` takes 2.5 hours on 1M entries and leaves 3 GB locked in your `.ibd` files, because InnoDB doesn't return disk after `DELETE`. The flush variant uses `TRUNCATE` + `OPTIMIZE TABLE`, finishes in 1.21 seconds, and actually gives the disk back.
dev.to/tegos/why-telescopeclear-is-slow-and-how-to-reclaim-disk-in-seconds-26of
Back
