Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
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 [...]
July 13, 2010
Percona at OSCON 2010
This year we’re participating in OSCON as a Sponsor and organizing some BOFs. I will be on the conference 21 [...]
July 12, 2010
Intro to OLAP
This is the first of a series of posts about business intelligence tools, particularly OLAP (or online analytical processing) tools [...]
July 12, 2010
High availability for MySQL on Amazon EC2 – Part 3 – Configuring the HA resources
This post is the third of a series that started here. From the previous of this series, we now have [...]
July 11, 2010
Query Response time histogram – new feature in Percona Server
Recently we had couple posts dedicated to performance monitoring, i.e. Color code your performance numbers, Performance Optimization and Six Sigma, [...]
July 6, 2010
Making “Insert Ignore” Fast, by Avoiding Disk Seeks
In my post from three weeks ago, I explained why the semantics of normal ad-hoc insertions with a primary key [...]
July 5, 2010
mk-query-digest, query comments and the query cache
I very much like the fact that MySQL allows you to embed comments into SQL statements. These comments are extremely [...]
July 5, 2010
How is join_buffer_size allocated?
When examining MySQL configuration, we quite often want to know how various buffer sizes are used. This matters because some [...]
July 3, 2010
Announcing TokuDB v4.0
Tokutek is pleased to announce immediate availability of TokuDB for MySQL, version 4.0. It is designed for continuous querying and [...]
July 1, 2010
Recover BLOB fields
For a long time long types like BLOB, TEXT were not supported by Percona InnoDB Recovery Tool. The reason consists [...]
June 30, 2010
Making “Replace Into” Fast, by Avoiding Disk Seeks
In this post two weeks ago, I explained why the semantics of normal ad-hoc insertions with a primary key are [...]
June 29, 2010
High availability for MySQL on Amazon EC2 – Part 2 – Setting up the initial instances
This post is the second of a series that started here. The first step to build the HA solution is [...]
June 22, 2010
Making Updates Fast, by Avoiding Disk Seeks
The analysis that shows how to make deletions really fast by using clustering keys and TokuDB’s fractal tree based engine [...]
June 21, 2010
Percona Server 5.1.47-rel11.0
Dear Community, Percona Server version 5.1.47-rel11.0 is available for download now. The changes in this release include: New features Percona [...]
June 18, 2010
Disk seeks are evil, so let’s avoid them, pt. 4
Continuing in the theme from previous posts, I’d like to examine another case where we can eliminate all disk seeks [...]
June 17, 2010
High availability for MySQL on Amazon EC2 – Part 1 – Intro
Like many, I have been seduced by the power and flexibility of Amazon EC2. Being able to launch new instances [...]
June 15, 2010
What does Handler_read_rnd mean?
MySQL’s SHOW STATUS command has two counters that are often confusing and result in “what does that mean?” questions: Handler_read_rnd [...]
June 15, 2010
EXPLAIN EXTENDED shows what MySQL optimizer does to your query
While many people are familiar with the MySQL EXPLAIN command, fewer people are familiar with “explain extended” which was added [...]
June 15, 2010
Virident tachIOn: New player on Flash PCI-E cards market
(Note: The review was done as part of our consulting practice, but is totally independent and fully reflects our opinion) [...]
June 10, 2010
Purge Thread Spiral of Death
I just wrote a large post on reasons for innodb main tablespace excessive growth and I thought it would make [...]