by Baron Schwartz | Feb 23, 2012 | Insight for DBAs, MySQL
For about the past year I’ve been formulating a series of tools and practices that can provide deep insight into system performance simply by looking at TCP packet headers, and when they arrive and depart from a system. This works for MySQL as well as a lot of... by Baron Schwartz | Feb 22, 2012 | Insight for DBAs, MySQL
In this post, I’ll cover the new MySQL monitoring plugins we created for Nagios, and explain their features and intended purpose.I want to add a little context. What problem were we trying to solve with these plugins? Why yet another set of MySQL monitoring... by Baron Schwartz | Feb 20, 2012 | Insight for Developers, MySQL
SHOW PROFILES shows how much time MySQL spends in various phases of query execution, but it isn’t a full-featured profile. By that, I mean that it doesn’t show similar phases aggregated together, doesn’t sort them by worst-first, and doesn’t... by Baron Schwartz | Feb 19, 2012 | Insight for DBAs, MySQL
In response to the release of our new MySQL monitoring plugins on Friday, one commenter asked why the new Nagios plugins don’t use caching. It’s worth answering in a post rather than a comment, because there is an important principle that needs to be... by Baron Schwartz | Feb 17, 2012 | Insight for DBAs, MySQL, Percona Events, Percona Software
We’ve released a new set of monitoring plugins for MySQL servers and related software. With these plugins, you can set up world-class graphing and monitoring for your MySQL servers, using your own on-premises Cacti and Nagios software. The Cacti plugins are... by Baron Schwartz | Feb 15, 2012 | Insight for DBAs, Insight for Developers, MySQL
Wouldn’t it be nice if you could get expert advice on your SQL queries to find problems in them, the same way that programmers can use lint-check tools to warn about bugs in their C? if ( execute = 1 ) { launch_missile(); } 123 if ( execute = 1 ) { ... by Baron Schwartz | Feb 10, 2012 | Insight for DBAs, MySQL
A couple of users of our very popular MySQL Configuration Wizard have submitted feedback such as “I’d love to input my existing server settings and get suggestions on how to improve it.”This sounds like it would be great, doesn’t it?... by Baron Schwartz | Feb 8, 2012 | MySQL, Percona Events
This is a cross-post from my personal blog. Are you involved with an open-source project that’s interesting to MySQL users, such as Nginx, PHPMyAdmin, Drupal, Jenkins, PHP, and so on? Percona just published the application form for dot-org groups to have a free... by Baron Schwartz | Feb 6, 2012 | Insight for DBAs, MySQL, Percona Events, Percona Software
We’ve released Percona Toolkit 2.0.3, with a couple of major improvements and many minor ones. You can download it, read the documentation, and get support for it.What’s new? You can read the changelog for the details, but here are the highlights:Brand new... by Baron Schwartz | Feb 1, 2012 | Insight for DBAs, MySQL
An attendee to Espen’s recent webinar asked how to check tables for corruption. This kind of ties into my recent post on InnoDB’s handling of corrupted pages, because the best way to check for corruption is with CHECK TABLES, but if a page is corrupt,... by Baron Schwartz | Jan 26, 2012 | Insight for DBAs, MySQL
We’ve released an updated version of the MySQL Configuration Wizard we announced at the end of last year. If you don’t remember that announcement, here’s the short version: this is a tool to help you generate my.cnf files based on your server’s... by Baron Schwartz | Jan 19, 2012 | Insight for DBAs, MySQL
With the recent release of Percona XtraDB Cluster, I am increasingly being asked about MySQL’s semi-synchronous replication. I find that there are often a number of misconceptions about how semi-synchronous replication really works. I think it is very important... by Baron Schwartz | Jan 9, 2012 | Insight for DBAs, MySQL, Percona Events, Percona Software
You probably saw that Vadim blogged about the first alpha release of Percona XtraDB Cluster. Just in time: now I can talk about it at my High Availability talk in Percona Live DC! If you’re coming, be sure to catch us in the hallway and ask those specific... by Baron Schwartz | Jan 6, 2012 | Insight for DBAs, MySQL, Percona Software
I got a question a while ago about how Percona Server handles corrupted data more gracefully than the standard MySQL server from Oracle. The short version is that it won’t crash the whole server.With standard MySQL from Oracle, if any page of data in InnoDB is... by Baron Schwartz | Jan 3, 2012 | MySQL, Percona Events
In just over a week, we’ll be running a Percona Live MySQL conference in the nation’s capital, in a beautiful modern conference facility that has its own Metro rail stop. And for a limited time, you can save 20% with this discount code: PerLiveDC.If... by Baron Schwartz | Jan 3, 2012 | MySQL, Percona Events, Percona Software
I’m happy to announce that we’ve released Percona Toolkit 2.0.1, a major new version of our essential DBA toolkit, as well as a minor bugfix update to the old 1.0.x series. You can download it from the project homepage, or install it through our RPM and... by Baron Schwartz | Dec 23, 2011 | Insight for DBAs, MySQL, Percona Events
Update: Percona will no longer be offering the free services of Query Analyzer and MySQL Configuration Generator hosted at tools.percona.com. We made this decision based on observed low usage numbers, outdated technology, and lack of support for MySQL 5.7+,... by Baron Schwartz | Dec 20, 2011 | MySQL, Percona Events
Not to be outdone by Vadim’s announcement, I also have one: Percona Toolkit’s manual is now available as PDF (requires registration). You can get it here: https://www.percona.com/software/percona-toolkit/Thanks to Mauricio Stekl, who did all the hard work... by Baron Schwartz | Dec 7, 2011 | MySQL, Percona Events
If you are close to Washington DC, you should plan to attend our Percona Live event on January 11th at the DC Convention Center. We have three tracks of expert speakers on core MySQL-related topics.This event will not be as large as some of the other events... by Baron Schwartz | Dec 2, 2011 | Insight for DBAs, MySQL
Over the last few years, Domas’s technique of using GDB as a profiler has become a key tool in helping us analyze MySQL when customers are having trouble. We have our own implementation of it in Percona Toolkit (pt-pmp) and we gather GDB backtraces from pt-stalk...