|
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?  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... |
|
|
|
|
Logged
|
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
|
|
« Reply #1 on: October 29, 2012, 02:16:44 pm » |
|
mysql pluto_media -e "delete From File Where Missing = 1;"
|
|
|
|
|
Logged
|
|
|
|
|
brononius
|
|
« Reply #2 on: October 29, 2012, 03:07:46 pm » |
|
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... |
|
|
|
|
Logged
|
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
|
|
« Reply #3 on: October 29, 2012, 03:15:00 pm » |
|
Check /home/coredump, i.e. du -h /home/coredump
|
|
|
|
|
Logged
|
|
|
|
|
brononius
|
|
« 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?  |
|
|
|
|
Logged
|
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
|
|
« 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.
|
|
|
|
|
Logged
|
|
|
|
|
brononius
|
|
« 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? |
|
|
|
|
Logged
|
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
|
|
« 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_lockCheers |
|
|
|
|
Logged
|
|
|
|
|
