Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
April 7, 2011
Optimizing slow web pages with mk-query-digest
I don’t use many tools in my consulting practice but for the ones I do, I try to know them [...]
April 6, 2011
More on MySQL Error Messages
I wrote about MySQL Error Messages before and as you might guess I’m not very happy with quality for error [...]
April 4, 2011
Flexviews – part 3 – improving query performance using materialized views
Combating “data drift” In my first post in this series, I described materialized views (MVs). An MV is essentially a [...]
April 4, 2011
InnoDB Flushing: Theory and Solutions
I mentioned problems with InnoDB flushing in a previous post. Before getting to ideas on a solution, let’s define some [...]
April 1, 2011
Performance or Stability ???
Sometimes the question is put like are you looking for Performance OR Stability, which I believe is a strange way [...]
March 31, 2011
InnoDB Flushing: a lot of memory and slow disk
You may have seen in the last couple of weekly news posts that Baron mentioned we are working on a [...]
March 28, 2011
Maatkit’s mk-query-digest filters
Have you ever seen BIG weird numbers in mk-query-digest report that just seem wrong? I have! Here’s one report I [...]
March 25, 2011
Using Flexviews – part two, change data capture
In my previous post I introduced materialized view concepts. This post begins with an introduction to change data capture technology [...]
March 23, 2011
Using Flexviews – part one, introduction to materialized views
If you know me, then you probably have heard of Flexviews. If not, then it might not be familiar to [...]
March 21, 2011
Virtualization and IO Modes = Extra Complexity
It has taken a years to get a proper integration between operating system kernel, device driver and hardware to get [...]
March 21, 2011
What Causes Downtime in MySQL?
We’ve just published a new white paper analyzing the causes of emergency incidents filed by our customers. The numbers contradict [...]
March 16, 2011
Where does HandlerSocket really save you time?
HandlerSocket has really generated a lot of interest because of the dual promises of ease-of-use and blazing-fast performance. The performance [...]
March 8, 2011
Modeling MySQL Capacity by Measuring Resource Consumptions
There are many angles you can look at the system to predict in performance, the model baron has published for [...]
March 8, 2011
How to debug long-running transactions in MySQL
Among the many things that can cause a “server stall” is a long-running transaction. If a transaction remains open for [...]
March 3, 2011
How Percona diagnoses MySQL server stalls
We receive many requests for help with server stalls. They come under various names: lockup, freeze, sudden slowdown. When something [...]
March 2, 2011
What is innodb_support_xa?
A common misunderstanding about innodb_support_xa is that it enables user-initiated XA transactions, that is, transactions that are prepared and then [...]
February 17, 2011
How to syntax-check your my.cnf file
For a long time, I’ve used a little trick to check whether there are syntax errors in a server’s my.cnf [...]
February 14, 2011
Basic performance and diagnostic tools on Solaris
Much has been written about tools to inspect Linux systems, and much has been written about Solaris’s Big Important Tools [...]
February 10, 2011
Battery Learning still problem many years after
The performance problems caused by battery auto learning go many years back. We wrote about it, other people from MySQL [...]
February 7, 2011
White Paper: “Scaling MySQL Deployments Efficiently” from Percona and Virident
Percona was working closely with Virident on evaluating tachIOn as solution for MySQL, and as result you can find whitepaper [...]