Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
February 1, 2013
Implications of Metadata Locking Changes in MySQL 5.5
While most of the talk recently has mostly been around the new changes in MySQL 5.6 (and that is understandable), [...]
January 28, 2013
How Can Percona MySQL Server Development Services Help ?
At Percona we offer a number of services. One of them, Custom MySQL Server Development, is commonly the most misunderstood [...]
January 27, 2013
MySQL 5.6: Improvements in the Nutshell
Preparing for my talk for Percona MySQL University in Raleigh,NC, Tuesday 29th of January I have created the outline of [...]
January 21, 2013
Fun with the MySQL pager command
Last time I wrote about a few tips that can make you more efficient when using the command line on [...]
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 – [...]