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@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@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