May 18, 2013

How many fsync / sec FusionIO can handle

March 4, 2010 By 13 Comments

I recently was asked how many fsync / sec ( and therefore durable transactions / sec) we can get on FusionIO card. It should be easy to test, let’s take sysbench fileio benchmark and run, the next command should make it:

So that’s 9229.35 req/sec, which is pretty impressive. For comparison the same [...]

Filed Under: Benchmarks, MySQL

Maximal write througput in MySQL

February 28, 2010 By 10 Comments

I recently was asked what maximal amount transactions per second we can get using MySQL and XtraDB / InnoDB storage engine if we have high-end server. Good questions, though not easy to answer, as it depends on: – durability setting ( innodb_flush_log_at_trx_commit = 0 or 1 ) ? – do we use binary logs ( [...]

Filed Under: Benchmarks, MySQL Tagged With: ,

READ-COMMITED vs REPETABLE-READ in tpcc-like load

February 11, 2010 By 6 Comments

Question what is better isolation level is poping up again and again. Recently it was discussed in InnoDB : Any real performance improvement when using READ COMMITED isolation level ? and in Repeatable read versus read committed for InnoDB . Serge in his post explains why READ COMMITED is better for TPCC load, so why [...]

Filed Under: Benchmarks, MySQL Tagged With:

Introducing percona-patches for 5.1

February 9, 2010 By 21 Comments

Our patches for 5.0 have attracted significant interest.  You can read about SecondLife’s experience here, as well as what Flickr had to say on their blog.  The main improvements come in both performance gains and improvements to diagnostics (such as the improvements to the slow log output, and INDEX_STATISTICS). Despite having many requests to port [...]

Filed Under: MySQL, Percona Software Tagged With: ,

Introducing tpce-like workload for MySQL

February 8, 2010 By 6 Comments

We have been using tpcc-mysql benchmark for long time, and there many results published in our blog, but that’s just single workload. That’s why we are looking into different benchmarks, and one of them is TPCE. Yasufumi made some efforts to make TPCE working with MySQL, and we are making it available for public consideration. [...]

Filed Under: Benchmarks, MySQL Tagged With:

XtraDB feature: save / restore buffer pool

January 20, 2010 By 20 Comments

We recently released XtraDB-9, and while we did not highlight it in announcement, the release-making feature is ability to save and restore InnoDB buffer pool. The idea is not new and was originally developed by Jeremy Cole (sorry, I do not have the link on hands) some time ago, and now we implemented it in [...]

Filed Under: MySQL, Percona Software Tagged With:

InnoDB, InnoDB-plugin vs XtraDB on fast storage

January 13, 2010 By 13 Comments

To continue fun with FusionIO cards, I wanted to check how MySQL / InnoDB performs here. For benchmark I took MySQL 5.1.42 with built-in InnoDB, InnoDB-plugin 1.0.6, and XtraDB 1.0.6-9 ( InnoDB with Percona patches). As benchmark engine I used tpcc-mysql with 1000 warehouses ( which gives around 90GB of data + indexes) on my [...]

Filed Under: Benchmarks, MySQL Tagged With: ,

Paul McCullagh answers your questions about PBXT

November 20, 2009 By 2 Comments

Following on from our earlier announcement, Paul McCullagh has responded with the answers to your questions – as well as a few I gathered from other Percona folks, and attendees of OpenSQL Camp. Thank you Paul! What’s the “ideal” use case for the PBXT engine, and how does it compare in performance?  When would I [...]

Filed Under: Insight for Developers, MySQL Tagged With: , , , , ,

State of the art: Galera – synchronous replication for InnoDB

October 27, 2009 By 15 Comments

First time I heard about Galera on Percona Performance Conference 2009, Seppo Jaakola was presenting “Galera: Multi-Master Synchronous MySQL Replication Clusters”. It was impressed as I personally always wanted it for InnoDB, but we had it in plans at the bottom of the list, as this is very hard to implement properly. The idea by [...]

Filed Under: Insight for DBAs, MySQL Tagged With: , , ,

MySQL-Memcached or NOSQL Tokyo Tyrant – part 3

October 19, 2009 By 25 Comments

This is part 3 of our series.  In part 1 we talked about boosting performance with memcached on top of MySQL, in Part 2 we talked about running 100% outside the data with memcached, and now in Part 3 we are going to look at a possible solution to free you from the database.  The [...]

Filed Under: Benchmarks, Cloud and NoSQL, MySQL Tagged With: , ,
« Older Posts
Newer Posts »