Freeradius Mysql Performance

Morteza Milani fireboy.mrtz at
Sat Jan 28 10:57:01 CET 2012


Our company is using freeradius as a VPN authentication &
authorization system. In worse-case say we would have 1 Million users. Beside
scaling our market, we are going to develop an application to analyze
users with data mining algorithms.

Currently we use a server with the following features:

* RAM: 4 GB
* Processor: 1x E8400 3.0 GHz

For some queries it takes 15 seconds or more to get answer from mysql
specially when queries work with radacct table.

Any suggestion to improve performance?

Morteza Milani

More information about the Freeradius-Users mailing list