<br><br><div><span class="gmail_quote">On 3/2/06, <b class="gmail_sendername">David Watkins</b> <<a href="mailto:watkinshome@gmail.com">watkinshome@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On 02/03/06, Robert Tsai <<a href="mailto:rtsai1111@comcast.net">rtsai1111@comcast.net</a>> wrote:<br>> On Thu, Mar 02, 2006 at 08:59:04AM +0100, Niels Dybdahl wrote:<br>> > Is it possible to get a log from MythWeb or mysql on what sql
<br>> > requests are taking so long ?<br>><br>> Look in /var/log/mysql/mysql.log (or wherever your distro configured<br>> your MySQL logfiles) to see the queries in real-ish time.<br>><br><br>or maybe /var/log/httpd/ ??
</blockquote><div><br>This was also suggested by Ole Sandum. I looked into it and found that it was downloading utils.js, mouseovers.js and visibility.js every time.<br>There were no entries in the error log about these files, but I tried to download
mouseovers.js directly. After that the browser no more tries to download these three files and the time to open the program listings has decreased to 12 seconds. There is still a lot of mysqld activity during these 12 seconds.
<br><br>Niels Dybdahl<br><br></div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">_______________________________________________<br>mythtv-users mailing list
<br><a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br><a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br></blockquote></div>
<br>