get information about a mysql table

gistfile1.txt

# from http://www.mysqlperformanceblog.com/2008/03/17/researching-your-mysql-table-sizes/

SELECT count(*) tables,
    ->        concat(round(sum(table_rows)/1000000,2),'M') rows,
    ->        concat(round(sum(data_length)/(1024*1024*1024),2),'G') data,
    ->        concat(round(sum(index_length)/(1024*1024*1024),2),'G') idx,
    ->        concat(round(sum(data_length+index_length)/(1024*1024*1024),2),'G') total_size,
    ->        round(sum(index_length)/sum(data_length),2) idxfrac
    ->        FROM information_schema.TABLES
    ->        WHERE  table_name like "foo";