Reply to thread

Message

Yes, it looks like the mysqld and tvservice are having quite a long "chat" when you press the down key in the EPG

Download the MySQL GUI Tools http://www.mysql.se/downloads/gui-tools/5.0.html and use MySQL Administrator to turn on query logging to see all the queries that are being sent to the MySQL Server. I couldn't find any particularly long running query but there are lots of SELECT's being sent. It also looks like every query has some "init" queries being run, probably used to determine the supported features of the server and to change to the tvlibrary database. Should only be necessary to do those once when the connection to server is setup. But they are probably from the .Net Connector. Maybe there is some setting that remoces the need for those.

From <program>\MySQL\MySQL Server 5.0\data\<hostname>.log
1 Change user root@localhost on TvLibrary
1 Query SHOW VARIABLES
1 Query SHOW COLLATION
1 Query SET character_set_results=NULL
1 Init DB tvlibrary
1 Query select idTuning, idChannel, name, provider, channelType, channelNumber, frequency, countryId, isRadio, isTv, networkId, transportId, serviceId, pmtPid, freeToAir, modulation, polarisation, symbolrate, diseqc, switchingFrequency, bandwidth, majorChannel, minorChannel, pcrPid, videoSource, tuningSource, videoPid, audioPid, band, satIndex, innerFecRate from TuningDetail where idChannel = 428

<blockquote data-quote="blaudden" data-source="post: 110732" data-attributes="member: 26996">Yes, it looks like the mysqld and tvservice are having quite a long &quot;chat&quot; when you press the down key in the EPGDownload the MySQL GUI Tools <a href="http://www.mysql.se/downloads/gui-tools/5.0.html" target="_blank">http://www.mysql.se/downloads/gui-tools/5.0.html</a> and use MySQL Administrator to turn on query logging to see all the queries that are being sent to the MySQL Server. I couldn't find any particularly long running query but there are lots of SELECT's being sent. <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite2" alt=";)" title="Wink&nbsp; &nbsp; ;)" loading="lazy" data-shortname=";)" /> It also looks like every query has some &quot;init&quot; queries being run, probably used to determine the supported features of the server and to change to the tvlibrary database. Should only be necessary to do those once when the connection to server is setup.&nbsp; But they are probably from the .Net Connector. Maybe there is some setting that remoces the need for those.From &lt;program&gt;\MySQL\MySQL Server 5.0\data\&lt;hostname&gt;.log&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 Change user root@localhost on TvLibrary&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 Query&nbsp; &nbsp; &nbsp;&nbsp; SHOW VARIABLES&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 Query&nbsp; &nbsp; &nbsp;&nbsp; SHOW COLLATION&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 Query&nbsp; &nbsp; &nbsp;&nbsp; SET character_set_results=NULL&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 Init DB&nbsp; &nbsp;&nbsp; tvlibrary&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 Query&nbsp; &nbsp; &nbsp;&nbsp; select idTuning, idChannel, name, provider, channelType, channelNumber, frequency, countryId, isRadio, isTv, networkId, transportId, serviceId, pmtPid, freeToAir, modulation, polarisation, symbolrate, diseqc, switchingFrequency, bandwidth, majorChannel, minorChannel, pcrPid, videoSource, tuningSource, videoPid, audioPid, band, satIndex, innerFecRate from TuningDetail where idChannel = 428</blockquote>

[QUOTE="blaudden, post: 110732, member: 26996"] Yes, it looks like the mysqld and tvservice are having quite a long "chat" when you press the down key in the EPG Download the MySQL GUI Tools [url]http://www.mysql.se/downloads/gui-tools/5.0.html[/url] and use MySQL Administrator to turn on query logging to see all the queries that are being sent to the MySQL Server. I couldn't find any particularly long running query but there are lots of SELECT's being sent. ;) It also looks like every query has some "init" queries being run, probably used to determine the supported features of the server and to change to the tvlibrary database. Should only be necessary to do those once when the connection to server is setup. But they are probably from the .Net Connector. Maybe there is some setting that remoces the need for those. From <program>\MySQL\MySQL Server 5.0\data\<hostname>.log 1 Change user root@localhost on TvLibrary 1 Query SHOW VARIABLES 1 Query SHOW COLLATION 1 Query SET character_set_results=NULL 1 Init DB tvlibrary 1 Query select idTuning, idChannel, name, provider, channelType, channelNumber, frequency, countryId, isRadio, isTv, networkId, transportId, serviceId, pmtPid, freeToAir, modulation, polarisation, symbolrate, diseqc, switchingFrequency, bandwidth, majorChannel, minorChannel, pcrPid, videoSource, tuningSource, videoPid, audioPid, band, satIndex, innerFecRate from TuningDetail where idChannel = 428 [/QUOTE]