<div dir="ltr"><div><div>For reference, here is the file sizes and some table sizes from my database:<br><br>ls -l *.ibd|sort -k 5 -n -r|head -n 28-rw-rw---- 1 mysql mysql 2654994432 Feb 28 13:30 action_logs.ibd<br>-rw-rw---- 1 mysql mysql 1551892480 Feb 28 12:53 import_records.ibd<br>
-rw-rw---- 1 mysql mysql 1283457024 Feb 28 13:30 biblioitems.ibd<br>-rw-rw---- 1 mysql mysql 801112064 Feb 28 13:28 deleteditems.ibd<br>-rw-rw---- 1 mysql mysql 511705088 Feb 26 10:28 deletedbiblioitems.ibd<br>-rw-rw---- 1 mysql mysql 490733568 Feb 28 13:30 zebraqueue.ibd<br>
-rw-rw---- 1 mysql mysql 440401920 Feb 6 14:55 patronimage.ibd<br>-rw-rw---- 1 mysql mysql 197132288 Feb 28 13:30 statistics.ibd<br>-rw-rw---- 1 mysql mysql 197132288 Feb 28 13:25 auth_header.ibd<br>-rw-rw---- 1 mysql mysql 163577856 Feb 28 13:29 old_issues.ibd<br>
-rw-rw---- 1 mysql mysql 142606336 Feb 27 15:22 import_items.ibd<br>-rw-rw---- 1 mysql mysql 83886080 Oct 24 2012 sessions.ibd<br>-rw-rw---- 1 mysql mysql 75497472 Feb 28 13:30 items.ibd<br>-rw-rw---- 1 mysql mysql 58720256 Feb 28 12:53 import_biblios.ibd<br>
-rw-rw---- 1 mysql mysql 50331648 Feb 28 13:25 biblio.ibd<br>-rw-rw---- 1 mysql mysql 30408704 Feb 26 10:28 deletedbiblio.ibd<br>-rw-rw---- 1 mysql mysql 27262976 Feb 28 13:30 accountlines.ibd<br>-rw-rw---- 1 mysql mysql 20971520 Feb 28 13:30 borrowers.ibd<br>
-rw-rw---- 1 mysql mysql 15728640 Feb 28 13:30 issues.ibd<br>-rw-rw---- 1 mysql mysql 15728640 Feb 28 12:05 search_history.ibd<br>-rw-rw---- 1 mysql mysql 15728640 Feb 28 11:15 message_queue.ibd<br>-rw-rw---- 1 mysql mysql 12582912 Feb 27 15:21 import_record_matches.ibd<br>
-rw-rw---- 1 mysql mysql 11534336 Feb 28 11:33 old_reserves.ibd<br>-rw-rw---- 1 mysql mysql 10485760 Feb 28 13:01 creator_batches.ibd<br>-rw-rw---- 1 mysql mysql 9437184 Oct 24 2012 auth_subfield_structure.ibd<br>
-rw-rw---- 1 mysql mysql 9437184 Nov 7 14:27 deletedborrowers.ibd<br>-rw-rw---- 1 mysql mysql 9437184 Feb 28 12:58 accountoffsets.ibd<br>-rw-rw---- 1 mysql mysql 9437184 Feb 26 12:39 borrower_message_preferences.ibd<br>
<br>mysql> select count(*) from biblio;<br>+----------+<br>| count(*) |<br>+----------+<br>| 121725 |<br>+----------+<br>1 row in set (0.02 sec)<br><br>mysql> select count(*) from items;<br>+----------+<br>| count(*) |<br>
+----------+<br>| 201075 |<br>+----------+<br>1 row in set (0.10 sec)<br><br>mysql> select count(*) from borrowers;<br>+----------+<br>| count(*) |<br>+----------+<br>| 33620 |<br>+----------+<br><br></div>Notice that this is with innodb_file_per_table on. I estimate close to 8 Gb of data there.<br>
<br></div><div>And add another 2.5 Gb on another server for the Zebradb directory.<br></div><div><br></div>Also note that this is Koha 3.2.x with a lot of local modifications by myself.<br></div><div class="gmail_extra"><br>
<br><div class="gmail_quote">On Fri, Feb 28, 2014 at 12:29 PM, Galen Charlton <span dir="ltr"><<a href="mailto:gmc@esilibrary.com" target="_blank">gmc@esilibrary.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi,<br>
<br>
On Fri, Feb 28, 2014 at 10:52 AM, Paul A <<a href="mailto:paul.a@navalmarinearchive.com">paul.a@navalmarinearchive.com</a>> wrote:<br>
[snip]<br>
<div class="">> -rw-rw---- 1 mysql mysql 1117782016 Feb 28 18:43 ibdata1<br>
> [log files identical]<br>
><br>
> Two questions if I may. First, are my numbers typical?<br>
<br>
</div>Hard to say without knowing how many bibs you have.<br>
<br>
Regardless, if you're not using the innodb_file_per_table option, you<br>
should be, as it allows one to recover space from individual tables<br>
without having to reload the entire database.<br>
<div class=""><br>
> Second, has MariaDB been shelved permanently?<br>
<br>
</div>Far from it. At present, I've seen no issues using MariaDB 5.5 as a<br>
drop-in replacement for MySQL, either on my personal development boxes<br>
or in production use.<br>
<br>
Regards,<br>
<br>
Galen<br>
<span class="HOEnZb"><font color="#888888">--<br>
Galen Charlton<br>
Manager of Implementation<br>
Equinox Software, Inc. / The Open Source Experts<br>
email: <a href="mailto:gmc@esilibrary.com">gmc@esilibrary.com</a><br>
direct: <a href="tel:%2B1%20770-709-5581" value="+17707095581">+1 770-709-5581</a><br>
cell: <a href="tel:%2B1%20404-984-4366" value="+14049844366">+1 404-984-4366</a><br>
skype: gmcharlt<br>
web: <a href="http://www.esilibrary.com/" target="_blank">http://www.esilibrary.com/</a><br>
Supporting Koha and Evergreen: <a href="http://koha-community.org" target="_blank">http://koha-community.org</a> &<br>
<a href="http://evergreen-ils.org" target="_blank">http://evergreen-ils.org</a><br>
</font></span><div class="HOEnZb"><div class="h5">_______________________________________________<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" target="_blank">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a><br>
website : <a href="http://www.koha-community.org/" target="_blank">http://www.koha-community.org/</a><br>
git : <a href="http://git.koha-community.org/" target="_blank">http://git.koha-community.org/</a><br>
bugs : <a href="http://bugs.koha-community.org/" target="_blank">http://bugs.koha-community.org/</a><br>
</div></div></blockquote></div><br></div>