User Tools

Site Tools


database_statistics

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
database_statistics [2009/04/15 09:58]
ebl
database_statistics [2011/09/05 14:02] (current)
manuel [Early Results]
Line 7: Line 7:
 {{bacula-dbstats.gz}} {{bacula-dbstats.gz}}
  
-At the moment, there is no formal infrastructure for aggregating the results, ​so you can just email them to me directly at the email address at the bottom of the page (note the anti-spam obfuscation). Please include the output of the script, along with the version of bacula and basic statistics of the servers you are running your storage daemon and catalog on (operating system, CPU, memory), and what kind of and version database you are running (MySQL, Postgresql, SQLite).+If you would like your results ​to be included, you can either add yourself to the list below or just email them to me directly at the email address at the bottom of the page (note the anti-spam obfuscation). Please include the output of the script, along with the version of bacula and basic statistics of the servers you are running your storage daemon and catalog on (operating system, CPU, memory), and what kind of and version database you are running (MySQL, Postgresql, SQLite).
  
  --- //​[[fs@wpi.edu|Frank Sweetser]] 2006/01/29 16:56//  --- //​[[fs@wpi.edu|Frank Sweetser]] 2006/01/29 16:56//
Line 15: Line 15:
  
 ^ Bacula Version ^ Data Backed Up ^ Clients Backed Up ^ File Table Size (rows) ^ Database ^ Server ^ ^ Bacula Version ^ Data Backed Up ^ Clients Backed Up ^ File Table Size (rows) ^ Database ^ Server ^
 +| 5.0.1 | 600 GB | 14 | 120,421,825 | MySQL 5.0.26 | SLES 10 SP2 (x86_64) 2.6.16.60-0.21-smp,​ SunFire X2100, Dual-Core Opteron, 2GB RAM, LTO-4  | <! Juergen Paller <​juergen@paller.net>​
 +| 3.0.2 | 579 GB | 29 | 5157539 | MySQL 5.0.26 | SLES 10 (i586) 2.6.16.46-0.12-bigsmp,​ 4x Intel(R) Xeon(R) CPU 5120 @ 1.86GHz, 4 GB RAM | <! Vitaliy Kosharskiy <​kisa_co@ukrpost.net>​
 +| 3.0.2 | 536 GB | 11 | 3529875 | 5.0.51a-24+lenny2 (Debian): Mysql | Debian Lenny, Kernel 2.6.18-6-xen-amd64,​ 1x Intel(R) Xeon(R) CPU 5110 @ 1.60GHz, 1 GB RAM | <!-- fgarpe@gmail.com -->
 +| 2.4.3 | 634 TB | 869 | 1,​787,​983,​209 | Postgresql 8.3 | Linux 2.6 Debian Lenny 8x2Ghz Xeon 12GB RAM | <!-- Eric Bollengier <​eric@eb.homelinux.org>​ -->
 +| 2.0.3 | 1.95 TB | 67 | 627,800,732 | MySQL 4.1.20 | RHEL 4 ProLiant DL385 G1 AMD Opteron 6GB RAM |  <!-- jkates@cmpnet.com -->
 +| 3.0.2 | 94.1 TB | 222 | 114,205,399 | PostgreSQL 8.1.11 | Debian Etch 2x Intel(R) Xeon(TM) Dual Core HT 3Ghz (8 logical Cores), 4GB RAM | <!-- tcbadministration@deutschepost.de -->
 +| 2.0.3 | 993 GB | 124 | 39,405,723 | MySQL 5.0.27 | SLES 9 HP DL380, Intel(R) Xeon(TM) CPU 3.20GHz with 3GB RAM | <!-- SITKEI Attila ​ attila.sitkei@lhsystems.com>​ -->
 +| 3.1.4 | 513 GB | 16 | 16,722,868 | MySQL 5.0.45 | Linux 2.6 500Mhz Athlon 512M RAM | <!-- arno -->
 | 1.38.4 | 23 GB | 8 | 2,951,916 | PostgresQL 8.1.2 | FreeBSD 6.0 dual 2.8G Xeon 1G RAM | <!-- landon fuller --> | 1.38.4 | 23 GB | 8 | 2,951,916 | PostgresQL 8.1.2 | FreeBSD 6.0 dual 2.8G Xeon 1G RAM | <!-- landon fuller -->
 | 2.0.2 | 579 GB | 24 | 3,576,838 | MySQL 5.0.27 | FC 6 quad 3.3G Xeon 4G RAM | <!-- fs --> | 2.0.2 | 579 GB | 24 | 3,576,838 | MySQL 5.0.27 | FC 6 quad 3.3G Xeon 4G RAM | <!-- fs -->
-| 1.39.29 | 194 GB | 8 | 13,461,320 | MySQL 4.0.21 | Linux 2.4 200Mhz Pentium MMX 128M RAM | <!-- arno --> 
 | 1.38.2 | 815 GB | 1 | 9,978,624 | MySQL 4.1.14 | Linux 2.6 dual 800MHz PIII 1G RAM | <!-- fido@work --> | 1.38.2 | 815 GB | 1 | 9,978,624 | MySQL 4.1.14 | Linux 2.6 dual 800MHz PIII 1G RAM | <!-- fido@work -->
 | 1.38.5 | 39.65 TB | 32 | 42,096,529 | MySQL 4.0.21 | Solaris 10 Sun Fire-V240 dual UltraSPARC-IIIi 1.3GHz 6G RAM | <!-- Sebastian Stark --> | 1.38.5 | 39.65 TB | 32 | 42,096,529 | MySQL 4.0.21 | Solaris 10 Sun Fire-V240 dual UltraSPARC-IIIi 1.3GHz 6G RAM | <!-- Sebastian Stark -->
 | 1.38.4 | 428 GB | 38 | 73,476,698 | MySQL 4.1.12 | RHEL 4 2.1GHz Athlon 512MB RAM | <!-- Daniel Holtkamp <​holtkamp@riege.com>​ --> | 1.38.4 | 428 GB | 38 | 73,476,698 | MySQL 4.1.12 | RHEL 4 2.1GHz Athlon 512MB RAM | <!-- Daniel Holtkamp <​holtkamp@riege.com>​ -->
 | 1.38.10 | 182 GB | 11 | 12,097,443 | MySQL 4.1.13 | Suse 10.0 AMT Opteron 146 2G RAM | <!-- Carlos Cristóbal Sabroe Yde <​cris@cdc.unrc.edu.ar --> | 1.38.10 | 182 GB | 11 | 12,097,443 | MySQL 4.1.13 | Suse 10.0 AMT Opteron 146 2G RAM | <!-- Carlos Cristóbal Sabroe Yde <​cris@cdc.unrc.edu.ar -->
-| 2.4.3 | 222 TB | 447 | 885,404,290 | Postgresql 8.3 | Linux 2.6 Debian Lenny 8x2Ghz Xeon 12GB RAM | <!-- Eric Bollengier <​eric@eb.homelinux.org>​ --> 
 | 1.38.11 | 472 GB | 19 | 17,998,707 | MySQL 4.1.21 (servers catalog) | Linux 2.6 Gentoo, IBM Xseries 345 Xeon 2.66GHz 1Go RAM | <!-- Ludovic Strappazon <​strappaz@umb.u-strasbg.fr>​ --> | 1.38.11 | 472 GB | 19 | 17,998,707 | MySQL 4.1.21 (servers catalog) | Linux 2.6 Gentoo, IBM Xseries 345 Xeon 2.66GHz 1Go RAM | <!-- Ludovic Strappazon <​strappaz@umb.u-strasbg.fr>​ -->
 | 1.38.11 | 3 GB | 12 | 45,356 | (workstations catalog) | | <!-- Ludovic Strappazon <​strappaz@umb.u-strasbg.fr>​ --> | 1.38.11 | 3 GB | 12 | 45,356 | (workstations catalog) | | <!-- Ludovic Strappazon <​strappaz@umb.u-strasbg.fr>​ -->
Line 28: Line 34:
 | 2.0.0 | 56 GB | 5 | 121,269 | MySQL 5.0.27 | FreeBSD 6.2-PRERELEASE,​ Dual PIII 850MHz, 640MB | <!-- Oliver Lehmann <​oliver@FreeBSD.org>​ --> | 2.0.0 | 56 GB | 5 | 121,269 | MySQL 5.0.27 | FreeBSD 6.2-PRERELEASE,​ Dual PIII 850MHz, 640MB | <!-- Oliver Lehmann <​oliver@FreeBSD.org>​ -->
 | 1.39.18 | 804 GB | 46 | 6,121,070 | Postgresql 8.1.6-1.fc5 | Linux 64bit (AMD), 2GB Mem | <!-- Philip W. Dalrymple III <​pwd@mdtsoft.com>​ --> | 1.39.18 | 804 GB | 46 | 6,121,070 | Postgresql 8.1.6-1.fc5 | Linux 64bit (AMD), 2GB Mem | <!-- Philip W. Dalrymple III <​pwd@mdtsoft.com>​ -->
-| 2.0.3 | 993 GB | 124 | 39,405,723 | MySQL 5.0.27 | SLES 9 HP DL380, Intel(R) Xeon(TM) CPU 3.20GHz with 3GB RAM | <!-- SITKEI Attila <​attila.sitkei@lhsystems.com>​ --> 
 | 2.0.3 | 1.6 TB | 34 | 278,904,852 | Mysql 5.0.37 | 2 x Dual Core CPU Xeon 2Ghz 4Gb RAM, Fedora Core 6 | <!-- QMUL (jamesr) --> | 2.0.3 | 1.6 TB | 34 | 278,904,852 | Mysql 5.0.37 | 2 x Dual Core CPU Xeon 2Ghz 4Gb RAM, Fedora Core 6 | <!-- QMUL (jamesr) -->
 | 2.0.2 | 12 GB | 2 | 1,538,935 | MySQL | Athlon64 3700+ 1GB Mem| <!-- "​Florian Heigl" <​florian.heigl@gmail.com>​ --> | 2.0.2 | 12 GB | 2 | 1,538,935 | MySQL | Athlon64 3700+ 1GB Mem| <!-- "​Florian Heigl" <​florian.heigl@gmail.com>​ -->
 | 2.0.3 | 420 GB | 17 | 12,680,084 | PostgreSQL 8.2.4 | SUSE SLES 9 Quad Dual-Core Opterons 2.6 GHz 32 GB RAM | <!-- tcb <​tcbinder@web.de>​ --> | 2.0.3 | 420 GB | 17 | 12,680,084 | PostgreSQL 8.2.4 | SUSE SLES 9 Quad Dual-Core Opterons 2.6 GHz 32 GB RAM | <!-- tcb <​tcbinder@web.de>​ -->
-| 2.0.3 | 1.95 TB | 67 | 627,800,732 | MySQL 4.1.20 | RHEL 4 ProLiant DL385 G1 AMD Opteron 6GB RAM |  <!-- jkates@cmpnet.com --> 
 | 2.0.3 | 120 GB | 4 | 4,079,992 | MySQL 5.0.27 | FC6 P4 2.4Ghz 1GB RAM | <!-- tim@mogilev.beltelecom.by --> | 2.0.3 | 120 GB | 4 | 4,079,992 | MySQL 5.0.27 | FC6 P4 2.4Ghz 1GB RAM | <!-- tim@mogilev.beltelecom.by -->
 | 2.2.5 | 52.7 TB | 92 | 148,839,684 | PostgreSQL ​ 8.1.9 | Debian 4.0 64Bit Dual-Core AMD Opteron 2 GB RAM| <!-- ld130@users.sourceforge.net --> | 2.2.5 | 52.7 TB | 92 | 148,839,684 | PostgreSQL ​ 8.1.9 | Debian 4.0 64Bit Dual-Core AMD Opteron 2 GB RAM| <!-- ld130@users.sourceforge.net -->
Line 39: Line 43:
 | 2.2.7 | 45 GB | 12 | 2,572,839 | MySQL v4.1.22 | Sun Microsystems ​ sun4u Sun Enterprise 450 (3 X UltraSPARC-II 296MHz) 896MB | <!-- novosirj@umdnj.edu --> | 2.2.7 | 45 GB | 12 | 2,572,839 | MySQL v4.1.22 | Sun Microsystems ​ sun4u Sun Enterprise 450 (3 X UltraSPARC-II 296MHz) 896MB | <!-- novosirj@umdnj.edu -->
 | 2.2.7 | 2.1 TB | 7 | 15,959,428 | MySQL 5.0.45 | OpenSUSE 10.3 on AMD X2 5600 with 4.0Gb RAM | <!-- bruno@ioda-net.ch --> | 2.2.7 | 2.1 TB | 7 | 15,959,428 | MySQL 5.0.45 | OpenSUSE 10.3 on AMD X2 5600 with 4.0Gb RAM | <!-- bruno@ioda-net.ch -->
-| 2.4.4 | 70 TB | 123 | 19,749,066 | PostgreSQL 8.1.11 | Debian Etch 2x Intel(R) Xeon(TM) Dual Core HT 3Ghz (8 logical Cores), 4GB RAM | <!-- tcbadministration@deutschepost.de --> 
 | 2.2.8 | 1.6 TB | 67 | 73,027,753 | MySQL 5.0.51a | Debian 4.1 on 4 x Intel(R) Xeon(R) CPU 3.00GHz 20G Ram | <!-- tmortensen@gmail.com --> | 2.2.8 | 1.6 TB | 67 | 73,027,753 | MySQL 5.0.51a | Debian 4.1 on 4 x Intel(R) Xeon(R) CPU 3.00GHz 20G Ram | <!-- tmortensen@gmail.com -->
-2.2.20 TB | 120 67,715,625 | MySQL 5.0.32 | Debian ​4.0 Etch i386 64-bit-Kernel ​Dualcore-Dual-Opteron 2.4 GHz GB RAM| <!-- Manuel Wolff -->+5.0.17 TB | 140 116,778,421 | MySQL 5.1.49 | Debian ​6.0 amd64 Dualcore-Dual-Opteron 2.4 GHz 16 GB RAM| <!-- Manuel.Wolff at fun.de ​-->
 | 2.5.40 | 6.1 TB | 30 | 72,753,936 | MySQL 5.0.47 | CentOS 5.2 i386 2x Dual-Core Intel(R) Xeon(TM) 5160 3Ghz, 8GB RAM | <!-- Ulrich Leodolter at obvsg.at --> | 2.5.40 | 6.1 TB | 30 | 72,753,936 | MySQL 5.0.47 | CentOS 5.2 i386 2x Dual-Core Intel(R) Xeon(TM) 5160 3Ghz, 8GB RAM | <!-- Ulrich Leodolter at obvsg.at -->
 +| 2.4.4  | 979.542 GB | 16 | 46,210,098 | Postgres 8.3.9 | Debian 5.0 2.6.26-2-686 bigmem Quad-Core Intel(R) Xeon(TM) L5410 @ 2.33Ghz, 4GB RAM | <!-- Andrew dot Nicols @ luns.net dot uk -->
 +
database_statistics.1239785896.txt.gz · Last modified: 2009/04/15 09:58 by ebl