On Monday 04 September 2006 10:41, Arno Lehmann wrote:
> Hello,
>
> On 9/4/2006 9:45 AM, Arunav Mandal wrote:
> > On Sunday 03 September 2006 22:20, Kern Sibbald wrote:
>
> ...
>
> > In my /var/lib/mysql there are a number of big files called
> > dir_hostname-bin.000001 and so on and they are quite big around 1.1G. To
> > me it looks like a index files. It is filling up my mysql partition
> > quickly.
>
> Does this mean that the partition _is_ full and thus the database does
> not run reliably any more?
No the partition was not full. I restarted bacula now and try to run a job and
it works right away. So I don't know why it showed "is waiting execution" the
whole night when no jobs were running. Where do you specify Max. jobs I
specified that in Director { Maximum Concurrent Jobs = 90 } and also in
Storage { Maximum Concurrent Jobs = 90 }. Is there any other place to
specify? This problem "is waiting execution" happened twice before and a
restart of Dir solved the problem.
> In that case, this might explain your problems getting the jobs started.
>
> > It
> > is rotated everyday. How to automatically remove the files or do we need
> > those files?
>
> These are binary log files of the database. If you need them or not
> does, AFAIK, depend upon your needs, for example regarding database
> backups. (It's usually something you have to decide: do complete
> database dumps each time you backup the database and delete the logs
> aftrwards, or backup the logs to do incremental database backups.)
>
> They might also be important for database replicateion, for example.
>
> Also see http://ww.mysql.com/doc/refman/4.1/en/backup.html for some more
> details.
I am using a script to complete dump the database each night and rsync to a
different server. So I guess I don't need the binary log files. Can I somehow
disable it in my.cnf ?
> Arno
>
> > 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
--
Arunav Mandal - amandal at trolltech.com
Trolltech AS - Sandakerveien 116, Postboks 4332 Nydalen, 0402 Oslo, Norway
Phone: +47 21 60 27 22, Fax: +47 21 60 48 02
-------------------------------------------------------------------------
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
