Freeradius Mysql Performance

Alan Buxey A.L.M.Buxey at
Sat Jan 28 15:03:17 CET 2012

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...


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

More information about the Freeradius-Users mailing list