On Sun, Aug 28, 2011 at 03:22:01PM +0200, Maria Arrea wrote:
> We are using bacula 5.0.3 with mysql 5.0.77 on RHEL 5.7 x64. We are backing
> tens millons of file and we are staring to see performance problems with
> mysql. Our server has 6 GB of ram and 1 quad core Intel Xeon E5520 @2.27 Ghz.
I went from
1. 4GB MySQL 5.1 MyISAM via
2. 16GB MySQL MyISAM via
3. 16GB MySQL InnoDB to
4. 8GB PostgreSQL 9.0
9M files in last full backup, 2TB data, 35 clients.
See Message-ID: <20110811154047.GA27976 AT r2d2.s.lihas DOT de>
Subject: Re: [Bacula-users] Performance with many files
2011-08-11 and 2011-07-06 for the background.
Postgres works so far, but I am only at month 4 of 13 now. A noteable
difference is the time needed for spooling jobs to one of my 1GB-sized
File-volumes. At the beginning it had been >3*1GB/minute with MySQL, but
the performance constantly decreased and in the end it had been
1GB/3minutes with otherwise unchanged disk-parameters (iSCSI-volume).
With Postgres I run at 2-3*1GB/minute for 1 month now. The limit is the
iSCSI-part, which I will get rid of soon.
Regards,
Adrian
--
LiHAS - Adrian Reyer - Hessenwiesenstraße 10 - D-70565 Stuttgart
Fon: +49 (7 11) 78 28 50 90 - Fax: +49 (7 11) 78 28 50 91
Mail: lihas AT lihas DOT de - Web: http://lihas.de
Linux, Netzwerke, Consulting & Support - USt-ID: DE 227 816 626 Stuttgart
------------------------------------------------------------------------------
EMC VNX: the world's simplest storage, starting under $10K
The only unified storage solution that offers unified management
Up to 160% more powerful than alternatives and 25% more efficient.
Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
