Pluto_media over 5,5GB?

[brononius]

Hey,

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


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...

[Marie.O]

mysql pluto_media -e "delete From File Where Missing = 1;"

[brononius]

Hmmm, with phpmyadmin, i've done

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...

[Marie.O]

Check /home/coredump, i.e. du -h /home/coredump

[brononius]

Sorry to double/split/post it .
I've just started another topic for the general disk size).

I think that the pluto-media is another issuse, no? 

[SBCC]

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.

[brononius]

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?

[dextaslab]

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