[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