Volker: I tried the sequence below and I don't see a change in my tables at all:
BEFORE: ======= # myisamchk -dv File MyISAM file: File Record format: Packed Character set: latin1 (8) File-version: 1 Creation time: 2006-01-26 13:31:19 Status: open,changed Auto increment key: 1 Last value: 3412187 Data records: 3164900 Deleted blocks: 176853 Datafile parts: 3342897 Deleted data: 18692352 Datafile pointer (bytes): 4 Keyfile pointer (bytes): 4 Datafile length: 344524708 Keyfile length: 124920832 Max datafile length: 2147483646 Max keyfile length: 2147483646 Recordlength: 42 table description: Key Start Len Index Type Rec/key Root Blocksize 1 1 4 unique unsigned long 1 23406592 1024 2 9 4 multip. unsigned long 0 23013376 1024 3 9 4 multip. unsigned long 0 4072448 1024 13 4 unsigned long 0 17 4 unsigned long 0 mysql> ALTER TABLE File MAX_ROWS=1000000000 AVG_ROW_LENGTH=102; Query OK, 3164900 rows affected (8 min 6.42 sec) Records: 3164900 Duplicates: 0 Warnings: 0 AFTER: ====== # myisamchk -dv File MyISAM file: File Record format: Packed Character set: latin1 (8) File-version: 1 Creation time: 2006-03-02 11:20:33 Recover time: 2006-03-02 11:28:38 Status: checked,analyzed Auto increment key: 1 Last value: 3412187 Data records: 3164900 Deleted blocks: 0 Datafile parts: 3164900 Deleted data: 0 Datafile pointer (bytes): 5 Keyfile pointer (bytes): 4 Datafile length: 325084916 Keyfile length: 118755328 Max datafile length: 2147483646 Max keyfile length: 2147483646 Recordlength: 42 table description: Key Start Len Index Type Rec/key Root Blocksize 1 1 4 unique unsigned long 1 4426752 1024 2 9 4 multip. unsigned long 49452 63589376 1024 3 9 4 multip. unsigned long 49452 118754304 1024 13 4 unsigned long 16 17 4 unsigned long 1 >On Thu, 2 Mar 2006 17:46:22 +0100, you wrote: >Hi, > >this for the archives: I got error messages saying "The table 'File' is >full". The table was 4 GB in size. It was on a ext3 filesystem. >Switching to xfs didn't help. >The solution is: >http://dev.mysql.com/doc/refman/5.0/en/full-table.html > >Saying: >You are using a MyISAM table and the space required for the table >exceeds what is allowed by the internal pointer size. If you don't >specify the MAX_ROWS table option when you create a table, MySQL uses >the myisam_data_pointer_size system variable. From MySQL 5.0.6 on, the >default value is 6 bytes, which is enough to allow 256TB of data. Before >MySQL 5.0.6, the default value is 4 bytes, which is enough to allow only >4GB of data. See Section 5.2.2, ?Server System Variables?. > > >You can check the maximum data/index sizes by using this statement: > >SHOW TABLE STATUS FROM database LIKE 'tbl_name'; > > > You also can use myisamchk -dv /path/to/table-index-file. > > If the pointer size is too small, you can fix the problem by using > ALTER TABLE: > > ALTER TABLE tbl_name MAX_ROWS=1000000000 AVG_ROW_LENGTH=nnn; > > You have to specify AVG_ROW_LENGTH only for tables with BLOB or TEXT > columns; in this case, MySQL can't optimize the space required based > only on the number of rows. > >Interesting: http://jeremy.zawodny.com/blog/archives/000796.html ===[George R. Kasica]=== +1 262 677 0766 President +1 206 374 6482 FAX Netwrx Consulting Inc. Jackson, WI USA http://www.netwrx1.com [EMAIL PROTECTED] ICQ #12862186 ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users