Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
February 26, 2013
InnoDB Full-text Search in MySQL 5.6 (part 1)
I’ve never been a very big fan of MyISAM; I would argue that in most situations, any possible advantages to [...]
February 26, 2013
Why do we care about MySQL Performance at High Concurrency?
In many MySQL Benchmarks we can see performance compared with rather high level of concurrency. In some cases reaching 4,000 [...]
February 25, 2013
Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
There are many reasons for wanting a small MySQL database server: You’re a uni student who wants to learn the [...]
February 25, 2013
Percona Welcomes MySQL 5.6!
MySQL 5.6 was made generally available as a production-ready solution earlier this month. This release comes about 2 years after [...]
February 21, 2013
MySQL 5.5 and MySQL 5.6 default variable values differences
As the part of analyzing surprising MySQL 5.5 vs MySQL 5.6 performance results I’ve been looking at changes to default [...]
February 20, 2013
Mystery Performance Variance with MySQL Restarts
Based on a lot of surprising comments about my MySQL 5.5 vs 5.6 performance post I decided to perform deeper [...]
February 18, 2013
Analyzing Slow Query Table in MySQL 5.6
Next week I’m teaching an online Percona Training class, called Analyzing SQL Queries with Percona Toolkit. This is a guided [...]
February 4, 2013
Can’t Create a New Thread: Errno 11 Fixes
Recently some of my fellow Perconians and I have noticed a bit of an uptick in customer cases featuring the [...]
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, [...]