To begin to profile the Calpont multi-threaded, distributed hash join capabilities, we used one of the queries from Igor Babaev's BKA presentation from UC '08.  Detail was not provided on class of server used in the BKA presentation, so this isn't a direct comparison, only an approximation.  The bench started with 1 Calpont performance module (our distributed tier) - a Dell 8 core server with 16 GB memory.  We then extended the demo to understand how scaling our distributed tier impacted the join rate. 

The query was a join between two DBT3 tables; Lineitem and Part.  The number of rows varies by a scale factor (sf), for example sf1 is ~1GB, sf10 is ~10GB, sf100 is ~100GB. 

Rows (Millions)
Table             sf1     sf10     sf100
…

Oracle risks alienating MySQL's developers, given that it might have little incentive to ensure its future success. This could provide fodder for a fruitful fork--by Red Hat.

Did you get your certification during the User Conference? If so, be sure to stop by the MySQL Certified Professionals LinkedIn page and request membership! Congratulations on your certification!!MySQL DBA & Programming Blog by Mark Schoonover

Did you get your certification during the User Conference? If so, be sure to stop by the MySQL Certified Professionals LinkedIn page and request membership! Congratulations on your certification!!MySQL DBA & Programming Blog by Mark Schoonover

Today is the final day to take a MyQL Certification exam at the Users Conference. Save money with the special $25 price from the regular $200.

Are you new to MySQL -- try the associate exam? It is designed for those with 6 weeks to 6 months of experience with MySQL.

Or do you consider yourself at Guru level but do not have your Cluster DBA cert? Today is your chance to prove your skill.

There apparently was T-shirts for speakers at the MySQL Conference but a few of us speakers have not received them - it was not clear where to get them from in the conference hall and there was confusion when I asked other speakers when I asked them as they did not know. Well - it seems that there was a conference T-Shirt but it was from the conference hall (which is now all packed up and gone) .

One of the most interesting themes I have been paying attention to at this years Mysql users conference is techniques to create highly available storage volumes without spending a million dollars on a SAN or NAS infrastructure using companies like EMC or Network Appliance or IBM.

At least 3 options exist that I was not aware of before:

Amazon Elastic Block Store: as part of Amazon's EC2 web services you can have a virtual block level device available from your EC2 instance. Using this block level device you can either mount a typical linux filesystem and access the device with standard file access system calls or you can even do raw IO against the device without a filesystem. The data is stored on amazon's cloud, and is thus relatively highly available. As with all Amazon services you only pay for what you use. I was quoted performance numbers around 100 MB / sec which seems quite reasonable. You can only mount the …

Once again, I was unable to attend all of the sessions I wanted to at this year's User Converence, but I was happy to make it to Bob Burgess' talk on bash scripting with mysql. The slides and examples aren't up yet, but when they are (which may be as you read this, check the last link), they would probably also be a great tutorial.

So, I got bore\^D\^D\^D\^D inspired later that day to put some of the practices into use, and worked up a script to run mysqlslap in various ways against a server, and then added a couple funcitons to try it out on each storage engine. The script is below in its entirety - bash scripters, please be kind in your comments. No, I didn't write all this just for the pun in the …

Once again, I was unable to attend all of the sessions I wanted to at this year's User Converence, but I was happy to make it to Bob Burgess' talk on bash scripting with mysql. The slides and examples aren't up yet, but when they are (which may be as you read this, check the last link), they would probably also be a great tutorial.

So, I got bore\^D\^D\^D\^D inspired later that day to put some of the practices into use, and worked up a script to run mysqlslap in various ways against a server, and then added a couple funcitons to try it out on each storage engine. The script is below in its entirety - bash scripters, please be kind in your comments. No, I didn't write all this just for the pun in the …

I'm incredibly elated to announce the release of DBD::drizzle 0.100. What is different about this release? It uses Eric Day's new client library, libdrizzle! This means we could eventually package the client with DBD::drizzle, eliminating the issues I have with DBD::mysql where code doesn't compile because of trying to compile DBD::drizzle against a MySQL client binary produced on a different machine with a different compiler and compile flags.

I want to thank Clint Byrum - immense thanks- for his work, which the majority of, made this possible. He and I spent the last several days together at the users conference going over the code, getting it to work. We achieved together more in hours time what would have taken days or even weeks. I'm also glad to have gotten to know Clint-- it's great to make new friends!

The next step is that we'll probably write this from scratch at some point. Right now, this is a retro-fit of …