Continuous integration of new features and bug fixes is great – but what if a small change in seemingly insignificant code causes a major performance regression in overall server performance? We need to ensure this does not happen. That said, performance regressions can be hard to detect. They may hide for some time (or be [...]
Quality Assurance: Percona Server Development Now Monitored by Automated Sysbench Performance Regression Checks!
October 23, 2012 By Leave a Comment
Here’s a quick way to Foresee if Replication Slave is ever going to catch up and When!
August 29, 2012 By 11 Comments
If you ever had a replication slave that is severely behind, you probably noticed that it’s not catching up with a busy master at a steady pace. Instead, the “Seconds behind master” is going up and down so you can’t really tell whether the replica is catching up or not by looking at just few [...]
On Character Sets and Disappearing Tables
June 21, 2012 By 1 Comment
The MySQL manual tells us that regardless of whether or not we use “SET FOREIGN_KEY_CHECKS=0″ before making schema changes, InnoDB will not allow a column referenced by a foreign key constraint to be modified in such a way that the foreign key will reference a column with a mismatched data type. For instance, if we [...]
Load management Techniques for MySQL
May 6, 2012 By 3 Comments
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 the system causing user experience to degrade. The first thing you need [...]
Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 10 Comments
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 [...]
Diamond Keynote Panel, BOFs, Lightning Talks, and McAfee and AOL Sponsorships
April 2, 2012 By 1 Comment
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 of MySQL industry leaders, including: Sundar Raghavan, director product management at Amazon; Paul Mikesell, CEO of [...]
BOFs and Lightning Talks Announced for Percona Live MySQL Conference & Expo
March 22, 2012 By Leave a Comment
The Percona Live MySQL Conference & Expo is going to be awesome! Great speakers, an A-list of sponsors, countless opportunities to engage with the community, and an enthusiastic crowd of MySQL users ensure this is going to be a great event. The conference features 72 breakout sessions, keynotes by leading industry luminaries, an optional day [...]
A Book-Signing Opportunity for Technical Authors
March 13, 2012 By Leave a Comment
Have you authored a technical book that’s relevant to MySQL users? Want to get great visibility for yourself and your book? We’re planning a book-signing session for the upcoming MySQL conference, and you can participate in it. In brief, we’ll provide a table for you, and you’ll then be able to promote yourself, i.e. post [...]
Early Bird Pricing Ends Today for Percona Live MySQL Conference & Expo
March 12, 2012 By Leave a Comment
Early Bird Pricing for the Percona Live MySQL Conference and Expo ends today, March 12th. Hotel room rates at the Hyatt Regency Santa Clara go up March 19th, if rooms are still available at that time. Save money on your conference pass and hotel room by registering now. The conference features 72 breakout sessions, an [...]
Verifying backup integrity with CHECK TABLES
February 1, 2012 By 4 Comments
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, InnoDB will crash the server to prevent access to the [...]
