Bugzilla sizes

[Olav Vitters]

On Sat, Mar 01, 2008 at 08:54:13AM +0000, Gervase Markham wrote:
> I recently did a talk "The Evolution of Bugzilla" at the Oxford 
> University Computing Society. It talked about how the software changes 
> and developing under pressure, not how it came into being ;-P
> http://www.gerv.net/presentations/oxcompsoc2008/
> 
> As part of that, I generated some interesting information which I will 
> share with you. There are some stats, and a mockup of what a Bugzilla 
> bug looked like back in 1998.
> 
> Stats
> =====
> 
> Mozilla: 420,000 bugs, 39 products, 627 components
> Gnome:   398,000 bugs, 447 products, 1469 components

s/Gnome/GNOME/ :-)

384 products AFAMK (M being MySQL;)
1869 components
currently 400,000 bugs (and 4.. but bug_id doesn't match anyway).

> b.m.o. has 301,000 user accounts, of which 3,400 were active in 2008, 
> and 15,000 in 2007, and 305,000 attachments. The database size is 9.3GB, 
> of which 6.6GB is attachments. The slide set has details of current 
> hardware.

232,211 users; 102,644 attachments. Active stuff I'll check later.

Our bug rate will go down in future due to crash.gnome.org; loads of
stuff goes still directly to Bugzilla. In future it will mostly use
crash.gnome.org. ATM I think it is ~1,500/week. It used to be ~500 some
years ago. However, it went down drom 2,500/week (most of 2007).

Database is 6.4GB:
 1.2GB are indexes (*.MYI).
 2.8GB attachment data (excluding indexes)
 2.1GB comments data (excluding indexes)

comment indexes are 938MB btw... possibly splitting longdescs like
attachments (not on bgo.. too old Bz) would provide a speedup.


-- 
Regards,
Olav