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 10:02]
ebl
database_statistics [2011/09/05 14:02]
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 ^
-| 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>​ -->+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- | <! 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 --> | 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.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 -->+3.0.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>​ --> | 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>​ -->
-| 1.39.29 194 GB | 13,461,320 | MySQL 4.0.21 | Linux 2.4 200Mhz Pentium MMX 128M RAM | <!-- arno -->+3.1.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 -->
Line 41: Line 44:
 | 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.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.txt · Last modified: 2011/09/05 14:02 by manuel