[mythtv-users] [mythtv] MySQL database location

R. G. Newbury newbury at mandamus.org
Thu Oct 18 16:56:26 UTC 2007


Mitch Gore wrote:
> On 10/17/07, Michael T. Dean <mtdean at thirdcontact.com> wrote:
>> On 10/17/2007 05:40 PM, Mitch Gore wrote:
>>>> On Wed, 2007-10-17 at 16:23 -0500, Mitch Gore wrote:
>>>>
>>>>> I have my partition layout as so:
>>>>>
>>>>> [myth at mythtv ~]$ df -h
>>>>> Filesystem            Size  Used Avail Use% Mounted on
>>>>> /dev/sdb1             6.7G  5.8G  538M  92% /
>>>>> tmpfs                 506M     0  506M   0% /dev/shm
>>>>> /dev/sdb3             444G  399G   23G  95% /video
>>>>> /dev/sda1             111G   92G   14G  88% /video2
>>>>>
>>>>>
>>>>> I am using storage groups for my recordings and they are in /video
>>>>> and /video2.
>>>>>
>>>>> Over the months of building this box i have noticed my / free space
>>>>> shrinking.  I am thinking this is because of my database.  Where is
>>>>> the DB actually stored on FC6?
>> The database is /very/ unlikely to be filling up your partition.  The
>> largest my database has ever gotten was around 400MB and that was with
>> almost 500 hours (= almost 21 days) of MPEG-2 recordings (almost all of
>> the space taken up by the DB for Myth will be dedicated to the
>> seektable--which grows linearly with amount (time) of recorded TV
>> available to watch, and will be decreased as shows are deleted).  The
>> rest tends to stay relatively constant in size.
>>
>> My DB is currently 133MB with 232 hours and 40 minutes (9 2/3 days) of
>> recorded TV.
>>
>> I would bet--if it's not data--that it's your log files taking up the
>> space--specifically, MySQL binary log files.
>>
>>
>> http://www.gossamer-threads.com/lists/engine?list=mythtv&do=search_results&search_forum=all&search_string=%22binary+log%22
>>
>> Mike
>>
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>>
> 
> Yea its not the database... i think a big deal is my logs:
> 
> [root at mythtv log]# ls -lh
> total 1.5G
> -rw-r----- 1 root  root   60K Oct 13 20:33 acpid
> -rw------- 1 root  root  140K Aug 24 07:44 anaconda.log
> -rw------- 1 root  root   23K Aug 24 07:44 anaconda.syslog
> -rw------- 1 root  root   47K Aug 24 07:44 anaconda.xlog
> -rw------- 1 root  root     0 Oct 14 04:54 boot.log
> -rw------- 1 root  root   258 Oct 13 20:25 boot.log.1
> -rw------- 1 root  root   498 Oct  6 10:33 boot.log.2
> -rw------- 1 root  root     0 Sep 23 04:49 boot.log.3
> -rw------- 1 root  root     0 Sep 16 04:48 boot.log.4
> -rw------- 1 root  utmp   13M Oct 17 18:00 btmp
> -rw------- 1 root  root  7.2K Oct 17 19:01 cron
> -rw------- 1 root  root   15K Oct 14 04:42 cron.1
> -rw------- 1 root  root   18K Oct  7 05:02 cron.2
> -rw------- 1 root  root   15K Sep 30 04:42 cron.3
> -rw------- 1 root  root   16K Sep 23 04:42 cron.4
> drwxr-xr-x 2 lp    sys   4.0K Oct 14 04:54 cups
> -rw-r--r-- 1 root  root   20K Oct 13 20:33 dmesg
> -rw------- 1 root  root  2.4K Aug 24 14:50 faillog
> drwxr-xr-x 2 root  root  4.0K Oct 13 20:33 gdm
> drwx------ 2 root  root  4.0K Oct 14 04:54 httpd
> -rw-r--r-- 1 root  root  143K Oct 17 18:58 lastlog
> drwxr-xr-x 2 root  root  4.0K Aug 24 07:38 mail
> -rw------- 1 root  root  6.8K Oct 17 04:49 maillog
> -rw------- 1 root  root   14K Oct 14 04:49 maillog.1
> -rw------- 1 root  root   19K Oct  7 05:13 maillog.2
> -rw------- 1 root  root   14K Sep 30 04:42 maillog.3
> -rw------- 1 root  root   16K Sep 23 04:44 maillog.4
> -rw------- 1 root  root  1.5K Oct 17 12:05 messages
> -rw------- 1 root  root  706M Oct 14 01:09 messages.1
> -rw------- 1 root  root  519M Oct  7 05:19 messages.2
> -rw------- 1 root  root  270K Sep 28 22:24 messages.3
> -rw------- 1 root  root  244M Sep 23 04:49 messages.4
> -rw-r----- 1 mysql mysql  36K Oct 13 20:33 mysqld.log
> drwxr-xr-x 2 root  root  4.0K Oct 17 16:30 mythtv
> drwx------ 2 root  root  4.0K Dec  1  2006 ppp
> drwxr-xr-x 2 root  root  4.0K Aug 24 09:10 prelink
> -rw-r--r-- 1 root  root   33K Oct 17 04:49 rpmpkgs
> -rw-r--r-- 1 root  root   33K Oct 13 04:54 rpmpkgs.1
> -rw-r--r-- 1 root  root   33K Oct  6 05:10 rpmpkgs.2
> -rw-r--r-- 1 root  root   33K Sep 29 04:48 rpmpkgs.3
> -rw-r--r-- 1 root  root   32K Sep 22 04:50 rpmpkgs.4
> drwx------ 3 root  root  4.0K Oct 17 17:59 samba
> -rw-r--r-- 1 root  root  5.6K Oct 17 04:49 sa-update.log
> -rw-r--r-- 1 root  root   12K Sep 30 04:48 sa-update.log.1
> -rw-r--r-- 1 root  root  2.6K Aug 31 04:47 sa-update.log.2
> -rw-r--r-- 1 root  root  195K Aug 24 12:25 scrollkeeper.log
> -rw------- 1 root  root  2.0M Oct 17 18:58 secure
> -rw------- 1 root  root  1.6M Oct 14 04:54 secure.1
> -rw------- 1 root  root  153K Oct  7 05:19 secure.2
> -rw------- 1 root  root  3.0M Sep 30 04:47 secure.3
> -rw------- 1 root  root  1.5M Sep 23 04:49 secure.4
> -rw------- 1 root  root     0 Oct 14 04:54 spooler
> -rw------- 1 root  root     0 Oct  7 05:19 spooler.1
> -rw------- 1 root  root     0 Sep 30 04:47 spooler.2
> -rw------- 1 root  root     0 Sep 23 04:49 spooler.3
> -rw------- 1 root  root     0 Sep 16 04:48 spooler.4
> drwxr-x--- 2 squid squid 4.0K May 14 07:48 squid
> -rw------- 1 root  root     0 Aug 24 12:15 tallylog
> drwxr-xr-x 2 root  root  4.0K Jul 19  2006 vbox
> -rw-rw-r-- 1 root  utmp  326K Oct 17 18:58 wtmp
> -rw-rw-r-- 1 root  utmp  835K Sep 28 21:43 wtmp.1
> -rw-r--r-- 1 root  root   26K Oct 13 20:33 Xorg.0.log
> -rw-r--r-- 1 root  root   27K Oct 13 20:31 Xorg.0.log.old
> -rw-r--r-- 1 root  root   26K Sep 26 18:57 Xorg.1.log
> -rw-r--r-- 1 root  root   26K Sep 26 18:50 Xorg.1.log.old
> -rw-r--r-- 1 root  root  1.5K Oct  1 14:35 Xorg.setup.log
> -rw------- 1 root  root  5.3K Oct  1 21:19 yum.log
> -rw-r--r-- 1 root  root   32K Aug 25 00:05 yum.log.1
> 
> 
> ill remove some of the larger ones. i dont see where the my sql one is.
> Where should i be looking?

Mysqld.log is tiny.
You need to find out why your message logs are so large. They are on the 
usual weekly logrotate basis but they are HUGE. If this is a pure 
mythbox you probably do not need #'s 2,3 or 4. Same for Xorg.0.log. Chop 
your logrotate keepers to the new one and .1, and make the allowed size 
smaller.

Some of the logs are basically irrelevant to a running mythbox. AIUI, 
the anaconda logs are from the install: it worked, so drop them...etc. 
The message logs might be large because you run daemons for stuff you do 
not need. Turn off cups for example... and trash the spooler log 
files...etc. etc.

Geoff


More information about the mythtv-users mailing list