Xaprb

I’ll be presenting a free one-hour webinar on preventing downtime in production MySQL servers, in conjunction with the ODTUG. It is scheduled on Thursday, November 10, 2011 3:00 PM – 4:00 PM EST, and you can register for free.

Here’s an abstract of what you’ll learn:

Everyone wants to prevent database downtime by being proactive, but how effective are the common measures such as inspecting logs and analyzing SQL? To be truly proactive, one must prevent problems, which requires studying and understanding the reasons for downtime. We have analyzed a selection of emergency issues that we have solved, to better understand what types of problems really occur in production environments. The results are somewhat surprising, and will be detailed in this talk. Most incidents we found were not MySQL-specific and will be familiar to Oracle DBAs as well as MySQL DBAs. This presentation will be valuable for the new or seasoned DBA, as well as to operational managers/directors and CTOs responsible for business critical implementations.

Please register today and I look forward to joining you.

To follow on to my earlier links to Brendan Gregg’s blog posts on measuring I/O latency, there is a third one discussing DTrace, and then a very detailed response from Mark Leith showing how to do it with the PERFORMANCE_SCHEMA in MySQL 5.5.

I wish I could be at the Hotsos Symposium. I would keep my mouth very tightly closed and my ears wide open, and try to learn from people who are completely out of my league about performance analysis topics I won’t grok for another decade (if I’m lucky). But I just can’t cram in that much travel.

If you’re like me, why don’t you go to the O’Reilly MySQL Conference instead? I’ll be trying my feeble best to bring some of the Oracle performance scientist’s mentality to this event, with presentations such as my Forecasting MySQL Performance and Scalability session. And a lot of smart people will be there from many database communities. Percona has a 20% discount, too — not a bad enticement.