MySQL

PgEast 2011 Day The Second

Well day two here at PgEast has drawn to a close and it was another very informative day.Today I concentrated on the more common tasks of a Pg DBA so I attended three talks (four if you count mine) that where rather heavy on the technical side of being a Pg DBA. Keep reading.

Experienced MySQL DBA Guide to Collaborate

So, you are going to Collaborate (or thinking of going) and you saw my blog post about what to go to if you are a beginner with MySQL. But what if you are more experienced with MySQL? There is plenty of content for you too! I have put together this list of what I would…

MySQL Beginner’s Guide to Collaborate

So, you are going to Collaborate (or thinking of going) and you wonder if, as a MySQL beginner, there will be enough content for you. Or you wonder if there will be too much, and how you will ever decide on what to go to. I have put together this list of what I would…

Free webinar on query reviews using mk-query-digest on March 1st

One week from today, on Tuesday, March 1, 3:00 PM – 4:00 PM US Eastern Standard Time  (UTC-5), I will give a free ODTUG webinar on “Finding Query Problems Proactively With Query Reviews” using mk-query-digest. This presentation will show how to review the queries in your system on a one-time or ongoing basis. Being able to…

NoCOUG (My)SQL Challenge entry #2

A few days ago I learned about this year’s NoCOUG SQL Challenge and decided to to put the gray matter between my ears to work. I’ve been teaching a MySQL course this week and my first impulse was to use my MySQL VM to test my solution attempts. However, I eventually decided to use Recursive Subquery Factoring to solve the proposed problem and had to switch to an Oracle 11gR2, since it’s the only database that implements this feature that I know how to use (are there any others?). I was happy with my solution, but frustrated that I couldn’t run it on MySQL. So I decided to try to make it somehow work on MySQL.

Video: MySQL 5.5 Overview by Bill Papp

On Monday at the February 2011 Boston MySQL User Group Meeting, Bill Papp of Oracle shared a presentation about what’s new in MySQL 5.5.  The video is already up on YouTube and is also embedded at the end of this post. The slides are available as a PDF from http://technocation.org/files/doc/2011_02_14_MySQL_55_Overview.pdf The partitioning article Giuseppe wrote that…

Page 32 of 85« First Page...10...3031323334...40...Last Page »