RES: FreeRadius + MySQL | radacct: Errors and Warnings
listas at dmnzs.com.br
Thu Oct 27 15:52:47 CEST 2011
> 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 too, no slow queries.
More information about the Freeradius-Users