Freeradius Mysql Performance

[Giuseppe Marocchio]

Dear,

i've got same problem in the first time that i use freeradius,

first of all, you need to tune your mysql ( my.cnf ) with right
optimization, you can enable slow query logging in order to check if is
mysql or freeradius problem.

when your mysql works fine, you can tune freeradius, like increase sql
connection and other params, into the archive of ML you can find more
information.


Kindly regards

On Sat, 2012-01-28 at 13:27 +0330, 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?
> 
> Regards,
> Morteza Milani
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

-- 
Giuseppe Marocchio
Tel: (+39) 045.5116192
Fax: (+39) 045.5111197
skype: giuseppe.marocchio