<div dir="ltr"><div><div><pre>On 02/19/2013 01:12 PM, Dan Bernard wrote:
>><i> I am running mythtv 0.25.2, and have had it running for maybe 6 months
</i>>><i> with up to 15 recordings per week, and not using any schedules (all
</i>>><i> manual), on a single tuner (hdhomerun). I only keep recordings for 10
</i>>><i> days, so around 30 show up in the list normally.
</i>>><i>
</i>>><i> I noticed that my available hard drive space had dropped somewhat, so
</i>>><i> I checked the mysql/mythconverg database to see how much space that
</i>>><i> was taking up. Here are the largest 4 files:
</i>>><i> -rw-rw---- 1 mysql mysql 3.1M Feb 18 23:35 recordedseek.MYD
</i>>><i> -rw-rw---- 1 mysql mysql 3.1M Feb 18 23:35 recordedseek.MYI
</i>>><i> -rw-rw---- 1 mysql mysql 621M Feb 19 11:53 logging.MYI
</i>>><i> -rw-rw---- 1 mysql mysql 1.7G Feb 19 11:53 logging.MYD
</i>>><i>
</i>>><i> Why are those two logging files taking up over 2GB? I'm not recording
</i>>><i> a lot of shows, so I'm surprised at the large size. I have a very
</i>>><i> vanilla install on Linux Mint 13. Maybe that's normal, but I wanted
</i>>><i> to ask if anybody considers that strange behavior.. I can't imagine
</i>>><i> that keeping >2GB of logs is necessary.
</i>>><i>
</i>>><i> Thanks for your help!
</i>
>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
</pre><br></div>Thanks for your response. Here is the output from those commands (must be a syntax problem with the 2nd one):<br><br>$ mysql -umythtv -p mythconverg -e 'SHOW CREATE TABLE logging\G'<br>Enter password: <br>
*************************** 1. row ***************************<br> Table: logging<br>Create Table: CREATE TABLE `logging` (<br> `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,<br> `host` varchar(64) NOT NULL DEFAULT '',<br>
`application` varchar(64) NOT NULL DEFAULT '',<br> `pid` int(11) NOT NULL DEFAULT '0',<br> `tid` int(11) NOT NULL DEFAULT '0',<br> `thread` varchar(64) NOT NULL DEFAULT '',<br> `filename` varchar(255) NOT NULL DEFAULT '',<br>
`line` int(11) NOT NULL DEFAULT '0',<br> `function` varchar(255) NOT NULL DEFAULT '',<br> `msgtime` datetime NOT NULL,<br> `level` int(11) NOT NULL DEFAULT '0',<br> `message` varchar(2048) NOT NULL,<br>
PRIMARY KEY (`id`),<br> KEY `host` (`host`,`application`,`pid`,`msgtime`),<br> KEY `msgtime` (`msgtime`),<br> KEY `level` (`level`)<br>) ENGINE=MyISAM AUTO_INCREMENT=20518438 DEFAULT CHARSET=utf8<br><br>$ mysql -umythtv -p mythconverg -e 'SHOW TABLE STATUS LIKE 'logging'\G'<br>
Enter password: <br>ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'logging' at line 1<br><br>$ mysql -umythtv -p mythconverg -e 'SELECT COUNT(*) FROM logging\G'<br>
Enter password: <br>*************************** 1. row ***************************<br>COUNT(*): 28369<br><br>$ mysql -umythtv -p mythconverg -e 'SELECT MAX(id) FROM logging\G'<br>Enter password: <br>*************************** 1. row ***************************<br>
MAX(id): 20518438<br><br></div>Thanks<br>Dan<br></div>