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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
