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. [...]
September 14, 2011
SELECT UNION Results INTO OUTFILE
Here’s a quick tip I know some of us has overlooked at some point. When doing SELECT … UNION SELECT, [...]
August 30, 2011
Explaining Indexes with a Library Metaphor
My favorite metaphor for explaining indexes is comparing them to index cards in an old library. In an old library, [...]
August 8, 2011
Preprocessing Data
There are many ways of improving response times for users. There are some people that spend a lot of time, [...]
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 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 7, 2011
Innodb row size limitation
I recently worked on a customer case where at seemingly random times, inserts would fail with Innodb error 139. This [...]
April 4, 2011
MySQL caching methods and tips
“The least expensive query is the query you never run.” Data access is expensive for your application. It often requires [...]
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 [...]
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 [...]
March 23, 2011
Using Flexviews – part one, introduction to materialized views
If you know me, then you probably have heard of Flexviews. If not, then it might not be familiar to [...]
February 14, 2011
Moving Subtrees in Closure Table Hierarchies
Many software developers find they need to store hierarchical data, such as threaded comments, personnel org charts, or nested bill-of-materials. [...]
February 2, 2011
Logging MySQL queries from the client instead of the server
The “slow query log” is the single most valuable way to examine query execution on your MySQL server. Queries are [...]
February 1, 2011
Sample Datasets for Benchmarking and Testing
Sometimes you just need some data to test and stress things. But randomly generated data is awful — it doesn’t [...]
January 11, 2011
When does Innodb Start Transaction ?
When does Innodb Start Transaction ? The answer looks obvious – when you issue “BEGIN” command. This is however wrong [...]
January 10, 2011
How to Identify Bad Queries in MySQL
Finding bad queries is a big part of optimization. A scientific optimization process can be simplified to “can anything be [...]
November 15, 2010
Shard-Query adds parallelism to queries
Preamble: On performance, workload and scalability: MySQL has always been focused on OLTP workloads. In fact, both Percona Server and [...]
October 27, 2010
MySQL Limitations Part 4: One Thread per Connection
This is the third in a series on what’s seriously limiting MySQL in core use cases (links: part 1, 2, [...]
October 26, 2010
Sharing an auto_increment value across multiple MySQL tables (revisited)
A couple of weeks ago I blogged about Sharing an auto_increment value across multiple MySQL tables. In the comments, a [...]
October 25, 2010
MySQL Limitations Part 3: Subqueries
This is the third in a series on what’s seriously limiting MySQL in certain circumstances (links: part 1, 2). This [...]