Ok, well there would be no point going sub second, as long as its a reasonable amount. Have you tried using a perl or python module to handle the auth / acct? Thanks, Michael On Wed, 2009-11-11 at 00:36 +0700, Dinh Pham Cong wrote:
Hi Michael,
Yes I have enabled MySQL slow query log for all queries that take more than 1s for execution. I have found 2 slow queries only (INSERT) in one server and no slow query on the other. Because I installed MySQL using a rpm package so I can not patch it with microslow patch to enable logging queries that takes less than a second (e.x 0.5 second).
Thanks,
Dinh
On Wed, Nov 11, 2009 at 12:22 AM, Michael da Silva Pereira <michael@tradepage.co.za> wrote: Hi Dinh,
max_request_time is 10 seconds, have you switched on mysql slow query / non-index lookups logging ? (in my.cnf '#log_slow_queries = /var/log/mysql/mysql-slow.log' ). If the log file has nothing in it during the testing great, then MySQL is happy. If you have queries taking longer than '#long_query_time' there might be a problem.
Regards, Michael
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html