What table type are you using? InnoDB will spread the table over several files increasing your maximum space to unlimited if I remember correctly. (drive size is then the issue of course)
-Micah On Tuesday 21 December 2004 06:36 pm, Dominic Amann wrote: > Dominic Amann wrote: > > Dominic Amann wrote: > >> I spent most of the last 72 hours implementing a new server with > >> dbmail-mysql, and postfix. It was working, I was slowly (and > >> painfully) populating the database with messages from the old system > >> (were in uw-mbx format) using fetchmail. > >> > >> Until about 4:30pm today, messages were succesfully received. Since > >> then every attempt to deliver a message into the system has resulted > >> in a log message of: > >> > >> insert_messages(): error inserting msgblock [header] > >> > >> Does anyone have any clues for this tragic end? > > > > Ahh, never mind. I cranked up my log level and found that my messageblk > > file is 4GB. New question: how can I increase my max file size in Debian > > woody? > > Ahh, never mind: my kernel has LFS (large file support, so I found the > required info in mysql: > > ALTER TABLE messageblks MAX_ROWS=1000000000 AVG_ROW_LENGTH=33178; > > (taking the average row length from dbmail-administrator's handy > output). Hope it works!
