This site gives two queries: http://www.mkyong.com/mysql/how-to-calculate-the-mysql-database-size/
Determine dimensions of databases
SELECT table_schema "Data Base Name", SUM( data_length + index_length) / 1024 / 1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema ;
Determine size all tables inside a database
SELECT TABLE_NAME, table_rows, data_length, index_length, round(((data_length + index_length) / 1024 / 1024),2) "Size in MB" FROM information_schema.TABLES WHERE table_schema = "schema_name";
The very first query works properly, however the second query does not create a result set. It simply shows what they are called from the fields with no rows. How do i customize the second query to properly show how big dimensions of my tables during my database.
I Believe this really is better .. http://dev.mysql.com/doc/refman/5.1/en/show-table-status.html
show table status from database;
"schema_name" using the title of 1 of your databases.
And use single-quotes for string literals, not double-quotes.