<div dir="ltr"><br><div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, Jan 11, 2013 at 5:13 PM, Michael T. Dean <span dir="ltr"><<a href="mailto:mtdean@thirdcontact.com" target="_blank">mtdean@thirdcontact.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On 01/11/2013 12:18 AM, Juhani Rautiainen wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
<br>
Has anyone with the problems tried to log slow queries? This should<br>
pinpoint where the time is spent. Instructions:<br>
<a href="http://dev.mysql.com/doc/refman/5.5/en/slow-query-log.html" target="_blank">http://dev.mysql.com/doc/<u></u>refman/5.5/en/slow-query-log.<u></u>html</a> . From there<br>
some EXPLAIN and SHOW PROFILE for those queries should give concrete<br>
information instead of speculation. I haven't analyzed mysql queries but<br>
from Oracle side I've got over lots of experience. Principles should be<br>
similar.<br>
</blockquote>
<br>
Slowness is almost definitely not a problem with the SQL--that EIT SQL hasn't changed for years. It's most likely just that the EIT scanning thread is writing data to and, therefore, locking tables that are required for the scheduler to run. So, the scheduler thread is waiting on the EIT writes to complete/yield so it can finish. I wouldn't expect high MySQL CPU use due to a locking/wait issue, though, so I don't know what's causing that. <br>
</blockquote><div><br></div><div>As I said, I'm not that experienced with MySQL, put at least with Oracle this happens time to time. There the problem is changing size of data. That changes query execution plans. Sometimes queries that used to take under second can take minutes or hours (very rare). Usually this is related to table/index statistics and usually the change happen literally over night. And checking MySQL docs there are similar heuristics here. How the statistics are gotten in MySQL seem to vary between MyISAM and InnoDB. That's why I was suggesting checking for slow queries. If there are any, we could compare execution plans between systems. I don't see how logging slow queries hurts anything. At least you could easily rule this problem out.<br>
<br></div><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
Mike<br>
<br>
</blockquote></div><br></div><div class="gmail_extra">Juhani<br>-- <br>Juhani Rautiainen <a href="mailto:jrauti@iki.fi" target="_blank">jrauti@iki.fi</a>
</div></div>