[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