--1，切换数据库

USE information_schema;

--2，查看数据库使用大小

SELECT CONCAT(ROUND(SUM(data_length/1024/1024),2),'MB') AS DATA FROM TABLES WHERE table_schema='webassign' ;

---3，查看表使用大小

SELECT CONCAT(ROUND(SUM(data_length/1024/1024),2),'MB') AS DATA FROM TABLES WHERE table_schema='webassign'AND table_name='admin_log';

转自：https://blog.csdn.net/qq_21683643/article/details/81003136