Find Tablespace
Posted by: Chris Hane
Date: March 10, 2005 11:07PM

I am trying to write a simple background monitoring tool (or find one if it exists) that can find the amount of tablespace left in the InnoDB tablespace. The only way I can see to do this is to issue a SQL like:
show table status like 'tablename'.

and then parse the comment column of the result set to find the free space.

Is there an easier / better / more error resistent method of find the remaining tablespace?

I've found lots of GUI monitoring tools, but I need one (or write one) that can run on a headless server and email admins when the free tablespace passes a defined threshold.

I'm asking here because I use Java. If there is a better place to ask (even if I need to use another language like C, let me know).

Thanks in advance,

Options: ReplyQuote

Written By
Find Tablespace
March 10, 2005 11:07PM

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.