查詢 MySQL table size 語法

	SELECT concat(table_schema,'.',table_name),
	concat(round(table_rows/1000000,2),'M') rows,
	concat(round(data_length/(1024*1024),2),'M') DATA,
	concat(round(index_length/(1024*1024),2),'M') idx,
	concat(round((data_length+index_length)/(1024*1024),2),'M') total_size,
	round(index_length/data_length,2) idxfrac
	FROM information_schema.TABLES
	ORDER BY data_length+index_length DESC LIMIT 20;

view raw gistfile1.sql hosted with ❤ by GitHub