<div dir="ltr"><br><div dir="ltr"><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Jan 10, 2013 at 10:47 PM, Jarle Thorsen <span dir="ltr"><<a href="mailto:jarlethorsen@gmail.com" target="_blank">jarlethorsen@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>To sum up the information in this thread so far:<br><br></div>Several people report the same problem with high CPU usage for mysql (and unusable system) while the EIT rescheduling is runnnig. <br>
<br>None of us have seen any real improvement by removing barriers from our filesystem and we all have capable hardware. <br>
<br>Maybe it is just the fact that we have 100+ channels with EIT turned on that makes us affected by this "bug"? Maybe somebody with more mysql skills than me could have a look at the mysql-fu to see if the EIT rescheduling is as optimized as it can be? <span class=""><font color="#888888"><br>
</font></span></div></blockquote><div class="gmail_extra"><br><div><div>Hi!<br><br></div>Has anyone with the problems tried to log
slow queries? This should pinpoint where the time is spent. Instructions: <a href="http://dev.mysql.com/doc/refman/5.5/en/slow-query-log.html" target="_blank">http://dev.mysql.com/doc/refman/5.5/en/slow-query-log.html</a>
. From there some EXPLAIN and SHOW PROFILE for those queries should
give concrete information instead of speculation. I haven't analyzed
mysql queries but from Oracle side I've got over lots of experience.
Principles should be similar.<br></div><br>> Jarle Thorsen
</div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><span class=""></span></div>
<br></blockquote></div><br>Juhani <br clear="all">-- <br>Juhani Rautiainen <a href="mailto:jrauti@iki.fi" target="_blank">jrauti@iki.fi</a>
</div></div></div>