Author Topic: Pluto_media over 5,5GB?  (Read 1249 times)

brononius

  • Guru
  • ****
  • Posts: 379
  • Trying to keep it simple and centralized...
    • View Profile
    • OnIrIa - linuxMCE blog (runs on ... linuxmce server)
Pluto_media over 5,5GB?
« 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...
Version: linuxMCE 1004 (v 2012-07-01)
Extra's: Cacti, webmin, phpmyadmin, joomla

Server: MSI MS-7519 / E7400 2,8GB / 4GB / SSD 60GB / Radeon HD4350 / RTL8111 - 3C905C-TX
Orbiters: HTC Desire Z, HP PocketPC, Samsung Galaxy S, iPAD, ASUS eeePAD
Automation: EIB technology, KNX IP ROUTER 750
Phones: Cisco 7940, Cisco 7960
Camera's: IPCAM02

posde

  • Administrator
  • LinuxMCE God
  • *****
  • Posts: 3046
  • Wastes Life On LinuxMCE Since 2007
    • View Profile
    • My Home
Re: Pluto_media over 5,5GB?
« Reply #1 on: October 29, 2012, 02:16:44 pm »
mysql pluto_media -e "delete From File Where Missing = 1;"

brononius

  • Guru
  • ****
  • Posts: 379
  • Trying to keep it simple and centralized...
    • View Profile
    • OnIrIa - linuxMCE blog (runs on ... linuxmce server)
Re: Pluto_media over 5,5GB?
« Reply #2 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...
Version: linuxMCE 1004 (v 2012-07-01)
Extra's: Cacti, webmin, phpmyadmin, joomla

Server: MSI MS-7519 / E7400 2,8GB / 4GB / SSD 60GB / Radeon HD4350 / RTL8111 - 3C905C-TX
Orbiters: HTC Desire Z, HP PocketPC, Samsung Galaxy S, iPAD, ASUS eeePAD
Automation: EIB technology, KNX IP ROUTER 750
Phones: Cisco 7940, Cisco 7960
Camera's: IPCAM02

posde

  • Administrator
  • LinuxMCE God
  • *****
  • Posts: 3046
  • Wastes Life On LinuxMCE Since 2007
    • View Profile
    • My Home
Re: Pluto_media over 5,5GB?
« Reply #3 on: October 29, 2012, 03:15:00 pm »
Check /home/coredump, i.e. du -h /home/coredump

brononius

  • Guru
  • ****
  • Posts: 379
  • Trying to keep it simple and centralized...
    • View Profile
    • OnIrIa - linuxMCE blog (runs on ... linuxmce server)
Re: Pluto_media over 5,5GB?
« Reply #4 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).

I think that the pluto-media is another issuse, no?  :-[
Version: linuxMCE 1004 (v 2012-07-01)
Extra's: Cacti, webmin, phpmyadmin, joomla

Server: MSI MS-7519 / E7400 2,8GB / 4GB / SSD 60GB / Radeon HD4350 / RTL8111 - 3C905C-TX
Orbiters: HTC Desire Z, HP PocketPC, Samsung Galaxy S, iPAD, ASUS eeePAD
Automation: EIB technology, KNX IP ROUTER 750
Phones: Cisco 7940, Cisco 7960
Camera's: IPCAM02

SBCC

  • Veteran
  • ***
  • Posts: 131
    • View Profile
Re: Pluto_media over 5,5GB?
« Reply #5 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.

brononius

  • Guru
  • ****
  • Posts: 379
  • Trying to keep it simple and centralized...
    • View Profile
    • OnIrIa - linuxMCE blog (runs on ... linuxmce server)
Re: Pluto_media over 5,5GB?
« Reply #6 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?
Version: linuxMCE 1004 (v 2012-07-01)
Extra's: Cacti, webmin, phpmyadmin, joomla

Server: MSI MS-7519 / E7400 2,8GB / 4GB / SSD 60GB / Radeon HD4350 / RTL8111 - 3C905C-TX
Orbiters: HTC Desire Z, HP PocketPC, Samsung Galaxy S, iPAD, ASUS eeePAD
Automation: EIB technology, KNX IP ROUTER 750
Phones: Cisco 7940, Cisco 7960
Camera's: IPCAM02

dextaslab

  • Veteran
  • ***
  • Posts: 75
    • View Profile
    • modlog.net
Re: Pluto_media over 5,5GB?
« Reply #7 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