Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
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 [...]
February 7, 2011
White Paper: Preventing MySQL Emergencies
About a year ago, I started a study of emergency incidents that our customers filed with us. What I found [...]
February 4, 2011
Fixing MySQL with a comment in the config file
A customer called with an emergency issue: A server that normally runs many MySQL instances wouldn’t start them up. Not [...]
February 3, 2011
Performance problem with Innodb and DROP TABLE
I’ve been working with an application which does a lot of CREATE and DROP table for Innodb tables and we’ve [...]
February 3, 2011
How InnoDB handles REDO logging
Xaprb (Baron) recently blogged about how InnoDB performs a checkpoint , I thought it might be useful to explain another [...]
January 31, 2011
What is exec_time in binary logs?
If you’ve used MySQL’s mysqlbinlog tool, you’ve probably seen something like the following in the output: “exec_time=0” What is the [...]
January 12, 2011
Innodb undo segment size and transaction isolation
You might know if you have long running transactions you’re risking having a lot of “garbage” accumulated in undo segment [...]
January 12, 2011
Conflict Avoidance with auto_increment_increment and auto_increment_offset
A lot of people are running MySQL Master-Master replication pairs in Active-Passive mode for purpose of high availabilities using MMM [...]
January 8, 2011
Ultimate MySQL variable and status reference list
I am constantly referring to the amazing MySQL manual, especially the option and variable reference table. But just as frequently, [...]