Slow Mysql Queries
    OzSpots - Carl Sawers 
    carl at ozspots.com.au
       
    Mon Jun  6 03:05:29 CEST 2011
    
    
  
Thanks Guys, 
The slow query log has a lot of entry's in it. It's not obvious which
are causing the most issues but I have found a script that was always
slowish so have removed it. The line read
# Query_time: 5  Lock_time: 0  Rows_sent: 3  Rows_examined: 17286222
No idea where it thinks there are that may rows...
A script which outputs all the active users from radcheck shows this in
the slow query log
# Query_time: 0  Lock_time: 0  Rows_sent: 84  Rows_examined: 32992
Are all the slow query entries potentially a problem, I mean should
there be any entries in there at all? While the scripts have changed
slightly this DB worked fine on the last server - could it have been
corrupted from the sql txt file import perhaps? (via phpadmin)
Regards Carl
    
    
More information about the Freeradius-Users
mailing list