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. > So what do you think? > > Anyone have any specific links for MySQL + Bacula tuning? > Anyone have any datapoints on MySQL vs pgsql for Bacula? > > Will pgsql still have to be tuned? With PostgreSQL there are four parameters to tune: - shared_buffers : Should be raised to something reasonable in the range of some 100 M - checkpoint_segments and checkpoint_completion_target : Something about 10 - 20 segments should be fine and the completion target of 0.9 will smooth out writes - work_mem : The higher the more sorts are RAM based. This should speedup for example bvfs operation All taken from here: http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server 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
