'MySQL' Category

• Tales of the Trade #6: Percona Live 2013

  April 6, 2013

  posted in MySQL by shlomi

• Percona Live 2013 schedule & events summary

  April 2, 2013

  Here's the (hopefully) complete list of events throughout and following the upcoming Percona Live MySQL Conference & Expo, 2013. The schedule is quite packed! Make sure to take a deep breath beforehand: Monday, April 22 09:30 - 16:30: Tutorials 16:30 - 18:30: Welcome reception in Expo Hall 18:30 - 20:30: MySQL Community Reception by Oracle [...]

  posted in MySQL by shlomi

• Assistance wanted: DotOrg Pavilion on Percona Live 2013

  April 2, 2013

  I'm looking for assistance in manning a DotOrg Pavilion on the upcoming Percona Live conference in Santa Clara. As you may or may not know, free and open source projects are eligible to ask for a free booth on the Expo hall. This is a good chance to promote one's project. Of course, someone must [...]

  posted in MySQL by shlomi

• Speaking on the media: OurSQL, Reversim

  March 21, 2013

  I had the pleasure of speaking on two excellent podcasts: OurSQL No need for me to introduce this podcast. I just have to say it was only when I interviewed that I realized the amount of work taken for producing one single cast. Kudos to Sheeri & Gerry and Rich Goyette the sound producer and [...]

  posted in MySQL by shlomi

• MySQL Stored Routines Debugger & Debugging API: sneak preview II, video

  March 21, 2013

  This is the 2nd sneak preview of common_schema's rdebug: debugger & debugging API for MySQL stored routines (see 1st preview here). rdebug will be released as part of common_schema, free and open sourced. In this sneak preview I present: Compiling multiple routines with debug info Starting/stopping a debug session Step-over, step-in, step-out Showing stack trace [...]

  posted in MySQL by shlomi

• Cheating mysqlsandbox to install MariaDB 10.0

  March 17, 2013

  mysqlsandbox is version-aware. The new 5.6 version, for example, requires special care because of the system InnoDB tables or otherwise modified system tables. At this moment, it will refuse to install MariaDB 10.0 (alpha): bash$ make_sandbox /tmp/mariadb-10.0.1-linux-x86_64.tar.gz unpacking /tmp/mariadb-10.0.1-linux-x86_64.tar.gz unsupported version 10.0 This is perfectly legitimate, and I have no quarrel with this fact. However, [...]

  posted in MySQL by shlomi

• Percona Live 2013 news: Oracle, BoF, Lightning Talks

  March 12, 2013

  Oracle Oracle? Oracle! We're extremely happy to have Oracle as presenter in Percona Live 2013! You can expect three sessions by Oracle engineers: • MySQL 5.6: Performance Benchmarks, Tuning, and Best Practices - Dmitri Kravtchuk • MySQL 5.6: What’s New in InnoDB - Sunny Bains • MySQL 5.6: Redefining Replication - Luís Soares And Tomas [...]

  posted in MySQL by shlomi

• Merging tables with INSERT...ON DUPLICATE KEY UPDATE

  February 21, 2013

  Had a case recently where I had to merge data from two identically structured tables containing nearly identical data. "Nearly identical" meaning most table data is identical in both; sometimes a row is missing from one of the tables; sometimes same row (according to PK) appears in both, but some columns are NULL is one [...]

  posted in MySQL by shlomi

• MySQL Stored Routines Debugger & Debugging API: sneak preview video

  February 19, 2013

  This is a sneak peek video introduction/preview of an in-development free and open source server side debugger & debugging API for MySQL stored routines. MySQL does not provide server side debugging capabilities for stored routines. Some tools exist, including MySQL's own, that assist in stored routine debugging. These are all GUI based and, to the [...]

  posted in MySQL by shlomi

• Win a free Percona Live 2013 pass -- unveiling riddle hints

  February 11, 2013

  Apparently my first attempt at rhyming proved to be unsuccessful: only two courageous men attempted solving the riddle. As I'm pretty sure a free pass would appeal to many, and I do have a few readers for my blog, I must conclude my riddle was just too hard. Obscure, perhaps. Hope I didn't scare anyone [...]

  posted in MySQL by shlomi