MySQL Table Fragmentation: Beware of Bulk INSERT with FAILURE or ROLLBACK
Usually, database people are familiar with table fragmentation with DELETE statements. Whenever doing a huge delete, in most cases, they are always rebuilding the table to reclaim the disk space. But, are you thinking only DELETEs can cause table fragmentation? (Answer: NO). In this blog post, I am going to explain how table fragmentation is […]