[mythtv-users] Database purge

Ben Dash ben_dash at yahoo.com
Thu Sep 7 03:18:25 UTC 2006


--- Nick wrote:
> Have you run optimize_mythdb.pl on the database?

I hadn't heard of that but I'll look into it now that
you mention it.

> Checking my current DB - almost 2 years old - the
> largest table is
> recordedseek (24MB)

credits is 2.7MB Data Length and 5.7MB Index Length
people is 9.7MB Data and 1.8MB Indexes
program is 9.4MB Data and 6.4MB Indexes
programgenres is 3.4MB Data and 1.6MB Indexes
recordedmarkup is 25MB Data and 21.5MB Indexes

Interestingly, I don't have a recordedseek table, I'm
on 0.19.

So what's using up all the space...

Oh, I see I have bin-log enabled duh:

# ls -lah /var/lib/mysql/
total 3.6G
drwxr-x---  5 mysql mysql 4.0K Sep  6 06:58 .
drwxr-xr-x 15 root  root  4.0K May 13 17:59 ..
-rw-rw----  1 mysql mysql 9.9K May 13 17:59
beta-bin.000001
-rw-rw----  1 mysql mysql 363K May 13 17:59
beta-bin.000002
-rw-rw----  1 mysql mysql 6.0M May 13 18:00
beta-bin.000003
-rw-rw----  1 mysql mysql 1.1G May 14 16:01
beta-bin.000004
-rw-rw----  1 mysql mysql 409M May 14 22:22
beta-bin.000005
-rw-rw----  1 mysql mysql   79 May 14 22:09
beta-bin.000006
-rw-rw----  1 mysql mysql 363K May 14 22:09
beta-bin.000007
-rw-rw----  1 mysql mysql  14M May 14 22:34
beta-bin.000008
-rw-rw----  1 mysql mysql 9.8M May 15 22:16
beta-bin.000009
-rw-rw----  1 mysql mysql 212K May 15 22:22
beta-bin.000010
-rw-rw----  1 mysql mysql  11M May 16 06:02
beta-bin.000011
-rw-rw----  1 mysql mysql 1.1G Jul 23 06:00
beta-bin.000012
-rw-rw----  1 mysql mysql 1.1G Sep  1 19:44
beta-bin.000013
-rw-rw----  1 mysql mysql  39M Sep  5 20:26
beta-bin.000014
-rw-rw----  1 mysql mysql 401K Sep  5 20:31
beta-bin.000015
-rw-rw----  1 mysql mysql 3.0K Sep  5 20:32
beta-bin.000016
-rw-rw----  1 mysql mysql 164K Sep  6 06:37
beta-bin.000017
-rw-rw----  1 mysql mysql    0 Sep  6 06:43
beta-bin.000018
-rw-rw----  1 mysql mysql    0 Sep  6 06:48
beta-bin.000019
-rw-rw----  1 mysql mysql    0 Sep  6 06:51
beta-bin.000020
-rw-rw----  1 mysql mysql    0 Sep  6 06:53
beta-bin.000021
-rw-rw----  1 mysql mysql    0 Sep  6 06:55
beta-bin.000022
-rw-rw----  1 mysql mysql 1.1M Sep  6 21:51
beta-bin.000023
-rw-rw----  1 mysql mysql  324 Sep  6 21:24
beta-bin.index
-rw-rw----  1 mysql mysql 5.0M Sep  6 21:24
ib_logfile0
-rw-rw----  1 mysql mysql 5.0M May 13 18:00
ib_logfile1
-rw-rw----  1 mysql mysql  10M Sep  6 21:24 ibdata1
drwx------  2 mysql mysql 4.0K May 14 21:46 mysql
drwx------  2 mysql mysql 8.0K Sep  1 20:12
mythconverg
drwx------  2 mysql mysql 4.0K May 13 17:59 test

A quick "PURGE BINARY LOGS TO..." and I regained 4GB :-)

-----------------------------------------------------
|    o                                              |
| _ /<_                                             |
|(_)>(_)                                            |
|Ben Dash                                           |
|Ask free questions - http://bensqanda.blogspot.com |
|My Blog -    http://bensdailythoughts.blogspot.com |
|Info -  http://bensinformationstation.blogspot.com |
|Workouts -        http://bensworkouts.blogspot.com |
-----------------------------------------------------

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


More information about the mythtv-users mailing list