Freeradius Mysql Performance
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
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.
On Sat, Jan 28, 2012 at 6:10 PM, Phil Mayers <p.mayers@imperial.ac.uk> wrote:
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.
Duh :P If you use interim updates, or you use radacct heavily (e.g. using simultaneous-use limit), or have high number of users online at the same time (e.g most of the 1-million user), then you're seriously underpowered. For starters, as a (very, very, rough) estimate, think something in the range of 2 servers, each with 2 x 4 cores, 256 GB RAM, and 16 HDD. And that doesn't include redundancy. Remember though, it's very rough estimate. It can be overkill, or still seriously underpowered, depending on your implementation detail.
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.
+1 Having someone who understands how FR works, plus a competent sysadmin, also helps.
Most likely you've got too many indices, or too many rows in the table.
... and need to do your homework, and calculate sizing requirements correctly. -- Fajar
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
participants (5)
-
Fajar A. Nugraha -
Giuseppe Marocchio -
Marinko Tarlac -
Morteza Milani -
Phil Mayers