Graphical Overview Of Used Space

[larsen]

Hi,

besides SQLyog I sometimes have to use “MySQL Administrator” to see which tables use how much space. I haven´t found a way to do this in SQLyog and I guess there is only the textual representation which isn´t very useful to get a quick overview.

Afaik, “MySQL Administrator” isn´t available from MySQL anymore, but I´ve attached a screenshot and could give you the setup if you needed it (it´s open source).

Lars

[peterlaursen]

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.

.

[Author]

Posts