|
02-01-2005, 04:15 AM
|
#1 |
|
Junior Member
Join Date: Feb 2005
Posts: 1
|
Command to return summary info about database
Hi,
I am performing a database audit on all our internal systems. I am used to working with MSSQL Server, and was wondering, is there a command in MySQL that returns summary information about the database. In MSSQL it is a stored proc called sp_spaceused and returns the following: database_name database_size unallocated space ------------------------------------------------------ Abbey 239.81 MB 105.85 MB reserved data index_size unused ------------------ ------------------ ------------------ 1112 KB 408 KB 472 KB 232 KB I am searching for something similar in mySQL but at present, to no avail. I know you can use SHOW TABLE, but I specifically want summary info abotu the database and not just the tables. |
|
|
 |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| 3.3 Creating and Using a Database | Administrator | Documentation | 13 | 06-09-2004 04:56 PM |
| 1.2 Overview of the MySQL Database Management System | Administrator | Documentation | 0 | 06-07-2004 10:11 PM |
