Freeradius Mysql Performance

Phil Mayers p.mayers at
Sat Jan 28 12:10:27 CET 2012

On 01/28/2012 09:57 AM, Morteza Milani wrote:
> Hi,
> 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?

This isn't really a FreeRADIUS question. It's an SQL question, and you 
want a trained DBA to inspect the DB.

Most likely you've got too many indices, or too many rows in the table.

More information about the Freeradius-Users mailing list