<div dir="ltr">I would suggest the <a href="http://cleanup_database.pl">cleanup_database.pl</a> script in the cronjobs directory, except I've just looked at it and it doesn't touch the import_items or import_biblios tables.<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Sep 11, 2015 at 8:22 AM, Mark Tompsett <span dir="ltr"><<a href="mailto:mtompset@hotmail.com" target="_blank">mtompset@hotmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">
<div dir="ltr">
<div style="FONT-SIZE:12pt;FONT-FAMILY:'Calibri';COLOR:#000000">
<div><font face="Courier New">Greetings,</font></div>
<div><font face="Courier New"></font> </div>
<div><font face="Courier New">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);</font></div>
<div><font face="Courier New">+-------------------------+------------+------------+</font></div>
<div><font face="Courier New">|
table_name
| table_rows | Size in MB |</font></div>
<div><font face="Courier New">+-------------------------+------------+------------+</font></div>
<div><font face="Courier New">| marc_subfield_structure
| 48064 | 11.73
|</font></div>
<div><font face="Courier New">|
statistics
| 26298 | 11.98
|</font></div>
<div><font face="Courier New">|
biblio
| 96620 | 14.03
|</font></div>
<div><font face="Courier New">|
deleteditems
| 27767 | 14.48
|</font></div>
<div><font face="Courier New">|
import_biblios
| 136336 | 36.33
|</font></div>
<div><font face="Courier New">| deletedbiblioitems
| 19509 | 61.45
|</font></div>
<div><font face="Courier New">|
items
| 122738 | 67.25
|</font></div>
<div><font face="Courier New">|
nozebra
| 264699 | 76.66
|</font></div>
<div><font face="Courier New">|
import_items
| 147630 | 130.19 |</font></div>
<div><font face="Courier New">|
biblioitems
| 103188 | 343.14 |</font></div>
<div><font face="Courier New">|
import_records
| 113028 | 659.55 |</font></div>
<div><font face="Courier New">|
biblioimages
| 1176 | 919.47
|</font></div>
<div><font face="Courier New">+-------------------------+------------+------------+</font></div>
<div><font face="Courier New">12 rows in set (0.33 sec)</font></div>
<div><font face="Courier New"></font> </div>
<div>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?</div>
<div> </div>
<div>This led me to this pretty schema page: <a title="http://schema.koha-community.org/tables/import_records.html" href="http://schema.koha-community.org/tables/import_records.html" target="_blank">http://schema.koha-community.org/tables/import_records.html</a></div>
<div> </div>
<div><strong>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?</strong></div>
<div> </div>
<div>Grace, Peace, Mercy, and Love,</div>
<div>Mark Tompsett</div></div></div></div>
<br>_______________________________________________<br>
Koha-devel mailing list<br>
<a href="mailto:Koha-devel@lists.koha-community.org">Koha-devel@lists.koha-community.org</a><br>
<a href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel" rel="noreferrer" target="_blank">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a><br>
website : <a href="http://www.koha-community.org/" rel="noreferrer" target="_blank">http://www.koha-community.org/</a><br>
git : <a href="http://git.koha-community.org/" rel="noreferrer" target="_blank">http://git.koha-community.org/</a><br>
bugs : <a href="http://bugs.koha-community.org/" rel="noreferrer" target="_blank">http://bugs.koha-community.org/</a><br></blockquote></div><br><br clear="all"><br>-- <br><div class="gmail_signature"><div dir="ltr"><div><div>Michael Hafen<br></div>Washington County School District Technology Department<br></div>Systems Analyst<br><div><br><img src="http://logos.washk12.org/100year.png"><br></div></div></div>
</div>