Server Specification for freeradius

Jonathan Gazeley Jonathan.Gazeley at bristol.ac.uk
Mon Oct 19 14:28:17 CEST 2015


On 19/10/15 13:24, Haviaras Kostas wrote:
> So the only problem is how the MySQL Server can handle so many queries!
> Have you any suggestion or proposal about that ? Thanks
> -

Definitely not a question for the FreeRADIUS mailing list. However, in 
general, make sure your tables are indexed on every column you use in 
the WHERE clause and make sure the server has at least twice as much RAM 
as the size of the dataset. Use InnoDB storage engine and set the 
innodb_buffer_pool_size variable to be about 80% of your total system 
memory. Use the mysqltuner tool to help you tweak settings.

Jonathan


More information about the Freeradius-Users mailing list