Re: Server Specification for freeradius

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