I have an LTO3 library installed behind a "modern AMD machine", a Sun v20z
biprocessor.
Again with Solaris 10 and postgres 8.
The avarage rate is 8Mb/s, and I have just some peak transfer rate of 14Mb/s
(and this is
way
tooslow for an LTO3), and this happens ONLY when Bacula is backing-up
somebig-big file (meaning that probably Bacula is working less with the
dbbecause the majority of work is about writing the data on the device,rather
than writing one db record).
On the same machine, I can measure very higher rates if I just roughly write
some data with tar.
About your "cute" answer, let me say that the Sun280R that is runningBacula and
Postgres on a Storedge LTO1, is the same machine that waspreviously running
Legato software for backup.
With Legato I could measure a throughput of 10-12Mb/s.
If I have both Bacula and postgres on this machine, I can have up to a 1Mb/s.
If I move both Director and Postgres in the LAN on to a newer x86machine (still
with solaris 10), and leave just the SD on the 280R, Ireach a maximum of 7Mb/s.
I have Bacula installed in many different ways, and everything makes me think
that Postgres is the problem.
Maybe I should put into some kind of trace the postgres db duringbackup, so to
have some useful statistics about the activities...
Gabriele Bulfon - Sonicle S.r.l.
Tel +39 028246016 Int. 30 - Fax +39 028243880
Via Felice Cavallotti 16 - 20089, Rozzano - Milano - ITALY
http://www.sonicle.com
----------------------------------------------------------------------------------
Da: Kern Sibbald <[EMAIL PROTECTED]>
A: bacula-users@lists.sourceforge.net
Cc: Ryan Novosielski <[EMAIL PROTECTED]> Gabriele Bulfon <[EMAIL PROTECTED]>
Bill Moran <[EMAIL PROTECTED]>
Data: 13 dicembre 2006 19.31.20 CET
Oggetto: Re: [Bacula-users] Postgres slow because of autocommit
On Wednesday 13 December 2006 18:46, Ryan Novosielski wrote:
> Kern Sibbald wrote:
>
> >> Moving the DB on another x86 / amd machine solve the problem, but I
anyway
> > can reach a maximum rate of 8-10Mb/sec, that is not the maximum transfer
rate
> > I may have on those LTO drives (that may run from 15 to 60 to 120 Mb/s
> > depending on the version).
> >
> > Try moving your tape drive to a "modern AMD or x86 machine" :-)
>
> I'm inclined to believe that's not necessary.
I was being a bit cute ...
> My director machine is a
> Sun UE450 3x296MHz, and the performance I get seems to be acceptable. My
> example numbers are 1213K/s (including spooling), or 41 mins for 3GB
> with a DAT72 drive. Is this slow?
Not for a DAT, but it is horrible for any LTO particularly if it is an LTO-3.
> I use MySQL4 on my machine.
>
> --
> ---- _ _ _ _ ___ _ _ _
> |Y#| | | |\/| | \ |\ | | | Ryan Novosielski - Systems Programmer III
> |$&| |__| | | |__/ | \| _| | [EMAIL PROTECTED] - 973/972.0922 (2-0922)
> \__/ Univ. of Med. and Dent.| IST/AST - NJMS Medical Science Bldg - C630
>
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
