Freeradius Mysql Performance
p.mayers at imperial.ac.uk
Sat Jan 28 12:10:27 CET 2012
On 01/28/2012 09:57 AM, Morteza Milani wrote:
> 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