mayhem

root@totoro:~# /sbin/ifconfig eth0 10.1.3.1 netmask 255.255.255.0 broadcast 10.1.3.255
root@totoro:~# route
Kernel IP routing table
Destination     Gateway         Genmask         Flags Metric Ref    Use Iface
10.1.1.0        *               255.255.255.0   U     0      0        0 eth1
10.1.3.0        *               255.255.255.0   U     0      0        0 eth0
default         gateway.localdo 0.0.0.0         UG    100    0        0 eth1

root@baron:~# /sbin/ifconfig eth0 10.1.3.2 netmask 255.255.255.0 broadcast 10.1.3.255
root@baron:~# route

mayhem

full bonnie run, no raid on random test server in my office:

Version  1.96       ------Sequential Output------ --Sequential Input- --Random-
Concurrency   1     -Per Chr- --Block-- -Rewrite- -Per Chr- --Block-- --Seeks--
Machine        Size K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP  /sec %CP
fuss            16G   611  98 101480  13 42622   6  3245  95 132217   7 359.6   2
Latency             13100us    7577ms    7344ms   16293us   34450us     209ms
Version  1.96       ------Sequential Create------ --------Random Create--------
fuss                -Create-- --Read--- -Delete-- -Create-- --Read--- -Delete--
              files  /sec %CP  /sec %CP  /sec %CP  /sec %CP  /sec %CP  /sec %CP

mayhem

So, instead of this:

[data access layer]
     |           \
[webservice]   [MusicBrainz website]
     |
[picard]


You would get this:

mayhem

musicbrainz_db_20110516=> select * from release_group_primary_type order by id;
 id |   name    
----+-----------
  1 | Album
  2 | Single
  3 | EP
 11 | Other
 12 | Broadcast
(5 rows)

mayhem

Wed Jul 25 19:06:41 2012 WARNING Process 23127 has been running for over 30 seconds
Wed Jul 25 19:06:41 2012 Query: SELECT editor, count(vote.id) FROM vote
                     JOIN editor ON vote.editor = editor.id
                     WHERE NOT superseded AND vote != -1
                       AND cast(privs AS bit(10)) & 2::bit(10) = 0::bit(10)
                     GROUP BY editor, editor.name
                     ORDER BY count(vote.id) DESC, musicbrainz_collate(editor.name)
                     LIMIT 25
Wed Jul 25 19:06:41 2012 STATUS Processes stuck: 23127
Wed Jul 25 19:06:51 2012 STATUS Processes stuck: 23127

mayhem

2012/07/30 00:13:29 [error] 1202#0: *2342872 upstream closed prematurely FastCGI stdout while readi
ng response header from upstream, client: 10.1.1.13, server: musicbrainz.org, request: "POST /edit/
relationship/edit?returnto=http%3A%2F%2Fmusicbrainz.org%2Frecording%2F911c9011-812e-4d61-bedc-5c836
84fe7ff&type1=recording&type0=artist&id=211603 HTTP/1.0", upstream: "fastcgi://127.0.0.1:55901", ho
st: "musicbrainz.org", referrer: "http://musicbrainz.org/edit/relationship/edit?returnto=http%3A%2F
%2Fmusicbrainz.org%2Frecording%2F911c9011-812e-4d61-bedc-5c83684fe7ff&type1=recording&type0=artist&
id=211603"

mayhem

musicbrainz_db_20110516=# select * from pg_locks;
   locktype    | database | relation | page | tuple | virtualxid  | transactionid | classid |  obji
d  | objsubid | virtualtransaction |  pid  |        mode         | granted 
---------------+----------+----------+------+-------+-------------+---------------+---------+------
---+----------+--------------------+-------+---------------------+---------
 relation      |  1416385 |  1600597 |      |       |             |               |         |      
   |          | 189/6412491        |   551 | AccessShareLock     | t
 relation      |  1416385 |  1600580 |      |       |             |               |         |      
   |          | 85/5713022         |   579 | AccessShareLock     | t
 relation      |  1416385 |  1514671 |      |       |             |               |         |      

mayhem

I fixed the things you pointed out about my querying script
I moved the private key-value pair filtering to the querying script -- it makes much more sense that way
Mbids are now looked up in tables and redirect tables as well.
All of the reports are displayed at: http://plaintext.mbsandbox.org/logstatistic, not just a single one
I added a field to the database table: categories. We didn't discuss this, but it was sort of an experiment. Later I might revert to the old schema. The reports are now broken down to categories on the sandbox. You can see a <h1> header before each category. To do this the YAML file was changed too.

I made a blog post too, the same is written there in a bit more detail.
I have a couple of questions that I wan't to ask you, and I hope we can chat tonight after the meeting!

mayhem

Registering github-0.4.0...
Installing library in /home/ghbackup/.cabal/lib/github-0.4.0/ghc-7.4.1
Registering github-0.4.0...
Downloading github-backup-1.20120627...
Configuring github-backup-1.20120627...
Building github-backup-1.20120627...
Preprocessing executable 'github-backup' for github-backup-1.20120627...

Git.hs:36:8:
    Could not find module `Utility.FileMode'

mayhem

ghbackup@wiley:~/backup$ github-backup metabrainz
github-backup: No GitHub repositories found for metabrainz
ghbackup@wiley:~/backup$ github-backup musicbrainz
github-backup: No GitHub repositories found for musicbrainz
ghbackup@wiley:~/backup$ github-backup
github-backup: Not in a git repository.