Ok, so I basically used a command that I found here:
https://github.com/gboudreau/Greyhole/b ... es/sql.php (this wasn't added till version 0.9.30...see:
http://www.greyhole.net/releases/CHANGELOG)
Code: Select all
DELETE FROM tasks_completed WHERE event_date < NOW() - INTERVAL %d DAY;
Replace %d with a number... in my case 5. So keep the last 5 days worth of stuff.
You'll never guess what was making the db so big.... Mindjet. I had mindjet put most of its application data on there. So it was constantly doing cache writes to the greyhole pool even when the software was running. I checked the database, it has over 2000 database writes in under 2 minutes....
So... don't put something in a greyhole pool that will be written thousands of times a second...
Also, since this filled up my drive, I had to:
- copy the database files from /var/lib/mysql/greyhole to a different hard drive
- symlink from /var/lib/mysql/greyhole to that new location on the other hard drive
- reboot
- remove crap from greyhole database (see above)
- (optional) move greyhole db back.
I ended up leaving my greyhole db on the other drive so I don't have this issue again. Also that other drive is using snapraid so its backed up better. I need to get my amahi os backed up as well.