Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
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 [...]
October 23, 2010
MySQL Limitations Part 2: The Binary Log
This is the second in a series on what’s seriously limiting MySQL in certain circumstances (links: part 1). In the [...]
October 20, 2010
MySQL Limitations Part 1: Single-Threaded Replication
I recently mentioned a few of the big “non-starter” limitations Postgres has overcome for specific use cases. I decided to [...]
October 4, 2010
Sharing an auto_increment value across multiple MySQL tables
The title is SEO bait – you can’t do it. We’ve seen a few recurring patterns trying to achieve similar [...]
September 23, 2010
More on dangers of the caches
I wrote couple of weeks ago on dangers of bad cache design. Today I’ve been troubleshooting the production down case [...]
September 10, 2010
Cache Miss Storm
I worked on the problem recently which showed itself as rather low MySQL load (probably 5% CPU usage and close [...]
August 10, 2010
Why message queues and offline processing are so important
If you read Percona’s whitepaper on Goal-Driven Performance Optimization, you will notice that we define performance using the combination of [...]
July 24, 2010
Caching could be the last thing you want to do
I recently had a run-in with a very popular PHP ecommerce package which makes me want to voice a recurring [...]
July 15, 2010
Data mart or data warehouse?
This is part two in my six part series on business intelligence, with a focus on OLAP analysis. Part 1 [...]
July 13, 2010
Scaling: Consider both Size and Load
So lets imagine you have the server handling 100.000 user accounts. You can see the CPU,IO and Network usage is [...]