Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
August 27, 2010
Loading Air Traffic Control Data with TokuDB 4.1.1
TokuDB has a big advantage over B-trees when trickle loading data into existing tables. However, it is possible to preprocess [...]
August 23, 2010
InnoDB memory allocation, ulimit, and OpenSUSE
I recently encountered an interesting case. A customer reported that mysqld crashed on start on OpenSUSE 11.2 kernel 2.6.31.12-0.2-desktop x86_64 [...]
August 19, 2010
Announcing TokuDB v4.1.1
Tokutek is pleased to announce immediate availability of TokuDB for MySQL, version 4.1.1. It is ideally suited for delivering fast [...]
August 19, 2010
High availability for MySQL on Amazon EC2 – Part 4 – The instance restart script
This post is the fourth of a series that started here. From the previous of this series, we now have [...]
August 19, 2010
Percona talks at OpenSQL Camp this weekend
Four Perconians (perconites?) will be at OpenSQL Camp in Sankt Augustin, Germany this weekend presenting talks on: Recovery of Lost [...]
August 18, 2010
Announcing Training for Operations Teams
We’re opening up registration for our new training courses today. In short: we are moving from two days to a [...]
August 16, 2010
Testing MySQL column stores
Recently I had the opportunity to do some testing on a large data set against two MySQL column-store storage engines. [...]
August 15, 2010
Announcing TokuDB v4.1
Tokutek is pleased to announce immediate availability of TokuDB for MySQL, version 4.1. It is designed for continuous querying and [...]
August 11, 2010
On “Replace Into”, “Insert Ignore”, Triggers, and Row Based Replication
In posts on June 30 and July 6, I explained how implementing the commands “replace into” and “insert ignore” with [...]
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 [...]
August 3, 2010
TokuDB speeds up “replace” and “insert ignore” operations by relaxing the affected rows constraint
In posts on June 30 and July 6, we explained how implementing the commands “replace into” and “insert ignore” with [...]
July 31, 2010
Why you can’t rely on a replica for disaster recovery
A couple of weeks ago one of my colleagues and I worked on a data corruption case that reminded me [...]
July 30, 2010
Storing MySQL Binary logs on NFS Volume
There is a lot of discussions whenever running MySQL storing data on NFS is a good idea. There is a [...]
July 26, 2010
MariaDB and the MySQL Sandbox
Tokutek tests its TokuDB Fractal Tree storage engine with multiple MySQL distributions. We make extensive use of the MySQL Sandbox [...]
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 21, 2010
On “Replace Into”, “Insert Ignore”, and Secondary Keys
In posts on June 30 and July 6, I explained how implementing the commands “replace into” and “insert ignore” with [...]
July 20, 2010
Estimating Replication Capacity
It is easy for MySQL replication to become bottleneck when Master server is not seriously loaded and the more cores [...]
July 16, 2010
Analyzing the distribution of InnoDB log file writes
I recently did a quick analysis of the distribution of writes to InnoDB’s log files. On a high-traffic commodity MySQL [...]
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 14, 2010
Why “insert … on duplicate key update” May Be Slow, by Incurring Disk Seeks
In my post on June 18th, I explained why the semantics of normal ad-hoc insertions with a primary key are [...]