To get the information execute “SHOW FULL FIELDS FROM database” (and do for every dabase if you want). Next summarize table_length and index_lenghts from the output.
Actually we have such feature in MONyog. It can be drilled down to databases, tables and indexes. Please see image.
[attachment=1587:diskinfo.jpg]
This is more a moitoring functionality (and MA was some kind of (simple) monitoring tool – unlike Query Browser that was a tool for Data manipulation and display – like SQLyog).
BUT – and that is important – this does NOT necessarily tell the actual storage used for data. It tells the *minimum amount of storage required for the data*. The reason is that if you DELETE/DROP objects then the files where data and indexes are held are not necessary deleted and files/tablespaces will never 'shrink'. Details depend on storage engine and storage engine parameters (for instance with InnoDB the InnoDB data files will be deleted when dropping a table if – and only – if the 'innodb_file_per_table' configuration parameter is set to ON and else not). So depending on how the database is used the information in MA and MONyog may be a pretty accurate depiction of the actual storage used or not.
.
