28 Jan
2012
28 Jan
'12
6:10 a.m.
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.