Am 02.02.2006 um 18:31 schrieb Ryan Sizemore:
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?
I really don't know, we chose this way because it seemed the least
painful. No changes to configuration files necesssary, nothing new to
learn, etc.
Like: "don't try to solve a problem by solving a harder one" :)
-Sebastian
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
