Now it is at Avg_row_length: 105. Anyway the file tends to get huge last time it went up to 18G.
Arunav. ----- Original Message ----- From: "Arno Lehmann" <[EMAIL PROTECTED]> To: <bacula-users@lists.sourceforge.net> Sent: Friday, September 01, 2006 12:58 AM Subject: Re: [Bacula-users] Mysql tables 'File' is full new mail > Ah, I see you found the solution... > > On 9/1/2006 12:47 AM, Arunav Mandal wrote: >> Probally while creating database at first we should have used MAX_ROWS >> and >> AVG_ROW_LENGTH options. > > probably... any real-life values for AVG_ROW_LENGTH? I offer 111... > > Arno > >> >> http://jeremy.zawodny.com/blog/archives/000796.html >> >> >> Arunav. >> >> ----- Original Message ----- >> From: "Arunav Mandal" <[EMAIL PROTECTED]> >> To: "Arunav Mandal" <[EMAIL PROTECTED]>; >> <bacula-users@lists.sourceforge.net> >> Sent: Friday, September 01, 2006 12:44 AM >> Subject: Re: [Bacula-users] Mysql tables 'File' is full new mail >> >> >> >>>I am altering the table now with >>> >>>alter table File max_rows = 200000000000; >>> >>>Some backups failed I guess other old backups are safe. >>> >>>Arunav. >>> >>>----- Original Message ----- >>>From: "Arunav Mandal" <[EMAIL PROTECTED]> >>>To: <bacula-users@lists.sourceforge.net> >>>Sent: Friday, September 01, 2006 12:34 AM >>>Subject: [Bacula-users] Mysql tables 'File' is full new mail >>> >>> >>> >>>>I am getting some errors now like this >>>> >>>>01-Sep 00:26 bacula-dir: sql_create.c:732 INSERT INTO File >>>>(FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES (3,179,14,34,'MC >>>>EGi >>>>EHJ C E H A BAA BAA I BE9gKM BE91M9 BE91M9 A A C','0') >>>>01-Sep 00:26 bacula-dir: backup-pip.2006-09-01_00.24.02 Fatal error: >>>>sql_create.c:734 Create db File record INSERT INTO File >>>>(FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES (3,179,14,34,'MC >>>>EGi >>>>EHJ C E H A BAA BAA I BE9gKM BE91M9 BE91M9 A A C','0') failed. ERR=The >>>>table >>>>'File' is full >>>>The table 'File' is full >>>> >>>>The Database size is only 4.22GB. >>>> >>>>-rw-rw---- 1 mysql mysql 4.0G Aug 31 20:37 File.MYD >>>> >>>>Is this the reason? I am running 2.6.9-42.0.2.ELsmp kernel. >>>> >>>> >>>>Arunav. >>>> >>>> >>>>------------------------------------------------------------------------- >>>>Using Tomcat but need to do more? Need to support web services, >>>>security? >>>>Get stuff done quickly with pre-integrated technology to make your job >>>>easier >>>>Download IBM WebSphere Application Server v.1.0.1 based on Apache >>>>Geronimo >>>>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 >>>>_______________________________________________ >>>>Bacula-users mailing list >>>>Bacula-users@lists.sourceforge.net >>>>https://lists.sourceforge.net/lists/listinfo/bacula-users >>>> >>> >>> >> >> >> ------------------------------------------------------------------------- >> Using Tomcat but need to do more? Need to support web services, security? >> Get stuff done quickly with pre-integrated technology to make your job >> easier >> Download IBM WebSphere Application Server v.1.0.1 based on Apache >> Geronimo >> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 >> _______________________________________________ >> Bacula-users mailing list >> Bacula-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/bacula-users > > -- > IT-Service Lehmann [EMAIL PROTECTED] > Arno Lehmann http://www.its-lehmann.de > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job > easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
