<HTML><HEAD></HEAD>
<BODY 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">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></BODY></HTML>