On Wednesday of this week (March 15), the European Parliament will vote on this joint motion introduced by the chairmen of the three largest political groups in the EP. The motion is related to the EU’s Lisbon Agenda. Item 43 of the proposed text contains some pro-patent propaganda of the worst kind:

“43. Stresses the need for reforming the current intellectual property rights legislation; notes that the cost of registering a patent in the EU varies between ? 37 500 and ? 57 000 while the same process only costs around ? 10 000 in the USA and that the length and complexity of the patent procedures are major obstacles to small SMEs; calls on the Commission to ensure proper protection of …

“There’s a lot of cool shit going on”

- Anonymous source at DevConf :)

Yes, MySQL 5.1’s new Partitioning feature definitely is a hot topic. Last week’s iPod Nano winner won thanks to interesting partitioning happenings, and this week’s one wins for the same reason.

With that, here comes a hearty congratulation to Jeremy Cole, who’s won himself an iPod Nano!

Jeremy’s been a long-time MySQL user, a one-time employee, and a great help on the mailing lists. In trying out new features in MySQL 5.1, he stumbled upon several bugs, one of which has been fixed. Again, the idea of repeatable bug reports is tantamount to how quickly a developer can fix a problem. (mysql …

our morning are dominated by meetings with the whole development team, which can result in a range of attention being paid. this was taken while monty and patrik were briefing us on a project you?ll hear more about at the mysql users conference in april.

the camera on the table belongs to david axmark, our co-founder who is infamous for taking tons of pictures that nobody ever sees. (that?s also his laptop screen in the bottom corner, he is out of frame.)

So I'm here in Sorrento, Italy at our dev conference and struggling mightily to get a good clone of the 5.1 repository on my box.  You see I'm using BitKeeper with plink (ala Putty) as the SSH tunnel.  The wireless connection on my Inspiron 6000  keeps going down and coming back up and this is something that plink simply can't stand. 

So I installed OpenSSH for Windows (yes the abandoned project that is sort of being maintained).  Worked first time.  Apparently the stock ssh client that comes with cygwin (and therefore with OpenSSH for Windows) is much more tolerant of unstable network connections. 

the mysql developers are all gathered in sorrento, italy, to have the sorts of full-bandwidth discussions that only being close enough to exchange blows can catalyze.

this sort of view will be the norm for the next week as we gather in the hotel meeting rooms, but then i?ll get to spend a day on a tour of pompeii. i hope vesuvius won?t blow up.

(almost) enough said. Good to see people again. Now just a talk to prepare for tomorrow.

Okay, not totally prepare - but a bit of it.

The one I’m giving today - on Cluster Replication is pretty much done. Would like to run through beforehand - but not sure how that plan is going to go.

Big thanks to Roland for finding the first bug with the system which has now been fixed.

I have installed a bug tracker which is accessible at tracker.adoppt.info

As I mentioned in my last post, Adoppt uses 33 MySQL tables (combination of Innodb + MyIsam) and here is a screenshot of the names of those tables. If time permits, I will be posting the UML diagrams soon as well.



In the mean time you can see how this all translates to create the following public home page for a user. Mine for instance is accessible at http://adoppt.com/user/frank …

As I recently found out, MySQL 5.1 claims to support partitioning, but it doesn’t really work, yet.

I tried loading the FlightStats database (feel free to get your copy on dl.flightstats.us) into a MySQL 5.1 instance to try out partitioning. It seemed fairly simple… create an ontime table, partitioned by month, er, wait. Then I hit this bug:

mysql> CREATE TABLE t (
    ->   d DATE NOT NULL
    -> )
    -> PARTITION BY RANGE(d) (
    ->   PARTITION p0 VALUES LESS THAN ('2005-06-02')
    -> );
ERROR 1064 (42000): VALUES value must be of same type as partition function near
')
)' …