Innobase allows you to specify multiple data files and will use them automatically. So to keep under the 2gb limit just keep adding 2gb files as needed. You can see how much space is left in the innobase data files by doing the following query: "show table status from 'dbname' like 'tablename'".
ryan ----- Original Message ----- From: "Sam Lam" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Sunday, December 30, 2001 12:00 PM Subject: InnoDB ibd file hit 400MB default > 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 > --------------------------------------------------------------------- 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
