I have been using MS SQL, but now have to perform an audit on all the databases we have on our servers, including mysql db's. I used the command: SHOW TABLE STATUS FROM <db_name>, but I want summary info on each db rather than the details of each db table.

Like with MS SQL stored procs, are there any commands to return details about the databases, such as reserved size, space used, space not used, size of data files, size of transaction log files, size of indexes, etc???

Thanks in advance