On Sat, Jan 28, 2012 at 3:03 PM, Alan Buxey <[email protected]> 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
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
