Query to determine the size of tables in a database? (mysql)

Replace "schema_name" with the name of one of your databases.

And use single-quotes for string literals, not double-quotes.