#
# SQL query to check size of HOSS_transfers table.
#
# Use like this:
#
#         mysql -h hallddb -u test test < check_table_size.sql

SELECT table_schema AS 'Database' ,table_name AS 'Table',round(((data_length+index_length)/1E6),2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema='test' ORDER BY (data_length + index_length) DESC;

