Freeradius Mysql Performance

[YvesDM]

On Sat, Jan 28, 2012 at 3:03 PM, Alan Buxey <A.L.M.Buxey at lboro.ac.uk> wrote:

> What??
> You dont need that kind of hardware for job, sure. Throwing that kind of
> horsepower might fix the speed but this is a DBA question.
>
> Look at your mysql configuration and see how it can be adjusted (my.cnf)
> look at the engine in use and see if you can use better..(eg innodb instead
> of myisam), look at an alternative SQL eg postgres. Look at your usage of
> sql with freeradius, eg the radius tables. What indexes are present what do
> you need ,  what do you not need? Can you divide the work? Use one server
> for one table or task and the other another...eg simple queries can be done
> against a passive slave server...
>
> alan
>


Hi,

Sorry to pick into this with a short question.
Just wondering, do you see performance increase using postgres instead of
mysql?
I would rather think the opposite, but must admit that I'm no db expert and
have not much experience with postgres.

Kind regards,
Yves
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20120129/0a831cc0/attachment.html>