Reply to thread

Message

<blockquote data-quote="mm1352000" data-source="post: 760354" data-attributes="member: 82144">Hi VasilichAfter only a quick look at your logs it is very clear that something is wrong.First, in the TV Server logs you are getting Powerscheduler polling very often - approximately 1 time per second. That just seems too often to me.Second, you have a channelgroup missing from the DB:Third: if you look at your MySQL log, the level of activity there seems way over the top. By my count, around 17000 queries in 4 minutes.Finally, in your MySQL slow query log there are a some slow queries registered.-------------------------------------------------------------------------------------Okay, so what do we do? <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" />I wouldn't pay any attention to the MySQL slow query log. In this case it seems that the queries aren't that slow (although the 160ms one is a bit unusual). I think they are registered simply because the DB is working relatively hard...And why is the DB working so hard? I would say the Powerscheduler. The first thing I would do is disable that plugin and see if the problem goes away.It might be a good idea to delete the mappings for the channel group that no longer exists (DELETE FROM groupmap WHERE idGroup = 1). Having said that, channel group 1 should be the &quot;all channels&quot; group, and that should never be deleted. Do you have an &quot;all channels&quot; group?mm</blockquote>

[QUOTE="mm1352000, post: 760354, member: 82144"] Hi Vasilich After only a quick look at your logs it is very clear that something is wrong. First, in the TV Server logs you are getting Powerscheduler polling very often - approximately 1 time per second. That just seems too often to me. Second, you have a channelgroup missing from the DB: Third: if you look at your MySQL log, the level of activity there seems way over the top. By my count, around 17000 queries in 4 minutes. Finally, in your MySQL slow query log there are a some slow queries registered. ------------------------------------------------------------------------------------- Okay, so what do we do? :) I wouldn't pay any attention to the MySQL slow query log. In this case it seems that the queries aren't that slow (although the 160ms one is a bit unusual). I think they are registered simply because the DB is working relatively hard... And why is the DB working so hard? I would say the Powerscheduler. The first thing I would do is disable that plugin and see if the problem goes away. It might be a good idea to delete the mappings for the channel group that no longer exists (DELETE FROM groupmap WHERE idGroup = 1). Having said that, channel group 1 should be the "all channels" group, and that should never be deleted. Do you have an "all channels" group? mm [/QUOTE]

Verification