RES: FreeRadius + MySQL | radacct: Errors and Warnings

Daniel Menezes listas at
Thu Oct 27 15:52:47 CEST 2011

Hi Tim,

> 1. User the InnoDB Engine in MySQL. 
I read about it and don't know if it's the best way.
Why InnoDB engine? MySAM engine is more fast.

> 2. Increase the number of SQL sockets in sql.conf (num_sql_socks). The
> default is 5, try 25.

> 3. Increase the number of connections (max_connections) in my.cnf to match
> the number of SQL sockets in sql.conf.

> 4. Enable the MySQL slow query log (slow_query_log) in my.cnf.
> 5. Check the MySQL slow query log file for problems.
I've enable the slow query and set up to 2 sec.
The log don't show any slow query ..
It's much time?
I've tested whith mtop[1] too, no slow queries.



Daniel Menezes


More information about the Freeradius-Users mailing list