Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
October 6, 2011
When Do InnoDB Table Statistics Update?
InnoDB table statistics are used for JOIN optimizations and helping the MySQL optimizer choose the appropriate index for a query. [...]
October 3, 2011
Percona Server 5.5.15 + Galera 21.1-beta2
Codership team published beta2 of MySQL 5.5.15 with Galera replication https://launchpad.net/codership-mysql and we made port to Percona Server: source code: [...]
September 2, 2011
Understand InnoDB spin waits, win a Percona Live ticket
It’s Friday again (so soon!) and time for our TGIF contest, to give away a free ticket to Percona Live [...]
August 27, 2011
Recovering Linux software RAID, RAID5 Array
Dealing with MySQL you might need to deal with RAID recovery every so often. Sometimes because of client lacking the [...]
August 26, 2011
Getting MySQL Core file on Linux
Core file can be quite helpful to troubleshoot MySQL Crashes yet it is not always easy to get, especially with [...]
August 26, 2011
Return of the Query Cache, win a Percona Live ticket
It’s Friday again, and time for another TGIF give-away of a Percona Live London ticket! But first, what’s new with [...]
August 24, 2011
Make your file system error resilient
One of the typical problems I see setting up ext2/3/4 file system is sticking to defaults when it comes to [...]
July 29, 2011
Reasons for MySQL Replication Lag
One common theme in the questions our MySQL Support customers ask is MySQL Replication Lag. The story is typically along [...]
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 [...]