I have two InnoDB tables using a pool of space (the combined size of the data files may change). I want to limit each to using half the amount of space (or split it in some manner .. 60%/40%, etc). So far I've done this with a daemon that runs all the time deleting appropriate rows when the table nears "capacity" (I have it looking at the "Data_length" and "Index_length" columns of "Show table status like 'tablename'" and compairing the sum to the max that I've hardcoded)..
But of course this requires that magic number in there. I'd like to be able to pull the "max" out of the database somehow, which brings me to my question.. Why is "max_data_length" null? And is there a way I can get to this value? Is there a better/different way to do this? Thanks, Eric Mayers Software Engineer I Captus Networks query. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
