LinuxMCE Forums

General => Users => Topic started by: brononius on October 29, 2012, 12:38:59 pm

Title: Pluto_media over 5,5GB?
Post by: brononius on October 29, 2012, 12:38:59 pm
Hey,

I see that my pluto_media database is over 5,5GB big.
3.711.641 records is a bit much, no?  :-X


Any idea how i can/should solve this? Can i simply 'empty' the data?
I'm very low on diskspace for the moment, so every gig is welcome...
Title: Re: Pluto_media over 5,5GB?
Post by: posde on October 29, 2012, 02:16:44 pm
mysql pluto_media -e "delete From File Where Missing = 1;"
Title: Re: Pluto_media over 5,5GB?
Post by: brononius on October 29, 2012, 03:07:46 pm
Hmmm, with phpmyadmin, i've done
Quote
DELETE FROM File WHERE Missing = 1;

And some records where removed, but still a lot in the table: 3.663.306



ps My OS disk keeps getting Gigs from somewhere, but i think it's another topic. The db is only 4,5Gig. And since my cleanout this morning (6GB), it's again full...
Title: Re: Pluto_media over 5,5GB?
Post by: posde on October 29, 2012, 03:15:00 pm
Check /home/coredump, i.e. du -h /home/coredump
Title: Re: Pluto_media over 5,5GB?
Post by: brononius on October 29, 2012, 03:25:04 pm
Sorry to double/split/post it .
I've just started another topic for the general disk size (http://forum.linuxmce.org/index.php/topic,12956.0.html)).

I think that the pluto-media is another issuse, no?  :-[
Title: Re: Pluto_media over 5,5GB?
Post by: SBCC on October 31, 2012, 02:08:07 am
I noticed this myself. I had over 60,000 records in Pluto_media.File. I just checked again and it's down to ~ 2,000. I had thought to reformat my MD hard drives. Not sure why I have them in the first place. Just habit I guess.
I shoved old drives in them. Maybe it was picking up the gazillion media files floating on them?

Also chose all public as setup. Not sure if any of this did anything just thought I'd share.
Title: Re: Pluto_media over 5,5GB?
Post by: brononius on December 12, 2012, 08:05:28 am
When i check this today, i've got following after the 'DELETE FROM File WHERE Missing = 1;'

Database pluto_media:
      table FILE
            Records: ~3,608,448
            Size: 4,1 GB
      table FILE_ATTRIBUTE
            Records: ~2,470,705
            Size: 310,7 MB


I've got some media, but 4gigs of 'inventory' in a database is a bit much, no?
And 3 million records? I don't think i got this amount of files...  :-[

Is there a way i can clean out the whole database/table and start over?
I suppose a purge of the table FILE isn't a good idea?
Title: Re: Pluto_media over 5,5GB?
Post by: dextaslab on December 12, 2012, 11:02:19 am
No sure about everyone else but I use the drive for backups and other files, and to stop it checking those folders I use %.folderlock files so it skips checking them; eg: "Backups.folderlock"

http://wiki.linuxmce.org/index.php/Folder_lock

Cheers