> On Fri, May 16, 2008 at 4:30 PM, Jari Fredriksson
> <jarif AT iki DOT fi> wrote: 
>>> I running bacula server on a Debian Etch.
>>> 
>>> I upgraded via www.backports.org and now...
>>> 
>> 
>> Is it normal, that MySQL runs at 100% processor "hours"
>> after a backup? Maybe 1st time after an upgrade from
>> 1.38?  
>> 
> 
> The database may not have the proper indexes. I will look
> into the archives to see if I can find how to fix that.
> Does status dir say the backup is still running? Are you
> using spooling? 

status dir says:

Running Jobs:
 JobId Level   Name                       Status
======================================================================
  8078 Increme  MOSQUITO_Backup.2008-05-16_21.06.04 Dir inserting Attributes
  8079 Increme  SPITFIRE_Backup.2008-05-16_21.09.05 Dir inserting Attributes
  8080 Increme  WELLINGTON_System_Backup.2008-05-16_21.09.06 Dir inserting 
Attributes
  8081 Increme  WELLINGTON_Server_Backup.2008-05-16_21.09.07 is waiting for 
higher priority jobs to finish
  8082 Full    BackupCatalog.2008-05-16_21.09.08 is waiting execution
====

However. The screenshow I sent shows a table "batch". I can not see such table 
in MySQL Admin, not mysql shell. I googled that, and it seems to be some 
temporary table for bacula. I don't know if I should see it "from outside" of 
bacula process or not.. But I can't see it. Still the bacula process keeps 
referring to it, and doing it's stuff.

I added two rows to my.cnf (after googling)

    wait_timeout=691200
    interactive_timeout=691200

but have not restarted mysql yet. I'll try to give it some slack to get its job 
done..

Dunno.



-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft 
Defy all challenges. Microsoft(R) Visual Studio 2008. 
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users