Articles having tag: INSIGHT FOR DBAS

Benchmarking single-row insert performance on Amazon EC2

I have been working for a customer benchmarking insert performance on Amazon EC2, and I have some interesting results that I wanted to share. I used a nice and effective tool iiBench which has been developed by Tokutek. Though the “1 billion row insert...

Zero-downtime schema changes webinar recording

By Baron Schwartz

The recording and slides for my webinar on zero-downtime schema changes with MySQL are available now. Don’t miss Vadim’s webinar tomorrow!

Load management Techniques for MySQL

By Peter Zaitsev

One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times. Investigating them we find out what the cause is some batch jobs, reports and other non response time critical activities are overloading...

Zero-Downtime Schema Changes In MySQL

By Baron Schwartz

The recording of yesterday’s webinar, as well as a PDF of my slide deck, is now available. You can watch the recording and get the slides here. I got a lot of questions, and did not have enough time to answer all of them, so let me try to answer some...

Joining many tables in MySQL – optimizer_search_depth

By Peter Zaitsev

Working on customer case today I ran into interesting problem – query joining about 20 tables (thank you ORM by joining all tables connected with foreign keys just in case) which would take 5 seconds even though in the read less than 1000 rows and doing...

Percona Toolkit 2.1 with New Online Schema Change Tool

By Baron Schwartz

I’m proud to announce the GA release of version 2.1 of Percona Toolkit. Percona Toolkit is the essential suite of administrative tools for MySQL. With this release we introduce a new version of pt-online-schema-change, a tool that enables you to ALTER...

Join Optimizations in MySQL 5.6 and MariaDB 5.5

By Ovais Tariq

This is the third blog post in the series of blog posts leading up to the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. This blog post is targeted at the join related optimizations introduced in the optimizer. These optimizations are...

Diamond Keynote Panel, BOFs, Lightning Talks, and McAfee and AOL Sponsorships

By Terry Erisman

I’m excited by all of the recent developments surrounding the Percona Live MySQL Conference and Expo! Our own Baron Schwartz will moderate the Diamond Keynote Panel entitled "Future Perfect: The Road Ahead for MySQL" which will feature a panel...

Introducing the pmp-check-mysql-status Nagios Plugin

By Baron Schwartz

Most of the Nagios plugins included with the Percona Monitoring Plugins are purpose-built for specific scenarios that I found in my research to be frequent, severe, or subtle causes of problems in MySQL systems. They are intentionally not generic because I...

How to diagnose errors in the MySQL error log

By Baron Schwartz

I frequently see questions about how to understand the nature of errors in MySQL’s error log. Now, there is a lot of complexity to this — the flowchart would be quite large, as with any nontrivial piece of software. But there is one particular class...