[mythtv] Logo detection and TFW buffer exceeded
Craig Treleaven
ctreleaven at cogeco.ca
Fri Oct 12 20:06:50 UTC 2012
At 10:07 AM -0700 10/12/12, Chris Pinkham wrote:
>* On Fri Oct 12, 2012 at 09:49:11AM -0400, Craig Treleaven wrote:
>> >2012-10-12 08:27:25.633142 I [3240/12291] CoreContext
>> >ClassicCommDetector.cpp:359 (go) - Finding Logo
>
>Logo detection seeks around quite a bit looking at various
>samples within the video. One possibility may be that it is
>not be using the seektable and is having to read the whole file
>in instad going frame by frame to get to the new position.
>
>Can you check to see if your recordedseek table needs repairing
>with "repair table recordedseek;" in mysql?
>
>During playback, can you skip arounds recordings quickly or is
>that slow?
Thanks Chris. I run optimize_mythdb.pl daily. FFW and REW are fast.
To be sure, I ran the repair you mentioned directly:
> mysql5 -u mythtv -p -h 192.168.2.222 mythconverg
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1125
Server version: 5.1.65 Source distribution
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> repair table recordedseek;
+--------------------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+--------------------------+--------+----------+----------+
| mythconverg.recordedseek | repair | status | OK |
+--------------------------+--------+----------+----------+
1 row in set (7.55 sec)
I suppose it would have complained if the table was broken.
By chance, I noticed the commit to master from #11061 (Speed up TFW
recovery after falling behind on writes.) Is it possible that I'm
experiencing a consequence of this? Do you know if that patch is
going to be back-ported to .25-fixes?
Craig
More information about the mythtv-dev
mailing list