[Koha-devel] File sizes
Michael Hafen
michael.hafen at washk12.org
Fri Feb 28 21:37:04 CET 2014
For reference, here is the file sizes and some table sizes from my database:
ls -l *.ibd|sort -k 5 -n -r|head -n 28-rw-rw---- 1 mysql mysql 2654994432
Feb 28 13:30 action_logs.ibd
-rw-rw---- 1 mysql mysql 1551892480 Feb 28 12:53 import_records.ibd
-rw-rw---- 1 mysql mysql 1283457024 Feb 28 13:30 biblioitems.ibd
-rw-rw---- 1 mysql mysql 801112064 Feb 28 13:28 deleteditems.ibd
-rw-rw---- 1 mysql mysql 511705088 Feb 26 10:28 deletedbiblioitems.ibd
-rw-rw---- 1 mysql mysql 490733568 Feb 28 13:30 zebraqueue.ibd
-rw-rw---- 1 mysql mysql 440401920 Feb 6 14:55 patronimage.ibd
-rw-rw---- 1 mysql mysql 197132288 Feb 28 13:30 statistics.ibd
-rw-rw---- 1 mysql mysql 197132288 Feb 28 13:25 auth_header.ibd
-rw-rw---- 1 mysql mysql 163577856 Feb 28 13:29 old_issues.ibd
-rw-rw---- 1 mysql mysql 142606336 Feb 27 15:22 import_items.ibd
-rw-rw---- 1 mysql mysql 83886080 Oct 24 2012 sessions.ibd
-rw-rw---- 1 mysql mysql 75497472 Feb 28 13:30 items.ibd
-rw-rw---- 1 mysql mysql 58720256 Feb 28 12:53 import_biblios.ibd
-rw-rw---- 1 mysql mysql 50331648 Feb 28 13:25 biblio.ibd
-rw-rw---- 1 mysql mysql 30408704 Feb 26 10:28 deletedbiblio.ibd
-rw-rw---- 1 mysql mysql 27262976 Feb 28 13:30 accountlines.ibd
-rw-rw---- 1 mysql mysql 20971520 Feb 28 13:30 borrowers.ibd
-rw-rw---- 1 mysql mysql 15728640 Feb 28 13:30 issues.ibd
-rw-rw---- 1 mysql mysql 15728640 Feb 28 12:05 search_history.ibd
-rw-rw---- 1 mysql mysql 15728640 Feb 28 11:15 message_queue.ibd
-rw-rw---- 1 mysql mysql 12582912 Feb 27 15:21 import_record_matches.ibd
-rw-rw---- 1 mysql mysql 11534336 Feb 28 11:33 old_reserves.ibd
-rw-rw---- 1 mysql mysql 10485760 Feb 28 13:01 creator_batches.ibd
-rw-rw---- 1 mysql mysql 9437184 Oct 24 2012 auth_subfield_structure.ibd
-rw-rw---- 1 mysql mysql 9437184 Nov 7 14:27 deletedborrowers.ibd
-rw-rw---- 1 mysql mysql 9437184 Feb 28 12:58 accountoffsets.ibd
-rw-rw---- 1 mysql mysql 9437184 Feb 26 12:39
borrower_message_preferences.ibd
mysql> select count(*) from biblio;
+----------+
| count(*) |
+----------+
| 121725 |
+----------+
1 row in set (0.02 sec)
mysql> select count(*) from items;
+----------+
| count(*) |
+----------+
| 201075 |
+----------+
1 row in set (0.10 sec)
mysql> select count(*) from borrowers;
+----------+
| count(*) |
+----------+
| 33620 |
+----------+
Notice that this is with innodb_file_per_table on. I estimate close to 8
Gb of data there.
And add another 2.5 Gb on another server for the Zebradb directory.
Also note that this is Koha 3.2.x with a lot of local modifications by
myself.
On Fri, Feb 28, 2014 at 12:29 PM, Galen Charlton <gmc at esilibrary.com> wrote:
> Hi,
>
> On Fri, Feb 28, 2014 at 10:52 AM, Paul A <paul.a at navalmarinearchive.com>
> wrote:
> [snip]
> > -rw-rw---- 1 mysql mysql 1117782016 Feb 28 18:43 ibdata1
> > [log files identical]
> >
> > Two questions if I may. First, are my numbers typical?
>
> Hard to say without knowing how many bibs you have.
>
> Regardless, if you're not using the innodb_file_per_table option, you
> should be, as it allows one to recover space from individual tables
> without having to reload the entire database.
>
> > Second, has MariaDB been shelved permanently?
>
> Far from it. At present, I've seen no issues using MariaDB 5.5 as a
> drop-in replacement for MySQL, either on my personal development boxes
> or in production use.
>
> Regards,
>
> Galen
> --
> Galen Charlton
> Manager of Implementation
> Equinox Software, Inc. / The Open Source Experts
> email: gmc at esilibrary.com
> direct: +1 770-709-5581
> cell: +1 404-984-4366
> skype: gmcharlt
> web: http://www.esilibrary.com/
> Supporting Koha and Evergreen: http://koha-community.org &
> http://evergreen-ils.org
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at 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/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20140228/966d6fc9/attachment-0001.html>
More information about the Koha-devel
mailing list