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
')
)' …

The article is Ten of the Biggest Mistakes Developers Make With Databases

Read it, read it now.

The current version of mysqldump can export a database to a tabbed output. This is nice, but it seems it can only do one database at a time.

I wrote a quick script to attempt to merge multiple tab dumps. It's incomplete -- and the chmod 777 in it is definitely evil.

Tab dumping is faster for MySQL to import than an SQL dump, and it produces a smaller file. With a bit of work, this is the way to get your exports as small as possible. This helps if you had to rebuild a slave on another network, and/or you pay too much for bandwidth!

Your thoughts appreciated.
See:

I’m in Sorrento for the annual MySQL internal developers meeting, and had some really excellent espresso after dinner tonight. The result is that it’s 2AM and I’m pulling code out of bitkeeper and looking at bugs rather than sleeping, even though I am supposed to get up at 6AM to go have breakfast.

I did Windows development for many years, but these last few months I’ve spent most of my time on Linux and OSX, mostly because Ubuntu just works so well on my laptop, especially now that I’ve got Tomboy and NetworkManager. I switched back to Windows during meetings last week in order to spend some time working on reproducing BUG#17719, delete of binlog fails on windows, and I’ve been forced to acknowledge that running the MySQL test suite on Windows isn’t nearly as smooth as it should be. Fortunately, Reggie has done some great stuff with CMake, and Magnus fixed …

I finally managed to hook into our wireless LAN here at our conference hotel. The flight from Hamburg to Naples via Munich was uneventful, I met Jan at Hamburg airport and we bumped into a whole bunch of MySQLers at the Munich airport already. From Naples airport it was another exciting hour to Sorrento in a small bus - I completely forgot that Italians have a slightly different driving style than us germans

I am looking forward to the meeting which officially starts tomorrow. I will be giving a presentation about the MySQL Community work and hope to encourage some more of our developers to become more active in there...

As part of my A call to arms! post about a month ago, I’ve had a number of unofficial comments of support. In addition, I’ve also been approached to assist in the completion of a MySQL Transactional support engine. More information on the PBXT engine will be forthcoming soon by it’s creator.

Anyway, I’ve taken on the responsiblity of assisting in testing this new storage engine. This will also give me the excuse of being able to pursue some other ideas about the performance of differing storage engines for differing tables in business circumstances, such as MyIsam verses InnoDB in a highly OLTP environment. Part of testing will be ensure ACID conformance in varying situations and multi-concurrency use. Of course the ability to also do performance and load testing would be a obvious extension.

Considering how I’m going to benchmark is an interesting …