MySQL performance

[Fajar A. Nugraha]

On Mon, Sep 19, 2011 at 7:33 PM, Lorenzo Milesi
<lorenzo.milesi at yetopen.it> 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? Server load is normally below 0.10, cpu mostly unused.

is the db on the same server as freeradius?

> 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.
> 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?

there should be something on FR log file. If not, then run the server
in debug mode and see which part is slow or spitting out errors.

-- 
Fajar