Slow Mysql Queries

[Marinko Tarlać]

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
>