Check this link and the described tools
http://www.serveradminblog.com/2011/03/tuning-mysql-performance-howto-part-1/
Turn the slow query log ON so you can see the slow queries.
Also, check the disk(s). Is write cache enabled?
Do you have any external scripts for auth/acc ? They can be the reason
for this... You can notice this problem with
# ps ax|grep radiusd
and search for radiusd <defunct>
On 06/04/2011 12:47 PM, OzSpots - Carl Sawers wrote:
Hi All, I have a freeradius server which has some slow mysql queries and
some errors like the below happen now and again(daily).
We have actually just upgraded to this server and have imported all the
MYsql data into the new server (it was working fine on the older quite
similar server). One thing I have noticed; the server boots with around
280mb of ram used but after an hour or two is closer to 400mb used and
stays around this point until rebooted again.
My research says that the tables need to be indexed but it seems I would
have to manually do this and I don't know which ones would need it
anyway... and why would this be the case when it wasn't needed
previously.
The other thing that I have noticed is what appear to be doubled up
entries in radius.log, (check the times) Anyone know what this could be?
Fri Jun 3 19:40:30 2011 : Auth: Login incorrect:
[E4-CE-8F-85-A5-E4/password] (from client localhost port 3 cli
E4-CE-8F-85-A5-E4)
Fri Jun 3 19:40:31 2011 : Auth: Login incorrect:
[E4-CE-8F-85-A5-E4/password] (from client localhost port 3 cli
E4-CE-8F-85-A5-E4)
Fri Jun 3 19:40:31 2011 : Auth: Login incorrect:
[E4-CE-8F-85-A5-E4/password] (from client localhost port 3 cli
E4-CE-8F-85-A5-E4)
Fri Jun 3 19:40:31 2011 : Auth: Login incorrect:
[E4-CE-8F-85-A5-E4/password] (from client localhost port 3 cli
E4-CE-8F-85-A5-E4)
Fri Jun 3 19:40:32 2011 : Auth: Login incorrect:
[E4-CE-8F-85-A5-E4/password] (from client localhost port 3 cli
E4-CE-8F-85-A5-E4)
---------------
Here are the server errors:
Fri Jun 3 19:39:40 2011 : Error: Discarding duplicate request from
client localhost:61924 - ID: 210 due to unfinished request 5001
Fri Jun 3 19:39:40 2011 : Error: WARNING: Unresponsive child (id
2995579792) for request 5008 (in component accounting module rlm_sql)
Fri Jun 3 19:39:40 2011 : Error: Discarding duplicate request from
client localhost:61924 - ID: 211 due to unfinished request 5009
Fri Jun 3 19:39:40 2011 : Info: rlm_sql (sql): There are no DB handles
to use! skipped 0, tried to connect 0
Fri Jun 3 19:39:41 2011 : Info: rlm_sql (sql): There are no DB handles
to use! skipped 0, tried to connect 0
Fri Jun 3 19:39:41 2011 : Info: rlm_sql (sql): There are no DB handles
to use! skipped 0, tried to connect 0
Fri Jun 3 19:39:41 2011 : Error: Discarding duplicate request from
client localhost:2048 - ID: 32 due to unfinished request 5008
Fri Jun 3 19:39:43 2011 : Error: Discarding duplicate request from
client localhost:61924 - ID: 210 due to unfinished request 5001
Fri Jun 3 19:39:43 2011 : Error: Discarding duplicate request from
client localhost:61924 - ID: 211 due to unfinished request 5009
Fri Jun 3 19:39:44 2011 : Error: Discarding duplicate request from
client localhost:2048 - ID: 32 due to unfinished request 5008
Fri Jun 3 19:39:46 2011 : Error: Discarding duplicate request from
client localhost:61924 - ID: 210 due to unfinished request 5001
Fri Jun 3 19:39:46 2011 : Error: Discarding duplicate request from
client localhost:61924 - ID: 211 due to unfinished request 5009
Fri Jun 3 19:39:46 2011 : Info: rlm_sql (sql): There are no DB handles
to use! skipped 0, tried to connect 0
Fri Jun 3 19:39:47 2011 : Error: Discarding duplicate request from
client localhost:2048 - ID: 32 due to unfinished request 5008
Fri Jun 3 19:39:47 2011 : Error: WARNING: Unresponsive child (id
2985089936) for request 5009 (in component accounting module rlm_sql)
Fri Jun 3 19:39:49 2011 : Error: Discarding duplicate request from
client localhost:61924 - ID: 211 due to unfinished request 5009
Fri Jun 3 19:39:49 2011 : Info: rlm_sql (sql): There are no DB handles
to use! skipped 0, tried to connect 0
Fri Jun 3 19:39:50 2011 : Info: rlm_sql (sql): There are no DB handles
to use! skipped 0, tried to connect 0
Regards Carl
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
