Reply to thread

Message

<blockquote data-quote="ianc" data-source="post: 829411" data-attributes="member: 63303">mmI checked the TVServer logs before and after doing the clnt side EPG scroll - Interestngly no log activity at all.&nbsp; I can't see a way of adjusting the detail level for the TVServer logI then checked MySQL via mysql-&gt;status and got this[CODE]mysql&gt; status--------------mysql&nbsp; Ver 14.14 Distrib 5.1.38, for Win32 (ia32)Connection id:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 91SSL:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Not in useUsing delimiter:&nbsp; &nbsp; &nbsp; &nbsp; ;Server version:&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 5.1.38-community MySQL Community Server (GPL)Protocol version:&nbsp; &nbsp; &nbsp;&nbsp; 10Connection:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; localhost via TCP/IPClient characterset:&nbsp; &nbsp; utf8Server characterset:&nbsp; &nbsp; utf8TCP port:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 3306Uptime:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 4 days 6 hours 50 min 25 secThreads: 6&nbsp; Questions: 1177547&nbsp; Slow queries: 8&nbsp; Opens: 908&nbsp; Flush tables: 1&nbsp; Open tables: 17&nbsp; Queries per second avg: 3.180--------------mysql&gt;[/CODE]So it does seem to be showing slow queries.&nbsp; I downloaded MySQL Workbench to see if it could tell me which one were slow.&nbsp; I couldn't get it to do so.&nbsp; I did turn on slow-query-log and specified a log file - but nothing in it...Thoughts?</blockquote>

[QUOTE="ianc, post: 829411, member: 63303"] mm I checked the TVServer logs before and after doing the clnt side EPG scroll - Interestngly no log activity at all. I can't see a way of adjusting the detail level for the TVServer log I then checked MySQL via mysql->status and got this [CODE]mysql> status -------------- mysql Ver 14.14 Distrib 5.1.38, for Win32 (ia32) Connection id: 91 SSL: Not in use Using delimiter: ; Server version: 5.1.38-community MySQL Community Server (GPL) Protocol version: 10 Connection: localhost via TCP/IP Client characterset: utf8 Server characterset: utf8 TCP port: 3306 Uptime: 4 days 6 hours 50 min 25 sec Threads: 6 Questions: 1177547 Slow queries: 8 Opens: 908 Flush tables: 1 Op en tables: 17 Queries per second avg: 3.180 -------------- mysql>[/CODE] So it does seem to be showing slow queries. I downloaded MySQL Workbench to see if it could tell me which one were slow. I couldn't get it to do so. I did turn on slow-query-log and specified a log file - but nothing in it... Thoughts? [/QUOTE]

Verification