Slow request response for auth/acct

[Marco Marino]

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