Hi,
in versions less than 5.x, show table status gives informations about rows and
avg_row_length. The product gives you a correct approximation if the stats are
analyzed. This is for actions from the client.
another thing is the OS commands from your datadir (du -k).
Hope that helps.
Mathias
If you are on 5.0.n there is an INFORMATION_SCHEMA which you can query
like this. A casual scan of the mysql tables don't show any sizes and I
don't know of a way to get table/database size via SQL.
mysql> select table_schema, sum(DATA_LENGTH) from
information_schema.tables group by 1;
+--