From Stack Overflow:

I have whole bunch of contact data that may or may not contain all info, like this:

For each email address, I would love to extract the most relevant record, that is the row with the contact information rather than the row with empty fields

To do this we need a sorting criterion: how to tell that a record is considered more relevant than …

Larry Augustin confirmed as SugarCRM CEO. Red Hat’s Fedora Project is 12. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

For the latest on Oracle’s acquisition of MySQL via Sun, see Everything you always wanted to know about MySQL but were afraid to ask

# Larry Augustin was confirmed as full-time CEO of SugarCRM.

# Red Hat, by way of the Fedora Project, announced the launch of Fedora 12.

# Microsoft is to …

This is just a quick start for a brainstorming of what we all hate in todays CMS (I am including portal/community software here as well and I guess most also applies to web shops) software out there. I have written a very small CMS application myself ages ago so I do not have experience in what its really like writing and maintaining a big one. All I know is that its insanely painful to deal with any of them, though if your site is all about having admins managing tons of static content or end users wanting to interact, there is little way around these ugly beasts. I guess it all boils down to how to persist changes made through and admin panel. Somewhat related is the issue of scalability which to me mainly boils down to how easily can the storage logic be changed without changing the business logic on top.

The biggest gripe that results from these ever so powerful admin panels is the tendency to have these settings stored in the …

I'll be doing a Webinar tomorrow (Nov 18) with some of the MySQL folks on how to build fast read-intensive and analytic databases, so join us if you can.  We'll go over some key decision points that can make big differences in the performance of query-based applications and also talk a little about InfiniDB and our approach.

Register at: http://www.mysql.com/news-and-events/web-seminars/display-459.html . Hope to see you there...

I was at OpenSQL Camp 2009 in Portland last weekend. I thought the event was very well done. On Friday we had a pizza party at Old Town Pizza, which was awesome. Saturday and Sunday were breakfast, sessions, lunch (yum), and sessions and hacking. These were held at souk, a co-working space. After 5PM, people got together for dinner, beer, etc.

I presented on mk-query-digest — a live demo of features requested by the audience. Sessions from others that I thought were particularly good included ones on CouchDB and MongoDB. I mixed up the time and missed the session from Tokutek on how fractal tree indexes work. I’ll try to watch the video if that one was taped.

During the hackathons, Daniel and I worked on Maatkit. We are laying groundwork for a more powerful mk-query-digest.

As you may know, I …

I will be presenting a free Webinar on Geographic Replication for MySQL Cluster at 9:00 am (UK time) on Tuesday 24 November.

Multi-Master Replication for HA with MySQL Cluster

MySQL Cluster has been deployed into some of the most demanding web, telecoms and enterprise /
government workloads, supporting 99.999% availability with real time performance and linear write scalability.

You can register on-line here.

Tune into this webinar where you can hear from the MySQL Cluster product management team provide a detailed “deep dive” into one of MySQL Cluster’s key capabilities – Geographic Replication.

In this session, you will learn how using Geographic Replication enables your …

I updated my benchmark scripts this week. These scripts can now
run:

- Sysbench benchmarks for MySQL and Drizzle
- DBT2 benchmarks for MySQL and MySQL Cluster
- TPC-W benchmark for MySQL Cluster

There is also a number of scripts to start and stop
MySQL, Drizzle and MySQL Cluster nodes.

In this version I added Drizzle support for sysbench and also
added a README-AUTOMATED file that describes the steps needed
to set-up a completely automated sysbench run for MySQL
and Drizzle.

To run a MySQL sysbench benchmark one needs the DBT2 tarball,
the sysbench tarball and a MySQL tarball (gzipped tarballs).

The tarball is found on www.iclaustron.com in the downloads
section and this version is named dbt2-0.37.47.tar.gz.

I'll be doing a Webinar tomorrow (Nov 18) with some of the MySQL folks on how to build fast read-intensive and analytic databases, so join us if you can.  We'll go over some key decision points that can make big differences in the performance of query-based applications and also talk a little about InfiniDB and our approach.

Register at: http://www.mysql.com/news-and-events/web-seminars/display-459.html . Hope to see you there...

I'll be doing a Webinar tomorrow (Nov 18) with some of the MySQL folks on how to build fast read-intensive and analytic databases, so join us if you can.  We'll go over some key decision points that can make big differences in the performance of query-based applications and also talk a little about InfiniDB and our approach.

Register at: http://www.mysql.com/news-and-events/web-seminars/display-459.html . Hope to see you there...

I pushed more patches to the Facebook patch for MySQL. Expect more patches as several people are on the team (Domas committed a change today). We will soon be publishing patches for MySQL 5.1. The patches include:

• Protect InnoDB LRU during full table scan. This is a backport from the InnoDB plugin version 1.0.5 (pending release in MySQL 5.1.41) and it fixes bug 45015. This adds the my.cnf variables innodb_old_blocks_time and innodb_old_blocks_pct.
• Add my.cnf variable innodb_mmap_buffer_pool to allocate memory for InnoDB bufer pool using mmap. Read the code. This is a work in progress.
• Provide a fast and non-blocking alternative to FLUSH TABLES WITH …