Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
July 9, 2015
How to obtain the MySQL version from an FRM file
I recently helped a customer figure out why a minor version MySQL upgrade was indicating that some tables needed to [...]
July 8, 2015
MySQL QA Episode 4: QA Framework Setup Time!
Welcome to MySQL QA Episode 4! In this episode we’ll look into setting up our QA Framework: percona-qa, pquery, reducer & [...]
July 7, 2015
MySQL QA Episode 3: How to use the debugging tool GDB
Welcome to MySQL QA Episode 3: “Debugging: GDB, Backtraces, Frames and Library Dependencies” In this episode you’ll learn how to [...]
June 30, 2015
Playing with Percona XtraDB Cluster in Docker
Like any good, thus lazy, engineer I don’t like to start things manually. Creating directories, configuration files, specify paths, ports [...]
June 18, 2015
Getting EXPLAIN information from already running queries in MySQL 5.7
When a new version of MySQL is about to be released we read a lot of blog posts about the [...]
June 8, 2015
MaxScale: A new tool to solve your MySQL scalability problems
Ever since MySQL replication has existed, people have dreamed of a good solution to automatically split read from write operations, [...]
June 4, 2015
High availability using MySQL in the cloud
Next Wednesday (June 10) I’ll be co-presenting a webinar on using MySQL in the cloud for High Availability (HA). Joining [...]
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 [...]