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