419539 - Bugzilla stats wanted

Status: RESOLVED FIXED

(bugzilla.mozilla.org :: General, defect)

Description

[Gervase Markham [:gerv]]

I'm giving a talk on Wednesday evening (UK time; Wednesday morning PST) at the Computing Society of Oxford University: "Bugzilla: Software Evolving Under Pressure". It'll be a hopefully humorous look at how software changes when people are screaming at it.

I could do with a few stats about b.m.o., and Mark has kindly offered to provide them :-) If you can't do them all, just provide what you can. Thanks for your help :-)

- How many user accounts?
SELECT count(*) from profiles;

- How many active users?
SELECT who from bugs_activity WHERE bug_when > "2007-01-01 00:00" group by who;

- How many components?
SELECT count(*) from components;

- How many attachments?
SELECT count(*) from attachments;

- How many GB is the Bugzilla DB? 

- How much of that is the attachments table?

- How many servers we are currently using? 

- Where they are located, and how powerful are they?

- Any other interesting geeky info :-)

Thanks :-)

Gerv

Comment 1

[Mark Smith [:xb95]]

- How many user accounts?
301,482 as of now.

- How many active users?
I'm going to assume you want to know how many... 15,915 is the answer.

- How many components?
627.

- How many attachments?
305,619 ... that's kinda spooky that it's so close to the user count.

- How many GB is the Bugzilla DB?
[root@mrdb06 mysql]# du -hs bugs
9.3G    bugs 

- How much of that is the attachments table?
[root@mrdb06 bugs]# ls -alh attach*
-rw-rw----  1 mysql mysql 8.4K Dec 26  2006 attach_data.frm
-rw-rw----  1 mysql mysql 6.6G Feb 25 15:54 attach_data.MYD
-rw-rw----  1 mysql mysql 3.1M Feb 25 15:54 attach_data.MYI
-rw-rw----  1 mysql mysql 8.8K Dec 26  2006 attachments.frm
-rw-rw----  1 mysql mysql  26M Feb 25 15:54 attachments.MYD
-rw-rw----  1 mysql mysql  11M Feb 25 15:54 attachments.MYI

6.6GB.

- How many servers we are currently using? 
- Where they are located, and how powerful are they?

Per justdave a week or so ago:

bugzilla.mozilla.org is currently using a single master/single slave setup with the databases on a pair of HP DL360 G5s (4 x 2.67 GHz Xeons) w/8 GB RAM.  The webservers are 4 DL360 G4s (2 x 3.0 GHz hyperthreaded Xeons) w/4 GB RAM each, behind a Cisco Netscaler load balancer.  And ours also host several other sites as well (both the webservers and the database servers).

We did have bugzilla on a machine by itself recently, which was a DL360 G4 with 8 GB RAM, and it was doing just fine there.  We moved it into the cluster mostly to reduce downtime, since we could reboot for kernel upgrades and so forth one backend machine at a time without taking bugzilla down.

(Per xb95: all of these are in San Jose, CA.)

- Any other interesting geeky info :-)

We are currently setting up a remote instance in Europe that will run off of a slave database.  Right now it's not any faster than the US instance because Bugzilla doesn't have a way to direct read queries at a local slave.  We're investigating using MySQL Proxy to do traffic splitting so read/write queries can go different places.  Not sure if this is relevant in any way, but I find it interesting at least!  ;)

Anyway, this European install is a similar setup as above, except only a single database acting as a slave to the US master.  Two webservers for handling traffic and providing redundancy.

- ...

Hope this is what you need.  Feel free to reopen if there is something else I can do for you.  Best of luck on your presentation!

Comment 2

[Gervase Markham [:gerv]]

Mark: did you use the SQL I gave for active users?

> SELECT who from bugs_activity WHERE bug_when > "2007-01-01 00:00" group by who;

This is, of course, dumb. It should be 2008, not 2007! And I'm sure you are smart enough to "select count()" as well.

If you did use my SQL, can you rerun the query? If not, what definition did you use for "active"?

Gerv

Comment 3

[Mark Smith [:xb95]]

I just used COUNT(*) but used 2007.  The new value for 2008 is 3,402 active users since the beginning of the year!

Let me know if I can be of any further assistance.  :-)