So it would *seem* that using this option (increasing max_rows) is a better option that converting to InnoDB, since MyISAM is faster for inserting. Does this make sense?
Ryan Sebastian Stark wrote: > > This worked for me when I hit the limit: > > http://jeremy.zawodny.com/blog/archives/000796.html > > Be sure to have a recent dump in case anything goes wrong. > > > -Sebastian > > On Feb 1, 2006, at 3:37 PM, Roger Kvam wrote: > >> 27-Jan 00:45 alexandria-dir: LogicBackupAvr32.2006-01-27_00.05.10 >> Fatal error: sql_create.c:732 sql_create.c:732 insert INSERT INTO >> File (FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES >> (55527,829,2825202,2033976,'Bc sHVV IGk B Yc Y CwOuQ WvE BAA C4 >> BD0Kbs BD0Kbs BD2MTW A A C','0') failed: >> The table 'File' is full >> >> >> I`m running bacula 1.38.2, with standard install besides som >> alteration in the chio.changer scripts, on a FreeBSD 6.0-RELEASE >> >> My MySQL database is 6.8G, while the File.MYD is 4.0G >> My backup with most files are like this: >> >> FD Files Written: 3,876,210 >> SD Files Written: 3,876,210 >> FD Bytes Written: 256,133,597,826 >> SD Bytes Written: 256,774,755,561 >> >> And i got ca 10 similar jobs, I have been running since 9/des-2005 >> How could this happend? >> >> Roger Kvam >> >> >> >> ------------------------------------------------------- >> This SF.net email is sponsored by: Splunk Inc. Do you grep through >> log files >> for problems? Stop! Download the new AJAX search engine that makes >> searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! >> http://sel.as-us.falkag.net/sel? >> cmd=lnk&kid=103432&bid=230486&dat=121642 >> _______________________________________________ >> Bacula-users mailing list >> Bacula-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/bacula-users > > > > > ------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. Do you grep through log > files > for problems? Stop! Download the new AJAX search engine that makes > searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
