RES: FreeRadius + MySQL | radacct: Errors and Warnings

[Daniel Menezes]

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.
Ok.

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

> 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.

Thanks!


Sds,

---
Daniel Menezes


Links:
[1] http://mtop.sourceforge.net/