Freeradius Mysql Performance
ydmlog at gmail.com
Sun Jan 29 10:42:44 CET 2012
On Sat, Jan 28, 2012 at 3:03 PM, Alan Buxey <A.L.M.Buxey at lboro.ac.uk> wrote:
> 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...
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.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Freeradius-Users