mysql查看数据库和表使用空间

USE information_schema;

SELECT
	concat(
		round(
			sum(data_length / 1024 / 1024),
			2
		),
		'MB'
	) AS DATA
FROM
	TABLES
WHERE
	table_schema = 'user_server';

SELECT
	concat(
		round(
			sum(data_length / 1024 / 1024),
			2
		),
		'MB'
	) AS DATA
FROM
	TABLES
WHERE
	table_schema = 'user_server'
AND table_name = 'log_info';