MySQL Tech Tour Event – Santa Clara, CA
Thursday, February 9, 2012
http://www.oracle.com/go/?&Src=7314534&Act=247&pcode=WWMK11042736MPP125

MySQL Tech Tour Event – El Segundo, CA
Wednesday, February 8, 2012
http://www.oracle.com/go/?&Src=7314534&Act=249&pcode=WWMK11042736MPP127

MySQL Tech Tour Event – Raleigh, NC
Thursday, February 2, 2012
http://www.oracle.com/go/?&Src=7314534&Act=248&pcode=WWMK11042736MPP126

…

I am working on a presentation for the San Francisco MySQL Users Group on using EXPLAIN and EXPLAIN EXTENDED. But I need some help from the MySQL Community. Do you have any good examples of EXPLAIN EXTENDED providing unexpected results when compared to the original query? Please post your statement and possibly a SHOW CREATE TABLE below or send them to david.stokes AT Oracle.

Thanks!

…

The deadline for proposals has passed, and there are 37 talk proposals and 12 time slots. In order to have the best possible program, we need your help. There is public voting on proposals, votes are accepted via twitter or via email. Please Vote for MySQL and Friends at FOSDEM 2012 devroom talks. Thank you!

MySQL 5.6.4 & MySQL Cluster 7.2 availbale from http://Labs.MySQL.Com

MySQL 5.6.4 Development Milestones are ready for your review. This week there are seven 5.6.4 releases to try plus MySQL Cluster 7.2! So try the Binary Log API, Binary Log Group Commit, Global Transaction IDs, InnoDB features, InnoDB Full Text Search, Enhanced Performance Schema, or Memcached/InnoDB versions this holiday season. And let the developers know your feedback please!

And very soon fellow MySQL Community Manager Keith Larson and I will be hitting the road, First stop is the Southern California Linux Expo which features as MySQL Day this year. Then we head to the upper half for the state for the Oracle Leadership Summit to help the Leaders of MySQL User Groups grow …

If a DBA needs to reset the mysql root password – one method of doing this is to run mysqld with -skip-grant-tables as a command line parameter. This is a bad practice for many reasons and as a DBA friend of mine says – it’s a lot like locking your door with the window open. If you are using mysql for especially secure data you should consider your options.

One option, and likely preferred, is to replace the default mysql from various sources with one built with this feature disabled – see http://dev.mysql.com/doc/refman/5.1/en/source-configuration-options.html#option_configure_disable-grant-options

I am not aware of any distro’s that are built with this option – but seems like a fair number of folks out there would appreciate having a build like this.

But …

Normally I write for the MySQL DBA audience. But this blog entry is different. Print out a hard copy and hand it to friends and family when they ask you what sort of presents you want for Christmas, Hanukkah, Festivus or other end of the year gift exchange instead of grunting ‘I do not know1‘ and ending up with something you will have to pretend to like.

Yes, your MySQL DBA is hard to shop for during the holiday season. Their needs are few2 or expensive. So what can you get them on the cheap that will make them happy?

Gift Ideas

1. T-shirts are probably the majority of your DBA’s attire, despite your best efforts.
   1. Zazzle offers a World’s Best DBA t-shirt. You may also be able to get away with remark that the Nobel Prize committee had to …

MySQL is the 2011 Readers Choice Award for Best Database.

It may not be the most-exciting topic around, but databases make the world go round. MySQL with its dolphin mascot takes first place again this year, with more than twice as many votes as its closest competition, PostgreSQL.

However, I do take issue with the It may not be the most-exciting topic around quip. MySQL is very exciting!

…

Keith Larson and I will be presenting MySQL for Oracle DBAs or How to Speak MySQL for beginners at Collaborate 12 in April at the Mandalay Bay hotel in Las Vegas.

…

Following the tradition, there will be a “MySQL and Friends” devroom at FOSDEM 2012. The devroom is scheduled for Sunday 5th February 2012, whole day. If you are interested to give a talk, please submit it before December 26th through this submission form.

Link to original announcement by Frédéric Descamps

I work at ideeli and wrote up a two parter for our Tech Blog about finding problem queries in MySQL…

Finding Problem Queries, Part 1: The Slow Stuff

…