Zitat von Alan Brown <ucas...@ucl.ac.uk>: > On 01/02/13 20:37, lst_ho...@kwsoft.de wrote: >> Zitat von Alan McKay <alan.mckay+bac...@gmail.com>: >> >>> OK, I know some of you guys are biased here because I recognise some >>> of the names from my pgsql days :-) >>> >>> I've been googling to find MySQL tuning instructions for bacula but >>> not much is coming up. Though I did find a 2 or 3 year old >>> discussion from this list which suggested I'd get better performance >>> from pgsql anyway. I certainly don't know pgsql as well as MySQL, >>> but I did used to know a fair bit about it and switching would not be >>> that big a deal to me. >> For most sites it doesn't really matter. If you know how to operate >> MySQL, use i >> it and it will work. If you have some specific needs you have to do >> performance evaluation anyway. >> > > If you have tens of millions of records then pgsql wins hands-down > over MySQL. > > That's from someone who spent a long time trying to tune MySQL for > such conditions before trying pgsql. > > > MySQL is good, but it simply doesn't scale that high without a lot > of work and it uses a _lot_ more memory than pgsql when it does. At > those scales pgsql "just works" and needs virtually zero tuning.
I would also not *recommend* MySQL, but most people can use it if they are familiar with, because the corner cases need careful evaluation and simpy asking for opinion is not an option for this cases anyway. Regards Andreas ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_jan _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
