Selecting rows holding group-wise maximum is a favorite problem of mine, but one which only rarely pops up. But for some reason, after my last blog post on the subject, it seems to be mentioned almost daily around here. Something that I forgot to mention in the previous post is that most of the examples… Continue reading Selecting rows holding group-wise maximum of a field, part two
Month: November 2008
Det skal for øvrigt være med kælder!
En entreprenør får bestilling på et hus. Arkitekttegningerne kommer på plads, byggeriet går igang, der er rejsegilde, og man bliver klar til aflevering. Bygherren får nøglerne og flytter straks ind, flyttebilen er der allerede. Og da flyttelæsset er på plads, kommer det fra bygherren: “Hov forresten, jeg kommer i tanke om noget: Kan I ikke… Continue reading Det skal for øvrigt være med kælder!
Selecting rows holding group-wise maximum of a field
Today there was a question on the Freenode MySQL channel about a classical problem: Rows holding group-wise maximum of a column. This is a problem that I keep encountering every so often, so I thought I would write up something about it. A good example of the problem is a table like the following holding… Continue reading Selecting rows holding group-wise maximum of a field
Slides for my lightning talks at Open Source Days 2008
In case anyone is interested in a copy of my slides for the two lightning talks I gave at the Open Source Days 2008 conference, I have made them available here: “Optimizing Large Databases Using InnoDB Clustered Indexes:” HTML and PDF. “Profiling with OProfile and Intel Core 2 performance counters:” HTML and PDF. I waqs… Continue reading Slides for my lightning talks at Open Source Days 2008
Free SSL certificates, part 2
Previously I noticed that StartSSL is offering free SSL certificates, ie. proper certificates with a CA chain that is accepted by browsers. Now while setting up my own web-server I had the opportunity to try it out. It seems to work well. The certificate seems to work, Firefox 3 does not spit out any errors… Continue reading Free SSL certificates, part 2
Hobbit monitoring
After setting up Hobbit monitoring on my home network, I discovered a curious issue with the Zyxel P-2602HW router that Fullrate delivers with their ADSL products: The Telnet administration port occasionally times-out connection attemps: I really like the Hobbit monitoring tool, I have used it ever since I heard about it when I met the… Continue reading Hobbit monitoring