Zitat von Alan Brown <ucasabr AT ucl.ac DOT uk>:

> On 01/02/13 20:37, lst_hoe02 AT kwsoft DOT de wrote:
>> Zitat von Alan McKay <alan.mckay+bacula AT gmail DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users