MySQL Query database size and table

Each MySQL has a library information_schema, which has a table tables stores information about all database tables, so you can see the database size and table size from this table

Querying database size

SelectConcatround((sum(data_length)+sum(Index_length))/1024x768/1024x768/1024x768,2),'GB') asData fromInformation_schema.tableswhereTable_schema='ESB';

Querying the table size in the database

SelectConcatround((sum(data_length)+sum(Index_length))/1024x768/1024x768/1024x768,2),'GB') asData fromInformation_schema.tableswhereTable_schema='ESB'  andtable_name='Perf_service';

Reference:

How to view MySQL database size with commands?

MySQL View the size of the database and table footprint

MySQL Query database size and table