Accounting on SQL - sleep time

[Andrés Gómez]

Hi dear list.

I have 3 freeradius servers using the same version and configuration. The
first one is the primary radius server for many access points and the
second and third one are the secundary radius server fo the same access
points.

The behavior should be the same (because I use the same version and
configuration of freeradius) but in the MySQL server I see that accounting
queries from the 1st (main) one are closed very fast (least of 1 second).
In the mysql process usually appears with 0 or 1 second of duration time:

|    3502 | user | FIRST:42048  | radius | Sleep   |    1 |       |
NULL             |         0 |             1 |
|    3504 | user | FIRST:42050  | radius | Sleep   |    1 |       |
NULL             |         0 |             0 |
|    3505 | user | FIRST:42052  | radius | Sleep   |    1 |       |
NULL             |         0 |             0 |

But about the queries from 2nd or 3th server are not closed, so I can see
process opened from a lot of time ago:

| 1912220 | user | SECOND:36298   | radius | Sleep   | 7471 |       |
NULL             |         0 |             0 |
| 1913262 | user | SECOND:37010   | radius | Sleep   | 7077 |       |
NULL             |         0 |             0 |
| 1913816 | user | SECOND:37384   | radius | Sleep   | 6871 |       |
NULL             |         0 |             0 |


| 1948365 | user | THIRD:39115  | radius | Sleep   |  733 |       |
NULL             |         0 |             0 |
| 1948368 | user | THIRD:39117  | radius | Sleep   |  733 |       |
NULL             |         0 |             0 |
| 1948369 | user | THIRD:39118  | radius | Sleep   |  733 |       |
NULL             |         0 |             0 |

What can I check?

Thanks in advance!

Regards



-- 
*C. Andrés Gómez R.*