Greetings,
mysql> SELECT table_name, table_rows, round(((data_length + index_length) /
1024 / 1024),2) "Size in MB" FROM information_schema.TABLES where table_schema
= "koha_library" and ((data_length+index_length)/1024/1024)>10 order by
(data_length+index_length);
+-------------------------+------------+------------+
| table_name | table_rows | Size in MB |
+-------------------------+------------+------------+
| marc_subfield_structure | 48064 | 11.73 |
| statistics | 26298 | 11.98 |
| biblio | 96620 | 14.03 |
| deleteditems | 27767 | 14.48 |
| import_biblios | 136336 | 36.33 |
| deletedbiblioitems | 19509 | 61.45 |
| items | 122738 | 67.25 |
| nozebra | 264699 | 76.66 |
| import_items | 147630 | 130.19 |
| biblioitems | 103188 | 343.14 |
| import_records | 113028 | 659.55 |
| biblioimages | 1176 | 919.47 |
+-------------------------+------------+------------+
12 rows in set (0.33 sec)
So, I was looking to clean up the database a bit, so I figured I’d see what was
taking up the most space. The import_{something} series of tables looked like
promising clean up candidates. After all, who doesn’t want to free up 750MB or
more when running in a 40GB VM?
This led me to this pretty schema page:
http://schema.koha-community.org/tables/import_records.html
QUESTION: Would there be any problems if I deleted records associated with
import_batch_id’s prior to a given date in these related import_{something}
tables?
Grace, Peace, Mercy, and Love,
Mark Tompsett_______________________________________________
Koha-devel mailing list
Koha-devel@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
