1. MySQL
-
sql
-- 查看表占用空间大小。简单查询可以用show table status like 'blog_visit';
select
data_length,
index_length,
(o.data_length + o.index_length) as byte_length,
(o.data_length + o.index_length)/1024/1024 as byte_length_mb,
o.*
from information_schema.tables o where table_schema in ('lishuoboy-navigation') order by data_length desc;
-
截图
直接看表的ibd文件
2. Oracle
-
sql
-- 查看表占用空间大小。查当前登录用户可查USER_SEGMENTS表
select BYTES/1024 as BYTE_LENGTH_KB, o.* from DBA_SEGMENTS o where OWNER ='TEST' order by BYTES desc;
-
截图