Useful SQLs

Checking the size of the databases

SELECT table_schema AS "Database",
ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS "Size (MB)"
FROM information_schema.TABLES
GROUP BY table_schema;

Result:

DatabaseSize (MB)
ibdbv2_maize_merged3866.08
ibdbv2_wheat_merged25428.98
information_schema0.01
mysql2.08
performance_schema0
test0.02
workbench1.39