Around 300 certification exam were given this year at the MySQL Users Conference! That is 50% more than last year. Much of that is due to having the exams online. But the biggest part is from the dedication of Ricky Ho who not only did a fantastic job keeping the exams running smoothly but will spend most of the next week printing up certificates and getting them in the postal system.

An example of a basic MSSQL (Microsoft SQL Server/SQL Server Express) query using PHP.

1
2
3
4
5
6
7
8
9

$szQry = "SELECT column1, column2 FROM foo";
$szDBConn = mssql_connect("host","username","password");
mssql_select_db("database_name", $szDBConn);
$saResults = mssql_query($szQry, $szDBConn);
while($obResults = mssql_fetch_row($saResults))
{
   echo $obResults[0]." ".$obResults[1];
}
mssql_close($szDBConn);

Comments/description of Example

Line #1

SQL statement that will be sent to the MySQL database server.

Line #2

MSSQL database login credentilas; host (127.0.0.1), username and password.

The “host” is the server name or IP address of your database server. If your host has multiple instances the “host” value would be formatted like so …

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
…