SELECT table_name,         ROUND((data_length + index_length) / 1024 / 1024, 2) AS MB FROM information_schema.tables WHERE table_schema = 'roke' ORDER BY MB DESC LIMIT 20;

+------------------------------------+----------+
| craft_blitz_elementfieldcaches     | 11620.97 |
| craft_elements_sites               |   816.38 |
| craft_blitz_elementcaches          |   707.72 |
| craft_blitz_elementqueries         |    86.27 |
| craft_elements                     |    37.67 |
| craft_changedfields                |    28.67 |
| craft_entries                      |    19.64 |
| craft_redirect_404_log             |    12.50 |
| craft_blitz_elementquerycaches     |     9.03 |
| craft_formie_submissions           |     8.27 |
| craft_searchindex                  |     7.95 |
| craft_revisions                    |     7.55 |
| craft_entries_authors              |     6.55 |
| craft_blitz_caches                 |     4.20 |
| craft_structureelements            |     3.16 |
| craft_redirect_hits                |     1.72 |
| craft_projectconfig                |     1.52 |
| craft_feedme_logs                  |     0.64 |
| craft_redirects                    |     0.52 |
| craft_blitz_elementqueryattributes |     0.42 |
+------------------------------------+----------+
20 rows in set (0.07 sec)

-- 1. Создаём пустой клон структуры
CREATE TABLE craft_blitz_elementfieldcaches_new 
  LIKE craft_blitz_elementfieldcaches;

-- 2. Атомарная подмена — занимает миллисекунды
RENAME TABLE 
  craft_blitz_elementfieldcaches     TO craft_blitz_elementfieldcaches_old,
  craft_blitz_elementfieldcaches_new TO craft_blitz_elementfieldcaches;

-- 3. Удаляем старую в фоне — приложение уже не при делах
DROP TABLE craft_blitz_elementfieldcaches_old;

SET FOREIGN_KEY_CHECKS = 0;
-- после rename вернуть = 1

USE craft_db;
ANALYZE craft_blitz_elementfieldcaches;