have worked on 20TB+ tables before. proper schema / index / query, shit is still fast as hell when you do it right
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-op...
People still think it's a toy to this day and they've struggled to shake that perception.