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 < [email protected]> 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
