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