Aug 09, 2011 |
MySQL, Percona Events
We’re thrilled to announce that we have signed a contract with the Hyatt Regency Santa Clara and the Santa Clara Convention Center, to host a Percona Live MySQL Conference and Expo on April 10-12, 2012. This event is part of our Percona Live series of conferences, but it’s not just another event in the series. […]
Aug 08, 2011 |
MySQL, Percona Events
The first two Percona Live MySQL conferences in San Francisco and New York were sold-to-capacity events with the bonus of great evening parties. Percona Live’s huge popularity convinced us to take the conference series on the road to London, England. We also decided to broaden learning, content, networking, presentation and marketing opportunities for attendees and […]
Aug 04, 2011 |
Benchmarks, Cloud, MySQL
A while ago I started a series of posts showing benchmark results on Amazon EC2 servers with RAID’ed EBS volumes and MySQL, versus RDS machines. For reasons that won’t add anything to this discussion, I got sidetracked, and then time passed, and I no longer think it’s a good idea to publish those blog posts […]
Aug 01, 2011 |
MySQL, Percona Events
It’s August 1st, 2011, and five years ago on or about this date (who can remember clearly?) Peter Zaitsev and Vadim Tkachenko founded Percona. What’s happened in the last five years?
Jul 27, 2011 |
Insight for DBAs, MySQL
I got a serendipitous call (thanks!) yesterday asking what would be needed to tune[1] a database for better performance. It is a question that I hear often, but I never thought about answering it in public. Here’s a consolidated version of what I explained during our conversation.
Jul 11, 2011 |
MySQL
A while back, I wrote a two part post on how you can extract an amazing amount of information about a system’s performance, scalability, queueing, and more by just measuring request arrivals and completions, and the timestamps thereof. I promised to develop this into a more complete description of how to analyze MySQL’s performance and […]
Jul 09, 2011 |
MySQL
If you need to change MySQL’s innodb_log_file_size parameter (see How to calculate a good InnoDB log file size), you can’t just change the parameter in the my.cnf file and restart the server. If you do, InnoDB will refuse to start because the existing log files don’t match the configured size. Changing the innodb_log_file_size safely You […]
May 31, 2011 |
MySQL
At Percona Live last week, someone showed me a graph from their Cacti monitoring system, using the templates that I wrote. It was the buffer pool pages read, written, and created. He asked me if the graph was okay. Shouldn’t there be a lot more pages read than written, he asked? It’s a great question. […]
May 25, 2011 |
MySQL
We’re seeing a spike of last-minute ticket sales for Percona Live New York. Meanwhile, we’re assembling bags and unpacking t-shirts at the venue. If you want to come, buy your ticket now — we’re rapidly selling out the remaining tickets! Remember, if all the tickets are sold, you can still come to the evening event […]
May 23, 2011 |
MySQL
Just a couple of announcements for Percona Live: we’re giving away free tickets through Engine Yard, and we’ve arranged our evening open-bar event. For a chance to win a free ticket, check out the guest blog post I wrote for Engine Yard on how to make Rails migrations faster and safer. In other news, Percona […]
May 16, 2011 |
MySQL
For a long time I’ve wanted to know how MySQL scales as you add more memory to the server. Vadim recently benchmarked the effects of increasing memory and CPU core count. He looked for a balance between utilizing the hardware as much as possible, limiting the system complexity, and lowering the price-to-performance ratio. The outcome […]
May 15, 2011 |
MySQL
I have one free ticket to give away to RailsConf next week in Baltimore! Post a comment to win, and if you aren’t the winner, I’ll give you a discount code for Percona Live as a consolation prize. Here’s the catch: you have to find at least one thing wrong with the following typical logrotate […]
May 10, 2011 |
MySQL
We have mostly finalized the Percona Live schedule at this point, and I thought I’d take a few minutes to introduce who’s going to be speaking and what they’ll cover. A brief explanation first: we’ve personally recruited the speakers, which is why it has been a slow process to finalize and get abstracts on the […]
May 08, 2011 |
MySQL
Percona is sponsoring RailsConf again this year, and we’ll be at booth #110 in the expo hall. Use our discount code to save 20% off the ticket price: rc11mysql. We hope to see you there! (Sadly, we didn’t get any sessions accepted this year, so we won’t be speaking. Maybe next year.)
May 06, 2011 |
MySQL
We’ve given discount coupon codes to all of our Percona Live sponsors, so watch the Twitter tag #perconalive to find discount announcements. Here’s the list of sponsoring organizations: Clustrix Vork Continuent Fusion-io Infobright Pentaho Schooner Information Technology SkySQL Virident Webyog Akiban Couchbase EffectiveMySQL Facebook New Relic OmniTI Sphinx Tokutek We Build Pages Zmanda DaniWeb New […]
May 05, 2011 |
MySQL
In a recent blog post, I wrote about four fundamental metrics for system performance analysis. These are throughput, residence time, “weighted time” (the sum of all residence times in the observation period — the terminology is mine for lack of a better name), and concurrency. I derived all of these metrics from two “even more […]
May 03, 2011 |
MySQL
We’ve just rented more rooms, and published an additional two tracks of speakers for Percona Live in New York on May 26th. The schedule is here. There is a long queue of speaker submissions we’re finalizing and will be adding to the schedule, to fill the few empty slots in those new rooms. My favorite […]
Apr 27, 2011 |
Insight for DBAs, MySQL
There are many ways to slice and aggregate metrics of activity on a system such as MySQL. In the best case, we want to know everything about the system’s activity: we want to know how many things happened, how big they were, and how long they took. We want to know precisely when they happened. […]
Apr 25, 2011 |
Insight for DBAs, Insight for Developers, MySQL, Percona Events
Harrison Fisk, from the Facebook database team, will be in New York City delivering the closing keynote at Percona Live next month. He’ll be talking about the present status and future plans for MySQL inside Facebook’s environment. As you probably know, Facebook is one of the largest users of MySQL, with their own set of […]
Apr 25, 2011 |
MySQL, Percona Software
Time for our weekly review of the news! The big news this week is that Percona XtraBackup is ready to try out on Windows. Otherwise, there’s just more steady progress. One quick note, sort of a “to whom it may concern,” is that the proper trademarked names of our products include “Percona Server”, “Percona XtraDB”, […]