Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
April 25, 2011
Intel Nehalem vs AMD Opteron shootout in sysbench workload
Having two big boxes in our lab, one based Intel Nehalem (Cisco UCS C250) and second on AMD Opteron (Dell [...]
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 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 31, 2011
InnoDB Flushing: a lot of memory and slow disk
You may have seen in the last couple of weekly news posts that Baron mentioned we are working on a [...]
March 28, 2011
MySQL on Amazon RDS part 2: Determining Peak Throughput
This is a continuation of my series of benchmark posts comparing Amazon RDS to a server running on Amazon EC2. [...]
March 21, 2011
Choosing an appropriate benchmark length
The duration of a benchmark is an important factor that helps determine how meaningful it is. Most systems have some [...]
February 28, 2011
Is VoltDB really as scalable as they claim?
Before I begin, a disclaimer. VoltDB is not a customer, and did not pay Percona or me to investigate VoltDB’s [...]
January 13, 2011
Different flavors of InnoDB flushing
In my recent benchmarks, such as this one about the Virident TachIon card, I used different values for innodb_buffer_pool_size, like [...]
January 7, 2011
High Rate insertion with MySQL and Innodb
I again work with the system which needs high insertion rate for data which generally fits in memory. Last time [...]
January 3, 2011
Effect from innodb log block size 4096 bytes
In my post MySQL 5.5.8 and Percona Server: being adaptive I mentioned that I used innodb-log-block-size=4096 in Percona Server to [...]
January 3, 2011
MySQL 5.5.8 – in search of stability
A couple of days ago, Dimitri published a blog post, Analyzing Percona’s TPCC-like Workload on MySQL 5.5, which was a [...]
December 21, 2010
MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)
This is to follow up on my previous post and show the results for MySQL 5.5.8 and Percona Server on [...]
December 20, 2010
MySQL 5.5.8 and Percona Server: being adaptive
As we can see, MySQL 5.5.8 comes with great improvements and scalability fixes. Adding up all the new features, you have a [...]
December 13, 2010
Write performance on Virident tachIOn card
This is crosspost from https://www.percona.com/blog/. Disclaimer: The benchmarks were done as part of our consulting practice, but this post is [...]
November 19, 2010
Is there benefit from having more memory ?
My post back in April, https://www.percona.com/blog/2010/04/08/fast-ssd-or-more-memory/, caused quite interest, especially on topic SSD vs Memory. That time I used fairy [...]
November 2, 2010
HandlerSocket on SSD
We all enjoyed Yoshinori announcement of HandlerSocket, the plugin to MySQL which open NOSQL way to access data stored in [...]
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
Impact of the sort buffer size in MySQL
The parameter sort_buffer_size is one the MySQL parameters that is far from obvious to adjust. It is a per session [...]
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 29, 2010
Percona Server scalability on multi-cores server
We now have hardware in our test lab that represents the next generation of commodity servers for databases. It’s a Cisco [...]