Freeradius Mysql Performance

[YvesDM]

On Sun, Jan 29, 2012 at 11:36 AM, Alan DeKok <aland at deployingradius.com>wrote:

> YvesDM wrote:
> > Just wondering, do you see performance increase using postgres instead
> > of mysql?
>
>   Yes.
>
>  MySQL can be higher performance than older versions of PostGreSQL, if
> you don't do database writes.  Newer versions of Postgres have similar
> performance to MySQL, with the benefit of allowing writes.
>
>  i.e. the "MyISAM" driver is fast but unsafe.  The "InnoDB" is slower
> but safe.  Postgres has the best of both.
>
> > I would rather think the opposite, but must admit that I'm no db expert
> > and have not much experience with postgres.
>
>   The main reason to use MySQL is familiarity.  That, and MySQL cluster.
>
>  For most normal systems, Postgresql is a better choice.
>
>  Alan DeKok.
>
>

Ok Alan,

I will not immediatelly will change the whole thing (indeed familiarity and
we have no issues with our tuned mysql so far), but I will sure keep this
post in mind.
Thx for the clear up.

Yves
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20120129/63036cf3/attachment.html>