Hi Michael,<br><br>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).<br>
<br>Thanks,<br><br>Dinh<br><br><div class="gmail_quote">On Wed, Nov 11, 2009 at 12:22 AM, Michael da Silva Pereira <span dir="ltr">&lt;<a href="mailto:michael@tradepage.co.za">michael@tradepage.co.za</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">Hi Dinh,<br>
<br>
max_request_time is 10 seconds, have you switched on mysql slow query /<br>
non-index lookups logging ? (in my.cnf &#39;#log_slow_queries<br>
= /var/log/mysql/mysql-slow.log&#39; ).<br>
If the log file has nothing in it during the testing great, then MySQL<br>
is happy. If you have queries taking longer than &#39;#long_query_time&#39;<br>
there might be a problem.<br>
<br>
Regards,<br>
<font color="#888888">Michael<br>
</font><div><div></div><br></div></blockquote></div><br>