These kind of stories are really interesting because they provide so much context to questions that I couldn't answer up to now!
Like why my MySQL couldn't create indexes on data I migrated from PostgreSQL. Granted, that ship has long since sailed and we decided to stick with PostgreSQL, but nice to know the reason none the less!