Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
July 28, 2011
How Innodb Contention may manifest itself
Even though multiple fixes have been implemented in Percona Server and MySQL 5.5, there are still workloads in which case [...]
July 27, 2011
What’s required to tune MySQL?
I got a serendipitous call (thanks!) yesterday asking what would be needed to tune[1] a database for better performance. It [...]
April 27, 2011
The four fundamental performance metrics
There are many ways to slice and aggregate metrics of activity on a system such as MySQL. In the best [...]
April 25, 2011
Performance Schema overhead
As continuation of my CPU benchmarks it is interesting to see what is scalability limitation in MySQL 5.6.2, and I [...]
April 25, 2011
MySQL at Facebook, present and future
Harrison Fisk, from the Facebook database team, will be in New York City delivering the closing keynote at Percona Live [...]
April 21, 2011
InnoDB page sizes: plans and ideas
It is well known fact that InnoDB standard page size is 16K or 16384 bytes. Sometime ago we added feature [...]
April 21, 2011
Reality of Innodb Caching
I have mentioned few times Innodb caches data in pages and even if you have working set consisting of relatively [...]
April 20, 2011
Drop table performance
There have been recent discussions about DROP TABLE performance in InnoDB. (You can refer to Peter’s post https://www.percona.com/blog/2011/02/03/performance-problem-with-innodb-and-drop-table/ and these [...]
April 19, 2011
MySQL Connection Timeouts
Sometimes on very busy MySQL server you will see sporadic connection timeouts, such as Can’t connect to MySQL server on [...]
April 18, 2011
How to use tcpdump on “Very” Busy Hosts
Tcpdump Packet Loss on Busy Servers Often I run into problems when trying to use mk-query-digest with tcpdump on “very” [...]
April 17, 2011
Aspersa tools bit.ly download shortcuts
I use Aspersa tools a lot and I find myself going to the website just to download one of the [...]
April 10, 2011
Should we give a MySQL Query Cache a second chance ?
Over last few years I’ve been suggesting more people to disable Query Cache than to enable it. It can cause [...]
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 [...]