Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
March 4, 2010
How many fsync / sec FusionIO can handle
I recently was asked how many fsync / sec ( and therefore durable transactions / sec) we can get on [...]
February 28, 2010
Maximal write througput in MySQL
I recently was asked what maximal amount transactions per second we can get using MySQL and XtraDB / InnoDB storage [...]
February 11, 2010
READ-COMMITED vs REPETABLE-READ in tpcc-like load
Question what is better isolation level is poping up again and again. Recently it was discussed in InnoDB : Any [...]
February 8, 2010
Introducing tpce-like workload for MySQL
We have been using tpcc-mysql benchmark for long time, and there many results published in our blog, but that’s just [...]
January 28, 2010
New OLAP Wikistat benchmark: Introduction and call for feedbacks
I’ve seen my posts on Ontime Air traffic and Star Schema Benchmark got a lot of interest (links: https://www.percona.com/blog/2010/01/07/star-schema-bechmark-infobright-infinidb-and-luciddb/ https://www.percona.com/blog/2009/10/02/analyzing-air-traffic-performance-with-infobright-and-monetdb/ [...]
January 18, 2010
Fast storage: 8 SSD Intel X-25M 80GB benchmarks
I appreciate opportunity Jos van Dongen from Tholis Consulting gave me. He granted me access to servers with 8 attached [...]
January 13, 2010
InnoDB, InnoDB-plugin vs XtraDB on fast storage
To continue fun with FusionIO cards, I wanted to check how MySQL / InnoDB performs here. For benchmark I took [...]
January 11, 2010
FusionIO 320GB MLC benchmarks
After my previous benchmarks of FusionIO 160GB SLC card, FusionIO team sent me for the tests another card, FusionIO 320GB [...]
January 7, 2010
Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
In my previous rounds with DataWarehouse oriented engines I used single table without joins, and with small (as for DW) [...]
December 10, 2009
Redis Benchmarks on FusionIO (Round 1)
Peter took a look at Redis some time ago; and now, with the impending 1.2 release and a slew of [...]
December 8, 2009
FusionIO – time for benchmarks
I posted about FusionIO couple times RAID vs SSD vs FusionIO and Testing FusionIO: strict_sync is too strict…. The problem [...]
December 5, 2009
How many partitions can you have ?
I had an interesting case recently. The customer dealing with large MySQL data warehouse had the table which was had [...]
December 4, 2009
Effect of adaptive_flushing
I recently had the chance to witness the effects of innodb_adaptive_flushing on the performance of InnoDB Plugin 1.0.5 in the [...]
November 26, 2009
More on table_cache
In my previous post I looked into how large table_cache actually can decrease performance. The “miss” path is getting more [...]
November 16, 2009
table_cache negative scalability
Couple of months ago there was a post by FreshBooks on getting great performance improvements by lowering table_cache variable. So [...]
November 12, 2009
Tokyo Tyrant -The Extras Part III : Write Bottleneck
This is part 3 of my Tyrant extra’s, part 1 focused on durability, part 2 focused on the perceived performance [...]
November 11, 2009
Tokyo Tyrant – The Extras Part II : The Performance Wall
Continuing my look at Tokyo Tyrant/Cabinet and addressing some of the concerns I have seen people have brought up this [...]
November 10, 2009
Tokyo Tyrant – The Extras Part I : Is it Durable?
You know how in addition to the main movie you have extras on the DVD. Extra commentary, bloopers, extra scenes, [...]
November 5, 2009
Air traffic queries in MyISAM and Tokutek (TokuDB)
This is next post in series Analyzing air traffic performance with InfoBright and MonetDB Air traffic queries in LucidDB Air [...]
November 2, 2009
Air traffic queries in InfiniDB: early alpha
As Calpont announced availability of InfiniDB I surely couldn’t miss a chance to compare it with previously tested databases in [...]