Tuesday, March 22, 2011

Speaking at POSSCON 2011 on Wednesday

Palmetto Open Source Software Conference opens tomorrow in Columbia, South Carolina and I have the privilege at the 4:10 PM Technical Breakout on What's new in MySQL. If you are attending the conference, please drop buy to say 'hi'.

Thursday, March 17, 2011

MySQL & Oracle presentation -- Dallas, March 19th

I will be speaking at the North Texas Linux1 Users Group Saturday, March 19th on MySQL and Oracle at 11AM. Directions here.

NTLUG features an install project, a beginners lecture, and then the feature presentation. Hopefully I will have some time to demo MySQL Workbench and more.

1. Opps! First time I posted I posed MySQL instead of Linux. Sorry for the confusion!!

Tuesday, March 15, 2011

Oracle Open World MySQL Track call for papers open

Oracle Open World will feature this year a dedicated MySQL track under the Database stream. The call for papers was announced for the show which will be held October 2-6, 2011 at the Moscone Center in San Francisco. So polish up your material on your MySQL storage engine, success story, tips, research, projects, implementation and/or experience so you can submit your proposal as soon as possible. The call for papers closes March 27th!

From the press release: “From C-level executives to developers, Oracle OpenWorld is a venue for customers and partners to share their ideas, experiences, and accomplishments regarding Oracle products and solutions. This year we look forward to receiving thousands of presentation proposals to help us deliver a unique experience to a diverse global audience,” said Tania Weidick, vice president, Oracle Corporate Event Marketing. “We’re also excited to welcome the MySQL community in a dedicated track designed to provide MySQL users with practical tips and best practices from the vibrant ecosystems of the MySQL community, customers, partners and Oracle's MySQL engineers.”

Wednesday, March 9, 2011

Free Hadoop class in Dallas

Cloudera Instructor Tom Hanlon will be presenting a free class on Hadoop Tuesday March 15th on Dallas. Tom is a familiar face to MySQLers in the North Texas area having previous taught many MySQL classes.
Pizza and Drinks will be provided.

This will be an excellent opportunity for MySQL DBAs to learn from booth a MySQL and Hadoop expert. Hadoop is a computational paradigm named Map/Reduce, where the application is divided into many small fragments of work which may be executed any node in the cluster.

Register Here as they may need to shift locations to find the anticipated crowd.

Wednesday, March 2, 2011

When did that statement finish?

A friend wanted to go to lunch but need to time (roughly) how long a UPDATE took on one of his instances.
The friend had a co-worker who said the statement would take X time and the friend was pretty sure it was X/2. Me? I was hungry.

I edited the ˜.my.cnf and added the following:


This changes the mysql client prompt from mysql> to 11:42:22am>. The friend started the mysql client, entered the query, and we went to lunch. We when returned, there on the prompt line was the time the command finished.

An old simple trick but it did what was needed. The documentation on the prompt string details more options. I probably would not want to use this trick for more than the crudest of benchmarks. I do use something similar to display the hostname when dealing with slaves in replication.