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 …

It appears that LaunchPad.net is pretty slow.So that people can have something to play with, I have transferred files to my own web site.Presentation files:UC2009_presentation.zipSource downloads:mysql-5.1.34.tar.gzmysql-5.1.33.tar.gzPlease don't melt my router.... kthanx.

Mike Hillyer talks about MySQL Workbench. Very nice workshop! (Hillyer will make slides and screen recording of his talk available.)

This is a great platform-native application. All presentation code is written for each specific platform. It is the second most-popular download and the second most purchased product in the MySQL online shop.  There's a community edition and there's a standard edition of the Workbench. People in the workshop got a 1 year subscription to the commercial, standard edition.

I'm sitting in the room here in MySQL Conference. I'm running a WB 5.1 edition I've built on my MacBook Pro laptop.

One of the best keynotes at this year's MySQL Conference & Expo was a panel session led by Kaj Arnö, MySQL's vice president of community relations.

read more

This year’s Oracle Open World is taking place from October 11-15th, 2009 at the Moscone Center in San Francisco, CA. Paul Vallee noted that Oracle’s acquisition of Sun means that Open World will probably want a MySQL track, and Matt Yonkovit of Big DBA Head mentioned that a blog post on it would spread the word.

The Call for Presentations closes April 26th, which is in just 3 days. You can find out more and submit presentations at http://tinyurl.com/oow09prop. I spoke at Oracle Open World last year on “How to Be an Oracle ACE” and attending the conference was pretty mind-blowing.

If you do submit a talk, feel free to comment here with the title so we can get a broad range of topics submitted, not just 100 speakers …

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 subject. But …

Just to clarify, this is a comparison of Calpont performance against the BKA performance.  Calpont uses a multi-threaded, distributed hash join operation rather than an index operation, and so does not use the BKA access directly.  Note that the BKA performance enhancement clearly is the right direction to improve index operations.  This comparison just shows the power of hash join for big data.

Result graphed.  Note that the graphic contains multiple comparisons with differing conditions. 

The first 2 metrics come from the 2008 UC presentation, the third a Calpont run at a scale factor of 1 (6 million rows in lineitem table), and  are disk runs.  Calpont is configured with one performance module.

The next 2 metrics scale the number of rows by 10x, and 100x with Calpont timings, …

At 11:55 today, thursday April 23, me a Robert Krzykawski are doing a talk on real-world High Availability with MySQL in Ballroom F at the MySQL User Conference, and I know I have written on this before, but I do think this could be interesting, not so much because of what I am going to say, but because of what Robert has to add. Roberts has been working with MySQL and availability with it for many years at bWin and will talk about how they ended with the solution they ended up with.

Also, I thought it would be useful to use this blog post as a board for comments and ideas around this session.

See you in a few hours in Ballroom F
…

So say you have two mySQL servers called A and B. A and B are in a circular replication ring meaning

A replicates from B
B replicates from A

In addition, log-slave-updates is on, so if one server of either A or B goes down you can recover all the data from either side.

Therefore, here are some steps.
Take a snapshot of a server in the ring, with your favorite backup tool (mine is ibbackup)

When either server A or B dies, restore from said backup. Here are the steps. Let us assume server A goes down, and backups are done from server B.

restore the backup of server B to server A

On server-A turn off log-slave-updates (you will see why on the next line)
Add replicate-same-server-id on server A to …

My MySQL Conference presentation on Tuesday discussed my practical findings on how Infobright's technology works in developing a MySQL-based data warehouse. I also touched on a more high-level question of how to select a technology for a different kinds of data-related problem areas, and this article expands on that discussion.

As pointed out by several other speakers at the conference, the balance of CPU, memory and storage has changed significantly in the last 10 years. Two important throughput factors on a per-thread basis have flattened out: CPU cycles per second are in fact dropping as power and cooling have become limiting factors, and the number of IO operations per device have only been increasing linearly, though Flash technologies have leaped on the latter front. However, two other factors are continuing to grow on …