Jun 06, 2023 |
Insight for DBAs, Percona Software
This blog was originally published in January 2012 and was updated in June 2023. In today’s data-driven world, the protection and reliability of our valuable information is vital. The potential impact of data loss or corruption on individuals and organizations cannot be understated. Therefore, establishing a strong backup strategy is essential to ensure data security […]
Jun 15, 2012 |
MySQL, Percona Events, Percona Software
Version 1.0.1 of the Percona Monitoring Plugins is released. This is a routine bug-fix release that addresses several minor issues. The Percona Monitoring Plugins are high-quality components to add enterprise-grade MySQL monitoring and graphing capabilities to your existing in-house, on-premises monitoring solutions. The components are designed to integrate seamlessly with widely deployed solutions such as […]
Jun 12, 2012 |
MySQL, Percona Events, Percona Software
The Percona Toolkit team is happy to announce the release of Percona Toolkit versions 2.0.5 and 2.1.2. These are bug-fix releases in the 2.0 and 2.1 series, respectively. These releases fix many dozens of bugs, and we suggest that users upgrade to the latest versions of the tools. The complete list of changes is on […]
Jun 07, 2012 |
MySQL, Percona Events
Percona will be at Southeast Linux Fest tomorrow and Saturday. We’re supporting the event, and we hope to meet you there. If you’ve never been, this is a great regional show that’s grown enormously in the last few years. Peter and I will both be speaking: Peter about optimizing MySQL configuration, and I will talk […]
Jun 02, 2012 |
Benchmarks, Insight for DBAs, MySQL, Percona Software
One of our customers asked me whether it’s safe to enable the so-called USER_STATISTICS features of Percona Server in a heavy-use production server with many tens of thousands of tables. If you’re not familiar with this feature, it creates some new INFORMATION_SCHEMA tables that add counters for activity on users, hosts, tables, indexes, and more. […]
May 08, 2012 |
Insight for DBAs, MySQL, Percona Events
The recording and slides for my webinar on zero-downtime schema changes with MySQL are available now. Don’t miss Vadim’s webinar tomorrow!
May 03, 2012 |
Insight for DBAs, MySQL
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 of the remaining questions […]
Apr 17, 2012 |
MySQL, Percona Events, Percona Software
I’m happy to announce that version 1.0 of Percona Monitoring Plugins is now available. The Percona Monitoring Plugins are high-quality plugins, templates, and add-ons for Nagios and Cacti, so you can add world-class MySQL monitoring to your existing enterprise open-source monitoring products. Version 1.0 fixes a variety of bugs that users found in version 0.9.0. […]
Apr 17, 2012 |
MySQL, Percona Events
Thanks to all of our sponsors, speakers, speaker selection committee, event staff, and especially the attendees for making last week’s conference a resounding success. With over a thousand people, the event made a good comeback after last year’s event, but more importantly, the mood was strongly optimistic. I think a lot of people arrived with […]
Apr 10, 2012 |
MySQL, Percona Events
I’m delighted to announce a partnership with New Relic. The press release has the details (all new Gold and Platinum support contracts get free New Relic subscriptions) but I wanted to add some of the behind-the-scenes context. The quote from me in the press release is a real quote: I really have been telling people […]
Apr 09, 2012 |
MySQL, Percona Events
We have spent months planning and preparing for the MySQL conference that begins tomorrow. It seems appropriate to reflect on this process, where the open source and business communities are now, and what we have planned for the future. The annual April MySQL conference was a strong and growing event for years, drawing hundreds of […]
Apr 05, 2012 |
Insight for DBAs, MySQL, Percona Events, Percona Software
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 large tables with no blocking or downtime. As you know, MySQL locks tables for […]
Mar 26, 2012 |
Insight for DBAs, Percona Software
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 of errors that is relatively easy to diagnose, if you […]
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 other types of systems, because it doesn’t […]
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 plugins? The typical problem with Nagios monitoring (and indeed with […]
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 show the relative amount of time consumed. I’ll profile the “nicer_but_slower_film_list” included with the Sakila sample […]
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 understood to monitor servers correctly. But first, some history. When I […]
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(); } |
Such a simple mistake, but it’s the kind of thing that James Bond movies are made of, isn’t it? […]
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? We’ve considered doing this, and even partially implemented it. But during our pre-release testing, […]
Feb 08, 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 expo hall booth in the Percona Live MySQL Conference in April. Please […]