Feb 06, 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 pt-diskstats, thanks to Brian Fraser. This tool is completely rewritten, and […]
Feb 01, 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, InnoDB will crash the server to prevent access to the […]
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 hardware and other characteristics. We’ve gotten really good feedback on this tool, including […]
Jan 09, 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 questions that won’t be addressed in a […]
Jan 03, 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 DEB repositories. Documentation is online (and the 1.0 docs […]
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+, MongoDB, and PostgreSQL. You might wish to consider some other options, which offer similar and effective tools […]
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 to create the PDF of the manual — and did it fast, too.
Dec 07, 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 we’ve run, with a capacity of about […]
Dec 02, 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 and pt-collect. Although it’s helped us figure out a […]
Nov 30, 2011 |
MySQL, Percona Events
We announced a while back that we were going to continue the traditional MySQL conference in Santa Clara, because O’Reilly wasn’t doing it anymore. But we haven’t given an update in a while. Here’s the current status: We created a conference committee. We created a conference website that allows people to create an account and […]
Nov 21, 2011 |
Insight for DBAs, MySQL
Now that InnoDB is the default storage engine in MySQL, is it time to update the default configuration for the InnoDB log file size (innodb_log_file_size) setting? In general, there are two settings that simply can’t be left at their historical defaults for a production installation. MySQL 5.5 increased the default buffer pool size to something […]
Nov 04, 2011 |
Insight for DBAs, MySQL
Global transaction IDs are being considered for a future version of MySQL. A global transaction ID lets you determine a server’s replication position reliably, among other benefits. This is great when you need to switch a replica to another master, or any number of other needs. Sometimes you can’t wait for the real thing, but […]
Oct 21, 2011 |
Insight for DBAs, MySQL
Percona Live London starts on Monday, so this is the last in the series of free-Percona-Live tickets we’ll give away. But first — have you ever wondered what servers are in your MySQL replication hierarchy? We have, too. As consultants, a lot of times we need to get a quick overview of the whole replication […]
Sep 30, 2011 |
MySQL, Percona Events
It’s Friday again (already?) and as usual, we have a free ticket for Percona Live London. This time Tokutek is doing the honors of running the contest and selecting the winner. Instructions for entering the contest are on their blog, at the top of my recent guest post about covering indexes.
Sep 19, 2011 |
Benchmarks, Hardware and Storage, MySQL
Our latest MySQL white paper is Improving Percona Server performance with Flashcache on the Virident tachIOn Drive. (Virident funded the research, but as always, we wrote the report ourselves.) The conclusion is that Flashcache can be good for read-heavy workloads, but more research is needed to understand its performance characteristics on write-heavy workloads. We explain […]
Sep 15, 2011 |
MySQL, Percona Events
This week’s TGIF give-away contest is a day early, and it’s a guest post over on the Engine Yard blog: 5 subtle ways you’re using MySQL as a queue, and why it’ll bite you. Go there to read the full post, and watch @engineyard’s Twitter feed for the chance to enter the contest for free […]
Sep 07, 2011 |
MySQL, Percona Software
Daniel and I and the Percona release engineering team are proud to announce version 1.0.1 of Percona Toolkit. This toolkit is Percona’s suite of DBA and sysadmin productivity tools for MySQL. It is the successor to the popular Maatkit and Aspersa toolkits. Percona Toolkit is available for immediate download at percona.com/downloads/percona-toolkit/. Helpful links: Reference Manual […]
Sep 02, 2011 |
Insight for DBAs, MySQL, Percona Events
It’s Friday again (so soon!) and time for our TGIF contest, to give away a free ticket to Percona Live London. Before we do that, though, just what in the world does this output from SHOW INNODB STATUS mean?
|
Mutex spin waits 5870888, rounds 19812448, OS waits 375285 |
To understand this text, you have to understand how InnoDB handles mutexes. It tries a […]
Aug 26, 2011 |
Insight for DBAs, MySQL, Percona Events
It’s Friday again, and time for another TGIF give-away of a Percona Live London ticket! But first, what’s new with the MySQL query cache? You may know that it still has the same fundamental architecture that it’s always had, and that this can cause scalability problems and locking, but there have been some important changes […]
Aug 25, 2011 |
Percona Events
Just a quick update on April’s conference planning. We’ve published the speaker committee, and some featured speakers are on the conference’s home page. These include names like Mårten Mickos and Jeremy Zawodny. I got a question from a community member that I thought was very important to answer publicly: what is the role and authority […]