I've been using InnoDB for the last week or so with good results & then all of a sudden I started getting errors : table ____ is full. I finally tracked it down to the size of the IBD file which I had at the 400MB default.
Does an IBD file expand out columns to their data type max size ? I have some TEXT columns that are sparsely used that I'm thinking are the cause of large space wasting. What can I do when my IBD file reaches the 2GB Linux file size limit ? Which alternate file system should I use for > 2GB or should I switch to BSD ? Is there any way to have separate IBD files for each MySQL table or at least DB ? --------------------------------------------------------------------- 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
