User Tools

Site Tools


database_statistics

Database Statistics

New users considering switching to Bacula are often curious about how large other Bacula installations are: how many clients, how much data is being backed up, how large the catalog database gets, etc. While such questions usually get one or two people answering, I thought it would be nice to try and generate a quantitative set of data to give people a clearer picture.

This perl script will run a handful of queries against your catalog, and print the resulting statistics. Open the script file, and edit the first few lines to reflect your configuration, including the database username, password, and driver. It was written and tested against MySQL 4.1, but uses standard SQL so should work against other engines.

bacula-dbstats.gz

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).

Frank Sweetser 2006/01/29 16:56

Early Results

These are just a few preliminary results, thrown up by hand, to give a flavor of what the final results will look like. The finished product should also have some basic statistics, sorting, etc.

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
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
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
2.4.3 634 TB 869 1,787,983,209 Postgresql 8.3 Linux 2.6 Debian Lenny 8x2Ghz Xeon 12GB RAM
2.0.3 1.95 TB 67 627,800,732 MySQL 4.1.20 RHEL 4 ProLiant DL385 G1 AMD Opteron 6GB RAM
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
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
3.1.4 513 GB 16 16,722,868 MySQL 5.0.45 Linux 2.6 500Mhz Athlon 512M RAM
1.38.4 23 GB 8 2,951,916 PostgresQL 8.1.2 FreeBSD 6.0 dual 2.8G Xeon 1G RAM
2.0.2 579 GB 24 3,576,838 MySQL 5.0.27 FC 6 quad 3.3G Xeon 4G RAM
1.38.2 815 GB 1 9,978,624 MySQL 4.1.14 Linux 2.6 dual 800MHz PIII 1G RAM
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
1.38.4 428 GB 38 73,476,698 MySQL 4.1.12 RHEL 4 2.1GHz Athlon 512MB RAM
1.38.10 182 GB 11 12,097,443 MySQL 4.1.13 Suse 10.0 AMT Opteron 146 2G RAM
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
1.38.11 3 GB 12 45,356 (workstations catalog)
1.38.11 1.8 TB 68 19,725,279 MySQL 4.1.20 CentOS release 4.4 (Final) Pentium III 1 GHz, 1GB RAM
2.0.0 56 GB 5 121,269 MySQL 5.0.27 FreeBSD 6.2-PRERELEASE, Dual PIII 850MHz, 640MB
1.39.18 804 GB 46 6,121,070 Postgresql 8.1.6-1.fc5 Linux 64bit (AMD), 2GB Mem
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
2.0.2 12 GB 2 1,538,935 MySQL Athlon64 3700+ 1GB Mem
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
2.0.3 120 GB 4 4,079,992 MySQL 5.0.27 FC6 P4 2.4Ghz 1GB RAM
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
2.2.0 389 GB 85 14,514,660 MySQL 4.1.14 Slackware 9.1 Dual Pentium III 1Ghz 1GB Mem
2.0.3 183 GB 4 9,250,092 PostgreSQL 7.4.17 Debian Etch 64Bit @ Dual-Core Intel(R) Xeon(R) CPU 3060 2.40GHz 2 GB RAM
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
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
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
5.0.3 17 TB 140 116,778,421 MySQL 5.1.49 Debian 6.0 amd64 Dualcore-Dual-Opteron 2.4 GHz 16 GB RAM
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
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
database_statistics.txt · Last modified: 2011/09/05 14:02 by manuel