sql语句查询日志记录表数据、各数据表容量大小

查询各数据表容量大小

SELECT
table_schema AS ‘数据库’,
table_name AS ‘表名’,
table_rows AS ‘记录数’,
TRUNCATE(data_length/1024/1024, 2) AS ‘数据容量(MB)’,
TRUNCATE(index_length/1024/1024, 2) AS ‘索引容量(MB)’
FROM information_schema.tables
WHERE table_schema IN (‘bladex’, ‘bladex_flow’)
ORDER BY data_length DESC, index_length DESC;

– 查询日志记录表数据
SELECT * FROM bladex.blade_log_error e;

USE bladex;

– 清空日志记录表
TRUNCATE TABLE blade_log_error;

– 清空聊天记录，开发/测试/预发
TRUNCATE TABLE chat_msg;