Dear MySQL users, MaxDB users and friends,

a new version of MaxDB 7.5.00 has been released recently: MaxDB 7.5.00.34. Two versions of MaxDB have the status of General Availability (GA). MaxDB 7.5.00 and MaxDB 7.6.00 can be used in production environments. Open Source users should use the latest release which is 7.6.00. Last weeks release of 7.5.00 Build 34 (7.5.00.34) is of interest for all 7.5.00 users. Check the Changelog if it shows “must-have” entries for you.

In this issue

This article is part of a MaxDB series on PlanetMySQL that teaches you how to use MaxDB. We hope that we can write about 40 articles in 2006: roughly one per week, published on wednesdays if time …

It doesn't look like I'll be making it to the MySQL User Conference (argh!). I've constructed a list of sessions I'll be missing out on. Perhaps some of the others in Brisbane will take notes for our user group

Monday:

• Optimizing MySQL Applications Using the Pluggable Storage Engine Architecture : Lentz
• MySQL Performance Optimization : Zaitsev, Asplund

Peter Zaitsev is often online at the same time as me. I like to ask him all my idiot InnoDB questions -- he know's his stuff.

Tuesday:

• The 5.1 Release : Aker
• Migrating a Large System to MySQL : Reddy
• MySQL Replication: New Features and Enhancements (RBR) : Thalmann
• MySQL Cluster: New …

A little experiment: filtered outbound feeds...
You can now grab http://www.planetmysql.org/rss20-uc.xml to get a feed with only entries related to the MySQL Users Conference. It's generated using a fulltext query on the various fields from the stored entries.

Thanks to Markus for coming to my quick rescue. Here's what I am trying to do and want to know what approaches would be most efficient.

After seeing the excellent solutions on Arjen's live journal, I started wondering about one thing: scaling the ranks to be within a specified range (1 to 10).


So the highest rank is always 10 and never 11 even if there are 1000 entries in the table.

Is this possible with MySQL? If so, what would be the best way to do it within MySQL (I'd prefer to do it within MySQL without help from a programming language).

--Frank

I came across the excellent quiz posted by Arjen regarding the calculation of ranks using MySQL last year. I found the entire discussion to be very interesting. The only thing that I couldn't find (or missed) is that who actually won the prize? Can any one point me to the solution Arjen chose as most efficient?

Thanks
Frank
MySQL

You may have spotted these items in our program:

• MySQL for Oracle Developers (Ronald Bradford)
• MySQL for Oracle DBAs (Mark Leith)

I categorized them under the "migration" topic so people spot them, but they're really not about migration. You see, many companies actually use Oracle as well as MySQL. So the point is that they exist side by side.

So, the database people in these companies are very experienced Oracle developers and DBAs, and there's nothing one needs to teach them about the basics. But they often also get to deal …

Next week, the MySQL Development Team (around 100 people) will meet for our internal annual development conference in Sorrento, Italy (between Naples and Salerno).

On Tuesday evening (19:30), we would like to meetup with local MySQL users and affiliated OSS developers to chat about MySQL and OSS and go out for dinner together. So if you are located close to Sorrento, please get in touch with us at community at mysql.com for further details! Looking forward to meet you there - I will be attending the conference until Wednesday.

Tomorrow, I’ll be taking off for Sorrento close to Naples in Italy. Some MySQLers are already there, and most of us will come during the weekend. It’s the yearly Developer Conference, where large parts of the Services organisation is also taking part.

I’ll use the time to interview some of our devs about MySQL 5.1 and their User Conference presentations.

All -

Awhile back, I talked about how I use Quest’s Benchmark Factory tool to benchmark new versions or engines in MySQL. Some recent good news is that Quest now has a freeware version out that let’s you run OLTP, data warehouse, and other benchmarks against MySQL in point-and-click style. You are limited to 20 virtual users, but it’s a good start! Check it out when you can.