by Baron Schwartz | Aug 4, 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...
by Baron Schwartz | Aug 1, 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? We’re a privately held, privately funded company of over 50...
by Vadim Tkachenko | Jul 29, 2011 | Benchmarks, Hardware and Storage
(this is cross-post from https://www.percona.com/blog/) While PCI-e Flash cards show great performance, I am often asked about alternatives, as price for PCI-e cards is still significant and not acceptable for small companies and startups. Intel 320 SSD appears to be...
by Tokutek | Jul 29, 2011 | MySQL
When I interviewed at Tokutek, I met a team of distinguished academics and engineers who could calmly and thoughtfully wax eloquent about the finer points of B-tree and Fractal Tree™ indexing, drive I/Os, and database engines. Soon after, I discovered that...
by Peter Zaitsev | Jul 29, 2011 | Insight for DBAs, MySQL
One common theme in the questions our MySQL Support customers ask is MySQL Replication Lag. The story is typically along the lines everything is same as before and for some unknown reason the slave is started to lag and not catching up any more. I always smile at...
by Vadim Tkachenko | Jul 28, 2011 | MySQL, Percona Events, Percona Software
Codership team announced availability of MySQL/Galera 0.8.1, which is minor release, but actually it has bunch of improvements that makes Galera replication more user friendly (there are many bugs fixed, reported by me personally, what annoyed me a lot). As part of my...
by Peter Zaitsev | Jul 28, 2011 | Insight for DBAs, MySQL
Even though multiple fixes have been implemented in Percona Server and MySQL 5.5, there are still workloads in which case mutex (or rw-lock) contention is a performance limiting factor, helped by ever growing number of cores available in the systems. It is interesting...
by Baron Schwartz | 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...
by Tokutek | Jul 25, 2011 | MySQL
We were happy to see a lot of folks from Japan on Twitter this weekend having a discussion about MySQL and Tokutek. While we always endeavor to explain ourselves as simply as possible, hearing what users and peers have to say and ask in their native language is very...
by Stewart Smith | Jul 25, 2011 | MySQL, Percona Software
Percona is glad to announce the release of Percona XtraBackup 1.6.2 on 25 July, 2011 (Downloads are available here and from thePercona Software Repositories). This release is purely composed of bug fixes and is the current stable release of Percona Xtrabackup.All of...
by Kortney Runyan | Jul 20, 2011 | MySQL, Percona Events
The first Percona Live Conferences in San Francisco and New York were such wonderful successes that we have been inspired to take it across the ocean into the UK. We are therefore proud to announce that our next Percona Live Conference will be held London October...
by Tokutek | Jul 18, 2011 | MySQL
Unless you are Ashton Kutcher (@aplusk), or one of his Hollywood buddies, you don’t need to read any further. Allow me to explain… Over the weekend, we launched our new website. This type of announcement used to be interesting in the high-tech world. I heard Kara...
by Zardosht.Kasheff | Jul 15, 2011 | MySQL
Thanks again to Erin O’Neill and Mike Tougeron for having me at the SF MySQL Meetup last month for the talk on “Understanding Indexing.” The crowd was very interactive, and I appreciated that over 100 people signed up for the event and left some very positive comments...
by Vadim Tkachenko | Jul 14, 2011 | MySQL
As you may know I closely follow Galera replication development, and right now I am evaluating how it performs in our benchmarks. Of course my closest interest is Percona Server, so I made port of Galera from MySQL/InnoDB-plugin to Percona Server 5.1.57. Right now it...
by Tokutek | Jul 13, 2011 | MySQL
I’ve been experimenting with TokuDB recently, and I’m fairly impressed with what I see. It’s nippy even with some ‘ugly’ queries.
by Tokutek | Jul 13, 2011 | MySQL
Now that I’ve used it on production systems, I can say that HCAD in TokuDB is freakin’ awesome. Who needs maintenance windows anyway?
by Vadim Tkachenko | Jul 13, 2011 | MySQL
As you may know, Kristian Nielsen made a fix for the Group Commit Problem which we many times wrote about. The fix came into MariaDB 5.3 and Mark Callaghan tested it recently . We ported this patch to Percona Server (it is not in the main branch yet), and here are the...
by Baron Schwartz | 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...
by Baron Schwartz | Jul 9, 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...
by Michael.Bender | Jul 7, 2011 | MySQL
Last week I gave a talk entitled “Don’t Thrash: How to Cache your Hash.” The talk took place at the Workshop on Algorithms and Data Structures (ADS) in a medieval castle turned conference center in Bertinoro, Italy. An earlier version of this work (with the same...
