There is a thing I really wonder about. I did not see any recommendation for rebuilding indexes in MySQL.
How does MySQL handle fragmented pages? Is there any background process or something like that?
Or pages are not fragmented ever? How is possible to UPDATE or DELETE data without index order is not fragmented?