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

[Dan Bernard]

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


Thanks for your response.  Here is the output from those commands (must be
a syntax problem with the 2nd one):

$ mysql -umythtv -p mythconverg -e 'SHOW CREATE TABLE logging\G'
Enter password:
*************************** 1. row ***************************
       Table: logging
Create Table: CREATE TABLE `logging` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `host` varchar(64) NOT NULL DEFAULT '',
  `application` varchar(64) NOT NULL DEFAULT '',
  `pid` int(11) NOT NULL DEFAULT '0',
  `tid` int(11) NOT NULL DEFAULT '0',
  `thread` varchar(64) NOT NULL DEFAULT '',
  `filename` varchar(255) NOT NULL DEFAULT '',
  `line` int(11) NOT NULL DEFAULT '0',
  `function` varchar(255) NOT NULL DEFAULT '',
  `msgtime` datetime NOT NULL,
  `level` int(11) NOT NULL DEFAULT '0',
  `message` varchar(2048) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `host` (`host`,`application`,`pid`,`msgtime`),
  KEY `msgtime` (`msgtime`),
  KEY `level` (`level`)
) ENGINE=MyISAM AUTO_INCREMENT=20518438 DEFAULT CHARSET=utf8

$ mysql -umythtv -p mythconverg -e 'SHOW TABLE STATUS LIKE 'logging'\G'
Enter password:
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

$ mysql -umythtv -p mythconverg -e 'SELECT COUNT(*) FROM logging\G'
Enter password:
*************************** 1. row ***************************
COUNT(*): 28369

$ mysql -umythtv -p mythconverg -e 'SELECT MAX(id) FROM logging\G'
Enter password:
*************************** 1. row ***************************
MAX(id): 20518438

Thanks
Dan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20130219/2e140366/attachment.html>