On Mon, 2010-06-07 at 18:24 +0200, Florian Heigl wrote:
> Hi all,
> 
> > Within psql/mysql:
> > 1) select count(*) from File;                    1sec    30min
> 

Is your MySQL database in the MyISAM format ? If yes, then it's
perfectly normal.

> Disclaimer: I don't know a dime's worth of databases per se. But I
> spend a lot of time hunting other peoples performance issues. :)
> 
> I think you should start identifying the cause for this bit at the
> very first, as it shows the absolutely worst perfomance and probably
> what slows this also slows the rest.
> My nose says this is really smelly and should'nt even take as long
> without any indexes.
> 
> Can you verify whether the system swaps during your test commands or doesn't?
> 
> sar -dp 100 1 | grep -v nodev will do nicely with the external storage.
> 
> also can you please let us know the iowait times (also from sar) and
> promise it's not a Raid5 array you have in use?
> (but, admittedly it doesn't explain for a big difference between mysql
> and postgresql)
> 
> Also, I don't know if I would value RedHat supporting postgre 8.1
> higher than running 8.4.1  :)
> 
> 
> Florian
> 



------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate 
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the 
lucky parental unit.  See the prize list and enter to win: 
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users