Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
January 9, 2013
Profiling MySQL Memory Usage With Valgrind Massif
There are times where you need to know exactly how much memory the mysqld server (or any other program) is [...]
January 9, 2013
How does MySQL Replication work?
While we do have many blog posts on replication on our blog, such as on replication being single-threaded, on semi-synchronous [...]
January 3, 2013
Is there room for more MySQL IO Optimization?
I prefer to run MySQL with innodb_flush_method=O_DIRECT in most cases – it makes sure there is no overhead of double [...]
January 3, 2013
Percona Toolkit by example – pt-stalk
pt-stalk recipes: Gather forensic data about MySQL when a server problem occurs It happens to us all from time to [...]
December 31, 2012
MySQL Wish for 2013 – Better Memory Accounting
With Performance Schema improvements in MySQL 5.6 I think we’re in the good shape with insight on what is causing [...]
December 21, 2012
Be productive with the MySQL command line
Even if you are using a GUI tool to connect to your MySQL servers, one day or another, you will [...]
December 20, 2012
How to STOP SLAVE on Amazon RDS read replica
We are doing a migration from Amazon RDS to EC2 with a customer. This, unfortunately, involves some downtime – if [...]
December 19, 2012
Percona Toolkit Webinar followup Q&A
First, a thank you to everyone who attended the webinar Today, I appreciate your time and nice comments. As promised, [...]
December 14, 2012
The Optimization That (Often) Isn’t: Index Merge Intersection
Prior to version 5.0, MySQL could only use one index per table in a given query without any exceptions; folks [...]
December 5, 2012
Quickly finding unused indexes (and estimating their size)
I had a customer recently who needed to reduce their database size on disk quickly without a lot of messy [...]
November 28, 2012
Replication of the NOW() function (also, time travel)
Notice the result of the NOW() function in the following query. The query was run on a real database server [...]
November 23, 2012
Full Table Scan vs Full Index Scan Performance
Earlier this week, Cédric blogged about how easy we can get confused between a covering index and a full index [...]
November 22, 2012
Get Me Some Query Logs!
One of my favorite tools in the Percona Toolkit is pt-query-digest. This tool is indispensable for identifying your top SQL queries, [...]
November 16, 2012
Question of the week: Maximum number of tables per MySQL instance.
I’ve got the great response to my two previous polls (1,2) so lets continue learning about how we all use [...]
November 9, 2012
What is the largest amount of data do you store in MySQL ?
My previous poll got a great response so I thought I should continue these series. The question of the day [...]
November 2, 2012
How Much memory do you use to run MySQL
We have seen number of issues with MySQL Server related to amount of memory you have in the system – [...]
November 1, 2012
Knowing what pt-online-schema-change will do
pt-online-schema-change is simple to use, but internally it is complex. Baron’s webinar about pt-online-schema-change hinted at several of the tool’s complexities. [...]
October 29, 2012
MySQL and predictive option handling – beware
MySQL command line utilities have an interesting property – if you only use the prefix of the option or command [...]
October 27, 2012
Edge-case behavior of INSERT…ODKU
A few weeks back, I was working on a customer issue wherein they were observing database performance that dropped through [...]
October 25, 2012
Replaying database load with Percona Playback
If you are planning to upgrade or make any configuration change on your MySQL database the first advice usually is: [...]