Query to check free and used space in tablespace (Mysql version 4.0)
Posted by:
Juan Perez
Date: September 06, 2010 10:09AM
Hi everyone, I'm new on database and mysql and I need to make a query to show me that information...I really apreciate any help or document that I could use to guide me...thank you
The table should be something like this
+------------------------+-----------------+-----------------+
| TABLESPACE_PATH | USED_SPACE | FREE_SPACE |
+------------------------+-----------------+-----------------+
/ts1/path.file 3145728000 822280192
/ts2/path.file 12582912000 3080192
+------------------------+-----------------+-----------------+
Edited 1 time(s). Last edit at 09/06/2010 10:34AM by Juan Perez.
Subject
Written By
Posted
Query to check free and used space in tablespace (Mysql version 4.0)
September 06, 2010 10:09AM
September 07, 2010 07:36PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.