Tofu Optimist wrote: >When I set up the databases, I recall assigning >a few large fixed-size files to the InnoDB engine for >data (and I think) logs. > >I've been adding data to my databases daily and wish >to know how full they are,
Use this command: show table status from database_name like 'table_name'; where database_name.table_name is an InnoDB table. The last column of the output will show the InnoDB free space. >and what is the process >for extending the disk space allotted to them, should they need it. You could make the last table space file auto extending or shut the server down and add more table space files. You can't make them smaller easily. The details are here: http://www.innodb.com/ibman.php#Adding.and.removing Good luck, Ware -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
