At 17:48 +0200 4/22/05, Jarle Aase wrote:
Hi list,

Just a simple question. How do I know how much free space there is left
on a device assigned to InnoDB?

Depends on what you mean by "free space." Do you mean not space on the device not assigned to the InnoDB tablespace file, or space free within the InnoDB tablespace?

If the latter, SHOW TABLE STATUS for any InnoDB table in the tablespace
shows the approximate free space, but this is for the entire tablespace.
If your tablespace has other files besides the raw partition, the free
space value won't answer your question.

--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to