This seems a lot similar to my Postgres problem on some systems:
- when backing up big files, the transfer rate is maximized (and db work is poor, just one record for each big file)
- when backing up many small files, the transfer rate is reduced by 8-10 times (and db work is rich, one record for each small file)
Maybe you have some similar suggestion to MySql for Postgres?
Gabriele.
----------------------------------------------------------------------------------
Da: Ryan Novosielski <[EMAIL PROTECTED]>
A: Kern Sibbald <[EMAIL PROTECTED]>
Cc: Dirk H. Schulz <[EMAIL PROTECTED]> bacula-users@lists.sourceforge.net
Data: 6 ottobre 2006 20.28.28 CEST
Oggetto: Re: [Bacula-users] Slow down with MySQL as a backend
- when backing up big files, the transfer rate is maximized (and db work is poor, just one record for each big file)
- when backing up many small files, the transfer rate is reduced by 8-10 times (and db work is rich, one record for each small file)
Maybe you have some similar suggestion to MySql for Postgres?
Gabriele.
|
|
|
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: Ryan Novosielski <[EMAIL PROTECTED]>
A: Kern Sibbald <[EMAIL PROTECTED]>
Cc: Dirk H. Schulz <[EMAIL PROTECTED]> bacula-users@lists.sourceforge.net
Data: 6 ottobre 2006 20.28.28 CEST
Oggetto: Re: [Bacula-users] Slow down with MySQL as a backend
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Kern Sibbald wrote:
>> I know I can answer all these questions on my own by simply testing on
>> and on - but since one test (setting up the backup server, optimizing
>> configs, running at least one backup, evaluating the results) takes at
>> least 3 days, I would appreciate any comment and hint on this.
>
> For the size of operation you are using, I personally wouldn't even consider
> using SQLite. I also strongly recommend Bacula 1.38.11, and for MySQL, make
> sure you read the database maintenance chapter -- I think you need something
> like mybig.cnf (I forget the exact name) so that MySQL is tuned to use a lot
> of memory and thus handle a large number of files.
>
> The users of this list can surely give you more details better than I can.
my-large.cnf or my-huge.cnf -- see which one is of interest, Dirk.
- --
---- _ _ _ _ ___ _ _ _
|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
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFFJqBMmb+gadEcsb4RAiOaAJsG3KOsOkIMH64dXu9BBOEUCvwnbwCfeqYi
NyGAIvfQHI4OlN9pBu5eoJs=
=PpqA
-----END PGP SIGNATURE-----
-------------------------------------------------------------------------
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
------------------------------------------------------------------------- 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
