[mythtv-users] Very large logs seen in mythconverg database

Michael T. Dean mtdean at thirdcontact.com
Tue Feb 19 18:25:53 UTC 2013


On 02/19/2013 01:12 PM, Dan Bernard wrote:
> I am running mythtv 0.25.2, and have had it running for maybe 6 months 
> with up to 15 recordings per week, and not using any schedules (all 
> manual), on a single tuner (hdhomerun).  I only keep recordings for 10 
> days, so around 30 show up in the list normally.
>
> I noticed that my available hard drive space had dropped somewhat, so 
> I checked the mysql/mythconverg database to see how much space that 
> was taking up.  Here are the largest 4 files:
> -rw-rw---- 1 mysql mysql 3.1M Feb 18 23:35 recordedseek.MYD
> -rw-rw---- 1 mysql mysql 3.1M Feb 18 23:35 recordedseek.MYI
> -rw-rw---- 1 mysql mysql 621M Feb 19 11:53 logging.MYI
> -rw-rw---- 1 mysql mysql 1.7G Feb 19 11:53 logging.MYD
>
> Why are those two logging files taking up over 2GB?  I'm not recording 
> a lot of shows, so I'm surprised at the large size.  I have a very 
> vanilla  install on Linux Mint 13.  Maybe that's normal, but I wanted 
> to ask if anybody considers that strange behavior..  I can't imagine 
> that keeping >2GB of logs is necessary.
>
> Thanks for your help!

Please post the output of the following commands (which you should be 
able to paste into the system shell--not directly into a mysql terminal):

mysql -umythtv -p mythconverg -e 'SHOW CREATE TABLE logging\G'
mysql -umythtv -p mythconverg -e 'SHOW TABLE STATUS LIKE 'logging'\G'
mysql -umythtv -p mythconverg -e 'SELECT COUNT(*) FROM logging\G'
mysql -umythtv -p mythconverg -e 'SELECT MAX(id) FROM logging\G'

I'm pretty sure I know what's going on, but this will allow me to 
confirm the theory.

Mike


More information about the mythtv-users mailing list