Hi Mixo, How about adding a second innodb file and set the first one to a fixed size ?
"...If the disk becomes full you may want to add another data file to another disk, for example. Then you have to look the size of `ibdata1', round the size downward to the closest multiple of 1024 * 1024 bytes (= 1 MB), and specify the rounded size of `ibdata1' explicitly in innodb_data_file_path. After that you can add another datafile: innodb_data_home_dir = innodb_data_file_path = /ibdata/ibdata1:988M;/disk2/ibdata2:50M:autoextend..." (taken from the manual http://www.mysql.com/doc/en/InnoDB_start.html ) Best regards Nils Valentin Tokyo/Japan 2003年 7月 9日 水曜日 15:19、mixo さんは書きました: > The size is already set to 2000M, and I may be wrong, but the autoextend > feature is not support > in mysql version earlier that 4. > > Nils Valentin wrote: > >Hi Mixo, > > > >Do you have the autoextend feature enabled for the innodb table ? > >It can be set f.e in my.cnf. > > > >Best regards > > > >Nils Valentin > >Tokyo/Japan > > > >2003年 7月 8日 火曜日 22:45、mixo さんは書きました: > >>How can I avoid this: > >> > >> DBD::mysql::st execute failed: The table 'Transactions' is full at > >>/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm > >> > >>The table type is InnoDB. -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
