Bacula-users

Re: [Bacula-users] 2.2.8 inserting attributes taking a long time

2008-08-29 11:59:17
Subject: Re: [Bacula-users] 2.2.8 inserting attributes taking a long time
From: Michael Galloway <mgx AT ornl DOT gov>
To: Dan Langille <dan AT langille DOT org>
Date: Fri, 29 Aug 2008 11:54:28 -0400
On Fri, Aug 29, 2008 at 11:22:45AM -0400, Dan Langille wrote:
> Michael Galloway wrote:
> > On Thu, Aug 28, 2008 at 11:02:13PM -0400, Dan Langille wrote:
> 
> Then it must be something else.
> 
> I've lost track of the rest of the thread.
> 
> Check your disk IO and see if it's active.  Check your database, see if 
> it's active.  For PostgreSQL, start with:
> 

io looks like this:

avg-cpu:  %user   %nice %system %iowait  %steal   %idle
           0.65    0.00    0.75   23.55    0.00   75.05

Device:            tps   Blk_read/s   Blk_wrtn/s   Blk_read   Blk_wrtn
sda              45.71       276.25      2756.09       1384      13808
sdb              45.51       225.15      2756.09       1128      13808
sdc              48.90         0.00       631.14          0       3162
md0             366.07       501.40      2743.31       2512      13744
md1               0.00         0.00         0.00          0          0

db is on md0

> select * from pg_activity_stat;
>

stats are not enabled :-\ (/me adds it to the list)
 
> Assuming activity stats is enabled...
> 
> 
> -- 
> Dan Langille
> 
> BSDCan - The Technical BSD Conference : http://www.bsdcan.org/
> PGCon  - The PostgreSQL Conference:     http://www.pgcon.org/
> 
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
> 

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users

<Prev in Thread] Current Thread [Next in Thread>