Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
June 3, 2015
Optimizing Percona XtraDB Cluster for write hotspots
Some applications have a heavy write workload on a few records – for instance when incrementing a global counter: this [...]
June 2, 2015
innodb_buffer_pool_size – Is 80% of RAM the right amount?
It seems these days if anyone knows anything about tuning InnoDB, it’s that you MUST tune your innodb_buffer_pool_size to 80% [...]
June 1, 2015
New PERFORMANCE_SCHEMA defaults in MySQL 5.7.7
I thought it was worth a moment to reiterate on the new Performance Schema related defaults that MySQL 5.7.7 brings [...]
May 15, 2015
MySQL QA Episode 2: Build a MySQL server – Git, Bazaar, Compiling & Build tools
Welcome to MySQL QA Episode 2: Build a MySQL Server – Git, Bazaar (bzr), Compiling, and Build Tools In this [...]
May 8, 2015
MySQL indexing 101: a challenging single-table query
We discussed in an earlier post how to design indexes for many types of queries using a single table. Here [...]
May 4, 2015
Keep your MySQL data in sync when using Tungsten Replicator
MySQL replication isn’t perfect and sometimes our data gets out of sync, either by a failure in replication or human [...]
April 30, 2015
Optimizer hints in MySQL 5.7.7 – The missed manual
In version MySQL 5.7.7 Oracle presented a new promising feature: optimizer hints. However it did not publish any documentation about [...]
April 28, 2015
Test your knowledge: Percona XtraDB Cluster (PXC) quiz
I often talk with people who are very interested in the features of Percona XtraDB Cluster (PXC) such as synchronous [...]
April 27, 2015
Indexing 101: Optimizing MySQL queries on a single table
I have recently seen several cases when performance for MySQL queries on a single table was terrible. The reason was [...]
April 21, 2015
Considering Sharding with MySQL? Join my April 22 webinar. Questions welcome!
MySQL sharding is one of the most used and surely the most abused MySQL scaling technology. My April 2 Dzone article, [...]
April 13, 2015
Staying ahead of MySQL operational problems at Percona Live
I’ve started my long journey from Florianópolis, Brazil, to Santa Clara, California and I type this words while waiting for [...]
April 9, 2015
pquery binaries with statically included client libs now available!
After we released pquery to the community, and as we started logging bug reports with pquery testcases, it quickly became clear [...]
April 8, 2015
More on OpenStack Live and our talks at OpenStack Summit Vancouver
In April and May, Percona will hold and participate in two OpenStack events: OpenStack Summit. Join our talks at these [...]
April 7, 2015
More on (transactional) MySQL metadata locks
Two years ago Ovais Tariq had explained in detail what kinds of problems existed before MySQL introduced metadata locks in [...]
March 18, 2015
Getting started guide for OpenStack contributors
So you want to contribute to OpenStack? I can help! For the last year or so I have been involved [...]
March 17, 2015
MySQL QA Episode 1: Bash/GNU Tools & Linux Upskill & Scripting Fun
MySQL QA Episode #1: Bash/GNU Tools & Linux Upskill & Scripting Fun This episode consists of 13 parts, and an [...]
March 17, 2015
Free MySQL QA & Bash/Linux Training Series
Welcome to the MySQL QA Training Series! If you have not read our introductory blog post on pquery yet, I’d [...]
March 13, 2015
Q&A: Multi-threaded Replication in MySQL 5.6 and MySQL 5.7
My webinar “Multi-threaded Replication in MySQL 5.6 and 5.7” on February 25 generated several excellent questions following the presentation (available an [...]
March 3, 2015
Introducing ‘MySQL 101,’ a 2-day intensive educational track at Percona Live this April 15-16
Talking with Percona Live attendees last year I heard a couple of common themes. First, people told me that there [...]
March 2, 2015
Emulating MySQL roles with the Percona PAM plugin and proxy users
From time to time people wonder how to implement roles in MySQL. This can be useful for companies having to [...]