MySQL

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…

Pythian Q1 2011 Speaking: Find us at RMOUG, Hotsos

Pythian will be at RMOUG in full force. Look for Alex Gorbachev, Kellyn Pedersen & Don Seiler. Be sure to stop by our table (#10), say hi to us & our friends from the OakTable Network, and enter our draw to win an Amazon Kindle, and software provided by Cary Millsap (MR-Trace, MR-Tools & Method-R Profiler) among a few other surprises. Pythian is agressively hiring top DBA talent. If this is you, register on our Career Center, or request a time for a short intro chat with Pythian. Alex, Kellyn or Don will be more than happy to give you the inside scoop on the company & share why they love working for Pythian.

DBIx::Class::DeploymentHandler is Awesome

DBIx::Class::DeploymentHandler is a fairly young module. It’s a little raw at the edges and a wee bit terse in term of documentation. It’s also a complex thing and, trust me, it’ll takes more than a few minutes of playing with it to get your mind around how it works. But once you begin to understand what it can do, Whoa, that’s one seriously powerful beast, that module is. But don’t take my word for it, let me show you.

What Happens when InnoDB Fails to Start

Today I’ve spent some time (more than this issue was worth, actually) on a client’s system trying to find out why table was not accessible and failed. The error message suggested something went very wrong with .frm file and I already started thinking about restoring the table from backup, when I noticed that accessing any InnoDB table was producing same error. A quick check of the error log showed that when MySQL server was restarted some time ago InnoDB failed to initialize due to a memory issue.

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