Freeradius Mysql Performance

YvesDM ydmlog at
Sun Jan 29 10:42:44 CET 2012

On Sat, Jan 28, 2012 at 3:03 PM, Alan Buxey <A.L.M.Buxey at> 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 simple queries can be done
> against a passive slave server...
> alan


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

Kind regards,
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <>

More information about the Freeradius-Users mailing list