[mythtv-users] [mythtv] MySQL database location

Mitch Gore mitchell.gore at gmail.com
Thu Oct 18 00:08:35 UTC 2007


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?

Thanks,
Mitchell
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20071018/ed07f20f/attachment.htm 


More information about the mythtv-users mailing list