gistfile1.txt

+--------------+---------------+---------------+
| wiki         | table_data_MB | index_data_MB |
+--------------+---------------+---------------+
| arwiki       |       1875.00 |       3742.99 |
| bnwiki       |        480.98 |        861.59 |
| bswiki       |        339.17 |        668.60 |
| cawiki       |       1495.50 |       2923.97 |
| cswiki       |       2025.64 |       3951.56 |
| dewiki       |      20936.03 |      41440.21 |
| elwiki       |        956.12 |       1811.99 |
| enwiki       |     104148.39 |     239704.48 |
| eswiki       |       7890.00 |      16067.00 |
| etwiki       |        604.85 |       1226.81 |
| euwiki       |        832.19 |       1585.34 |
| fawiki       |       1756.50 |       3287.00 |
| fiwiki       |       2124.18 |       4200.38 |
| frwiki       |      18982.67 |      36781.04 |
| hewiki       |       1661.50 |       3358.50 |
| hrwiki       |        615.21 |       1235.31 |
| huwiki       |       1492.50 |       3002.50 |
| idwiki       |       1750.61 |       3445.37 |
| iswiki       |        203.88 |        407.10 |
| itwiki       |      11707.20 |      23251.48 |
| kowiki       |       1473.50 |       2975.00 |
| lvwiki       |        368.93 |        729.93 |
| nlwiki       |       6249.06 |      12295.27 |
| nowiki       |       2318.98 |       4554.05 |
| plwiki       |       6584.51 |      12782.90 |
| ptwiki       |       6572.71 |      12703.94 |
| rowiki       |        876.50 |       1771.94 |
| ruwiki       |      12407.77 |      23325.72 |
| simplewiki   |        759.08 |       1490.06 |
| sqwiki       |        235.11 |        469.55 |
| srwiki       |       2845.00 |       7174.75 |
| svwiki       |       5424.04 |      10694.04 |
| tawiki       |        406.85 |        737.24 |
| testwiki     |         36.92 |         74.77 |
| trwiki       |       2336.73 |       4575.33 |
| ukwiki       |       1731.50 |       3366.50 |
| viwiki       |       3229.00 |       6992.46 |
| wikidatawiki |      50388.50 |     118443.97 |
+--------------+---------------+---------------+
38 rows in set (0.02 sec)

gistfile2.txt

SELECT "arwiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "arwiki" AND table_name = "revision"
UNION ALL
SELECT "bnwiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "bnwiki" AND table_name = "revision"
UNION ALL
SELECT "bswiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "bswiki" AND table_name = "revision"
UNION ALL
SELECT "cawiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "cawiki" AND table_name = "revision"
UNION ALL
SELECT "cswiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "cswiki" AND table_name = "revision"
UNION ALL
SELECT "dewiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "dewiki" AND table_name = "revision"
UNION ALL
SELECT "elwiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "elwiki" AND table_name = "revision"
UNION ALL
SELECT "enwiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "enwiki" AND table_name = "revision"
UNION ALL
SELECT "eswiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "eswiki" AND table_name = "revision"
UNION ALL
SELECT "etwiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "etwiki" AND table_name = "revision"
UNION ALL
SELECT "euwiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "euwiki" AND table_name = "revision"
UNION ALL
SELECT "fawiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "fawiki" AND table_name = "revision"
UNION ALL
SELECT "fiwiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "fiwiki" AND table_name = "revision"
UNION ALL
SELECT "frwiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "frwiki" AND table_name = "revision"
UNION ALL
SELECT "hewiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "hewiki" AND table_name = "revision"
UNION ALL
SELECT "hrwiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "hrwiki" AND table_name = "revision"
UNION ALL
SELECT "huwiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "huwiki" AND table_name = "revision"
UNION ALL
SELECT "idwiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "idwiki" AND table_name = "revision"
UNION ALL
SELECT "iswiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "iswiki" AND table_name = "revision"
UNION ALL
SELECT "itwiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "itwiki" AND table_name = "revision"
UNION ALL
SELECT "kowiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "kowiki" AND table_name = "revision"
UNION ALL
SELECT "lvwiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "lvwiki" AND table_name = "revision"
UNION ALL
SELECT "nlwiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "nlwiki" AND table_name = "revision"
UNION ALL
SELECT "nowiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "nowiki" AND table_name = "revision"
UNION ALL
SELECT "plwiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "plwiki" AND table_name = "revision"
UNION ALL
SELECT "ptwiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "ptwiki" AND table_name = "revision"
UNION ALL
SELECT "rowiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "rowiki" AND table_name = "revision"
UNION ALL
SELECT "ruwiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "ruwiki" AND table_name = "revision"
UNION ALL
SELECT "simplewiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "simplewiki" AND table_name = "revision"
UNION ALL
SELECT "sqwiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "sqwiki" AND table_name = "revision"
UNION ALL
SELECT "srwiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "srwiki" AND table_name = "revision"
UNION ALL
SELECT "svwiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "svwiki" AND table_name = "revision"
UNION ALL
SELECT "tawiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "tawiki" AND table_name = "revision"
UNION ALL
SELECT "testwiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "testwiki" AND table_name = "revision"
UNION ALL
SELECT "trwiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "trwiki" AND table_name = "revision"
UNION ALL
SELECT "ukwiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "ukwiki" AND table_name = "revision"
UNION ALL
SELECT "viwiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "viwiki" AND table_name = "revision"
UNION ALL
SELECT "wikidatawiki" AS wiki, round(((data_length) / 1024 / 1024), 2) as table_data_MB, round(((data_length + index_length) / 1024 / 1024), 2) AS index_data_MB FROM information_schema.TABLES WHERE table_schema = "wikidatawiki" AND table_name = "revision";