Hello Stephan,
Thanks for your feeback, sometime, few users have performance problem due to
bad
settings and can give bad advise or the impression that nothing can be done
whereas it works well
on ten of thousand of silent users.
In this case the performance problem is due to the presence of bad and
useless indexes on the
database. Just use the default schema, don't add anything, and it will work
like a charm
(proper my.cnf could also help of course).
With those extra indexes, it was looking to work with 3.0.3, but not with
5.0.x. anymore.
IMHO, MySQL (and probably PostgreSQL) try to use them for the new query and
performances are
bad (yes indexes aren't always the solution to speedup database
performance).
When I see sites like yours that run very big jobs in few minutes, and
others that should wait days
the difference has big chance to come from configuration mistake and extra
tuning... In this kind of
situation, the best way to avoid problems is asking for profesionnal help.
In your case, if you want to wait only a couple of seconds (instead of
minutes), you can think to
switch on PostgreSQL, but it doesn't look like to be a problem for you :-)
Anyway if you give only a
couple of bytes to run sort and join operations (default settings) or you
add bad indexes, performance will be bad.
Thanks for using Bacula, and feel free to fill a testimonial on
www.bacula.org, your setup looks to be very interesting!
Bye
Stephen Thompson wrote:
>
>
> Heya,
>
> This response isn't advice, just a statement about how 5.0.1 is working
> out for me in a mysql environment. I've read a lot of concerns out
> there and like you say, there are issues, but no magic bullet, so I too
> am trying to understand the situation so as not to create problems for
> myself now or down the road.
>
> My catalog...
>
> mysql-5.0.77 (64bit) MyISAM
> 210Gb in size
> 1,412,297,215 records in File table
> note: database built with bacula 2x scripts,
> upgraded with 3x scripts, then again with 5x scripts
> (i.e. nothing customized along the way)
>
> My OS & hardware for bacula DIR+SD server...
>
> Centos 5.4 (fully patched)
> 8Gb RAM
> 2Gb Swap
> 1Tb EXT3 filesystem on external fiber RAID5 array
> (dedicated to database, incl. temp files)
> 2 dual-core [AMD Opteron(tm) Processor 2220] CPUs
>
> My experience...
>
> I was worried when I migrated to 5.x because I had heard of slow
> mysql issues, but building the "most recent" restore tree for a 1.23Tb
> 6,578,204-files FileSet takes just under 5 minutes. That response time
> seems reasonable and acceptable to me.
>
> Hope this info helps at least define what's possible -- would be nice
> to see more stats about the bacula community in general.
>
> Good luck!
>
> thanks,
> Stephen
>
>
> On 04/13/2010 05:42 AM, Koldo Santisteban wrote:
>> Hello
>> I am working with bacula 5.0.1. On first stage i setup the server with
>> bacula 5.0.1 and Mysql, but, when i need to restore i have found that
>> "the bulid tree process" take 10-12 hours (or more). I have read all
>> about this issues and i can see that no exists any "magic" solution. In
>> order to solve it, i have migrate from mysql to postgre, but i can see
>> the same symtopms. Perhaps it works better, but, in my opnion, this is
>> not serios on a production environment.
>> If it´s possible, i will appreciate it people share their experience
>> with bacula last version and this kind of issues. A couple of month ago
>> i finished to deploy bacula on my environment, but now, i am considering
>> to go back all.
>> Please any comment regarding this case is welcome.
>> Regards
>>
>>
>>
>
--
View this message in context:
http://old.nabble.com/bacula-5.0.1-and-db-issues---please%2C-share-your-experience-tp28229717p28247718.html
Sent from the Bacula - Users mailing list archive at Nabble.com.
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
