Peter ZaitsevPeter managed the High Performance Group within MySQL until 2006, when he founded Percona. Peter has a Master's Degree in Computer Science and is an expert in database kernels, computer hardware, and application scaling.
MySQL Document Store Developments
This blog will discuss some recent developments with MySQL document store. Starting MySQL 5.7.12, MySQL can be used as a real document store. This is great news! In this blog post, I am going to look into the history-making MySQL work better for “NoSQL” workloads and more of the details on what MySQL document store offers […]
Is Adaptive Hash Index in InnoDB right for my workload?
This blog post will discuss what the Adaptive Hash Index in InnoDB is used for, and whether it is a good fit for your workload. Adaptive Hash Index (AHI) is one of the least understood features in InnoDB. In theory, it magically determines when it is worth supplementing InnoDB B-Tree-based indexes with fast hash lookup […]
TokuDB impacts InnoDB Performance?
This blog discusses how TokuDB impacts InnoDB performance when the two run in the same environment. You would think MySQL storage engines are fairly independent of each other, even in the same environment. Enabling one, or changing its configuration, logically should have no impact on the performance of other engines (such as InnoDB) when they […]
Moving with SQL Server to Linux? Move from SQL Server to MySQL as well!
In this blog, we’ll discuss MicroSoft’s recent announcement that SQL Server will be available on Linux. If you’re going to Linux, why not move from SQL Server to MySQL? The open source operating system Linux powers nearly one-quarter of all the servers running in Microsoft’s Azure cloud service. Until just last week, this meant nearly […]
Finding MySQL Table Size on Disk
So you want to know how much space a given MySQL table takes on disk. Looks trivial, right? Shouldn’t this information be readily available in the INFORMATION_SCHEMA.TABLES? Not so fast! This simple question actually is quite complicated in MySQL. MySQL supports many storage engines (some of which don’t store data on disk at all) and […]
Prometheus as an Engine for MySQL Monitoring
When I first discovered Graphite years ago, I was very impressed with its monitoring capabilities. Compared to many RRD-based tools that were popular at the time (like Cacti), Graphite separated the captured data and graphs, allowing you to do all kinds of math and transformations while visualizing data. For example, I could plot the relationship […]
Gartner, Thank You for Recognizing Percona in the Magic Quadrant for ODBMS!
But mostly thank you to our customers who said more about Percona than we ever could have. There are many milestones in the life of the company, and being included in the Gartner Magic Quadrant is one of very significant ones! I’m very proud we have now reached that milestone and have been recognized as […]
Practical MySQL Performance Optimization (July 2 webinar)
Applications often become impacted by MySQL performance. Optimization is the obvious solution but where to start? Join me on July 2 at 11 a.m. Pacific and I’ll show you how to optimize MySQL in a practical way – spending time on what gives you the best return. Many of you have heard me talk on […]
MongoDB Community Open House: June 1 in NYC
If you can make it to Manhattan next Monday, please join me at the MongoDB Community Open House. The June 1 event is free and open to all. It runs from 3:30-6:30 p.m. just across the road from MongoDB World. The MongoDB Community Open House, held at the New York Hilton Midtown, will feature technical […]
Considering Sharding with MySQL? Join my April 22 webinar. Questions welcome!
MySQL sharding is one of the most used and surely the most abused MySQL scaling technology. My April 2 Dzone article, “To Shard, or Not to Shard,” proved there is indeed quite an interest in this topic. As such, I’m hosting a live webinar tomorrow (April 22) that will shed light on questions about sharding with […]
Why Percona Acquired Tokutek: by Peter Zaitsev
It is my pleasure to announce that Percona has acquired Tokutek and will take over development and support for TokuDB® and TokuMX™ as well as the revolutionary Fractal Tree® indexing technology that enables those products to deliver improved performance, reliability and compression for modern Big Data applications. At Percona we have been working with the […]
Tokutek now part of the Percona family
It is my pleasure to announce that Percona has acquired Tokutek and will take over development and support for TokuDB® and TokuMX™ as well as the revolutionary Fractal Tree® indexing technology that enables those products to deliver improved performance, reliability and compression for modern Big Data applications. At Percona we have been working with the […]
The value of MySQL Support
Years ago when I worked for the MySQL Support organization at the original MySQL AB, we spoke about MySQL Support as insurance and focused on a value proposition similar to that of car insurance. For your car to be fully covered, you must purchase car insurance before the incident happens – in fact most places […]
FoundationDB is acquired by Apple: My thoughts
TechCrunch reported yesterday that Apple has acquired FoundationDB. And while I didn’t see any mention if this news on the FoundationDB website, they do have an announcement saying: “We have made the decision to evolve our company mission and, as of today, we will no longer offer downloads.” This is an unfortunate development – I […]
Steve ‘Woz’ Wozniak to speak at Percona Live MySQL Conference & Expo 2015
I am thrilled to announce that Apple co-founder and Silicon Valley icon and philanthropist Steve Wozniak will participate in a moderated Q&A on creativity and innovation April 14 during this year’s Percona Live MySQL Conference and Expo in Santa Clara, California. In addition to “The Woz,” as Steve is nicknamed, we have a great lineup […]
Introducing ‘MySQL 101,’ a 2-day intensive educational track at Percona Live this April 15-16
Talking with Percona Live attendees last year I heard a couple of common themes. First, people told me that there is a lot of great advanced content at Percona Live but there is not much for people just starting to learn the ropes with MySQL. Second, they would like us to find a way to […]
Percona University: Back to school Feb. 12 in Raleigh, N.C.
About two years ago we held our first-ever Percona University event in Raleigh, N.C. It was a great success with high attendance and very positive feedback which led us to organize a number of similar educational events in different locations around the world. And next month we’ll be back where it all started. On February […]
Looking deeper into InnoDB’s problem with many row versions
A few days ago I wrote about MySQL performance implications of InnoDB isolation modes and I touched briefly upon the bizarre performance regression I found with InnoDB handling a large amount of versions for a single row. Today I wanted to look a bit deeper into the problem, which I also filed as a bug. First […]
MySQL performance implications of InnoDB isolation modes
Over the past few months I’ve written a couple of posts about dangerous debt of InnoDB Transactional History and about the fact MVCC can be the cause of severe MySQL performance issues. In this post I will cover a related topic – InnoDB Transaction Isolation Modes, their relationship with MVCC (multi-version concurrency control) and how […]