mysql check database_Check Database Size (Mysql, CentOS)

If you want to check the size of the databases available in ur msyql, Paste the below given query.SELECT table_schema "Data Base Name",

sum( data_length + index_length ) / 1024 /

1024 "Data Base Size in MB",

sum( data_free )/ 1024 / 1024 "Free Space in MB"

FROM information_schema.TABLES

GROUP BY table_schema ;

All size and all tables..SELECT concat(table_schema,'.',table_name),

concat(round(table_rows/1000000,2),'M') rows,

concat(round(data_length/(1024*1024*1024),2),'G') DATA,

concat(round(index_length/(1024*1024*1024),2),'G') idx,

concat(round((data_length+index_length)/(1024*1024*1024),2),'G') total_size,

round(index_length/data_length,2) idxfrac

FROM information_schema.TABLES

ORDER BY data_length+index_length DESC LIMIT 20;