Slow request response for auth/acct

[Marco Marino]

Sorry.... Is there something that I can do for better performance?
Buffered-sql for accounting could be a solution, but how can I increase the
number of connections per client?
thank you

2016-07-15 10:46 GMT+02:00 Marco Marino <marino.mrc at gmail.com>:

> Hi Alan, thank you for your support.
> 1)  Actually I have
> thread pool {
>         start_servers = 5
>          max_servers = 32
>         min_spare_servers = 3
>         max_spare_servers = 10
>        max_requests_per_server = 0
> }
> Furthermore, in sql.conf
> num_sql_socks = 10
>
> But I don't know where I can set the number of connections per client
>
> 2) I'm using InnoDB, checked settings with mysqltuner and mysql tuning
> primer
> 3) I can have a slight delay in accounting requests if freeradius in the
> meantime responds ok to the request, so clients don't have to wait mysql
> write. Is this possible with freeradius 2.x??
> 4) Unfortunately I cannot upgrade at the moment. But seriously, I'm
> planning the upgrade.
>
> Marco
> Regards
>
> 2016-07-15 10:19 GMT+02:00 <A.L.M.Buxey at lboro.ac.uk>:
>
>> Hi,
>>
>> > When I try an authentication request, it seems too slow:
>>
>> yep
>>
>> > I have only 3 clients and in radius.log I see a lot of
>>
>> only 3 clients could be a small issue - each client can only have a
>> limited number of RADIUS
>> connections.  the main issue is number of users - and amount of
>> accounting transactions
>> being undertaken due to them. authentication isnt the headache that
>> accounting is.
>>
>> so,
>>
>> 1) have you tweaked any of the SQL settings for performance in FreeRADIUS
>> eg have more connections
>> number of connections per client etc?
>>
>> 2) MyISAM or InnoDB if using MySQL ?  former is default..and sucks. use
>> InooDB if using MySQL.
>>
>>
>> 3) do you need realtime accounting or can you have a slight delay of
>> seconds? if the latter, then
>> consider using the buffered-sql virtual server
>>
>> 4) upgrade
>>
>>
>> alan
>> -
>> List info/subscribe/unsubscribe? See
>> http://www.freeradius.org/list/users.html
>
>
>