MySQL performance

[Alan DeKok]

Lorenzo Milesi wrote:
> Hi.
> I have a Freeradius server with MySQL backend, which has worked great so far. Right now we're increasing the users accounting here, and we're facing some login issues.  Freeradius is used as an accounting service for Chillispot. 
> 
> I tried increasing num_sql_socks to 14, and raised thread_concurrency to 8 in my.cnf, but yet on the client I get radius errors.
> 
> Could it be related to database performance?

  Yes.  Fix the database.

> Server load is normally below 0.10, cpu mostly unused. In radius.log I see no errors. 
> But on the client:
> radius.c: 235: No such id in radius queue: 76!
> radius.c: 1473: Matching request was not found in queue: 76!
> chilli.c: 3696: radius_ind() failed!
> 
> which can mean slow response times from the server. Sadly I have no way to increase radius request timeout on the client. 

  Don't.  Fix the database so that it isn't too slow.

> I believe it's not an issue with connection because I'm seeing this problem also on clients which always ran fine before the user increase.
> 
> How can I check FreeRadius is not suffering too many requests?

  See the logs.  If the DB is slow, the logs will usually say.