The script cleanup_database.pl will help you a bit with import_records. You should be using the 'clean' button in the import records tool to keep the size down as well. As for the deletedbiblioitems table, I'm not aware of a script for that. You can always trim it via sql from the mysql console. Kyle http://www.kylehall.info ByWater Solutions ( http://bywatersolutions.com ) Meadville Public Library ( http://www.meadvillelibrary.org ) Crawford County Federated Library System ( http://www.ccfls.org ) Mill Run Technology Solutions ( http://millruntech.com ) On Thu, Mar 19, 2015 at 6:36 PM, Steven Nickerson <snicker1@maine.rr.com> wrote:

Hi everyone,

I have a 3.16.02 package install of Koha running on Debian. When first installed almost 2 years ago now, I did several iterations of importing ~40,000+ MARC records and then "cleaning" the resulting staged records. I was noticing the other day that this MySQL DB's backups are significantly larger than a couple of other library's databases that I also support so I started poking around a bit. I'm finding that the following 2 tables in the MySQL DB are quite large:

import_records (.94GB)

deletedbiblioitems (.28GB)

And I'm wondering how to properly "shrink" the overall size of this database, most especially these two tables? If those two tables are large because of the multiple original imports/cleans, could I simply delete all of the data in those two tables?

Thanks as always!

Steve

_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha