by Michael.Bender | Feb 21, 2012 | MySQL
So there I was, gesticulating in front of the chalkboard, lecturing to 120 students. Topic: the beauty of advanced data structures. The door opens and the department chair walks up the aisle onto the stage and comes up to me. 242 eyes follow her progress through the...
by Daniel Nichter | Feb 21, 2012 | Insight for DBAs, MySQL, Percona Software
DBD::mysql 4.014 breaks pt-table-checksum 2.0. The cause is unknown, but the effect is a lot of errors like: DBD::mysql::st execute failed: called with 2 bind variables when 6 are needed [for Statement “…” with ParamValues: …] at...
by Miguel Angel Nieto | Feb 20, 2012 | Insight for DBAs, MySQL
In my previous post I explained how it could be possible to recover, on some specific cases, a single table from a full backup in order to save time and make the recovery process more straightforward. Now the scenario is worse because we don’t have a backup or...
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 Peter Zaitsev | Feb 20, 2012 | MySQL, Percona Events
A quick reminder. I’m speaking on two MySQL meetups in North Carolina this week. Tuesday,Feb 21 on Raleigh MySQL/PHP Meetup and when Wednesday, Feb 22 on Charlotte Queen City PHP Note the last meetup date has changed, it was originally planned for February 23...
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 Vadim Tkachenko | Feb 18, 2012 | Benchmarks, MySQL
MariaDB 5.3 has reached the release candidate milestone, and the 5.3 version promises a lot of new features and optimization (i.e in optimizer http://kb.askmonty.org/en/what-is-mariadb-53#query-optimizer). No surprise I wanted to check how all improvements affect...
by Peter Zaitsev | Feb 18, 2012 | MySQL
MySQL Settings (also known as Server Variables) have interesting property. When you set variable in running server this change is not persisted in any way and server will be back to old value upon restart. MySQL also does not have option to re-read config file without...
by Jay Janssen | Feb 17, 2012 | MySQL
This is a time-honored topic, and there’s no shortage of articles on the topic on this blog. I wanted to write a post trying to condense and clarify those posts, as it has taken me a while to really understand this relationship. Some basic facts Most of us know...
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 Peter Zaitsev | Feb 15, 2012 | Insight for DBAs, MySQL
So lets say you upgraded from MySQL 5.1 to Percona Server 5.5 and instead of expected performance improvement you see your performance being worse. What should you do ? First if you followed MySQL upgrade best practices such as testing your workload with pt-upgrade...
by Vadim Tkachenko | Feb 14, 2012 | MySQL, Percona Events
On coming PL MySQL conference 2012 I will give one tutorial: Percona XtraBackup: install, usage, tricks. This tutorial I will do in joint with Alexey Kopytov, the lead developer of Percona XtraBackup. Our intent is to provide the comprehensive overview of the...
by Stewart Smith | Feb 10, 2012 | MySQL, Percona Software
Percona is glad to announce the release of Percona XtraBackup 1.6.5 on 10 February, 2012 (Downloads are available here and from the Percona Software Repositories). This release is purely composed of bug fixes and is the current stable release of Percona XtraBackup....
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 Tokutek | Feb 9, 2012 | MySQL
We are excited to announce that we’ve been named as one of ten finalists selected for the startup showcase at the O’Reilly Strata “Making Data Work” Conference at the end of this month in Santa Clara, California. The startup showcase will be held...
by Stewart Smith | Feb 8, 2012 | Cloud, Percona Events
Percona is proud to sponsor the 4th Drizzle Day, this year being held on the 13th April, the day after the Percona Live MySQL Conference and Expo. When: Friday, April 13th 2012 from 9:30 am Where: Cypress room, Mezzanine Level, Hyatt Regency Santa Clara (5101 Great...
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 Tokutek | Feb 6, 2012 | MySQL
While it might not have been New England’s weekend on the Big Gridiron, it was certainly New England’s day for Big Data at the New England Database Summit on Friday at MIT. The summit was well attended, with 350 registrants and keynotes from prominent MySQL users such...
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...
by Peter Zaitsev | Feb 6, 2012 | MySQL, Percona Events
February is going to be a busy meetup month for me. In addition to speaking in Raleigh I will visit Charlotte to speak at Meetup out there on February 23rd. Last year I visited Charlotte meetup was in the great place and we had great food and great crowd of people...
