Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
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 17, 2010
SSD: Free space and write performance
( cross posting from SSD Performance Blog ) In previous post On Benchmarks on SSD, commenter touched another interesting point. [...]
July 14, 2010
On Benchmarks on SSD
(cross post from SSD Performance Blog ) To get meaningful performance results on SSD storage is not easy task, let’s [...]
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 7, 2010
Performance Optimization and Six Sigma
You might be familiar with Six Sigma business management strategy which is employed by variety of the companies in relationship [...]
June 2, 2010
FlashCache: tpcc workload with FusionIO card as cache
This run is very similar what I had on Intel SSD X25-M card, but now I use FusionIO 80GB SLC [...]
June 2, 2010
PBXT in tpcc-like benchmark
Finally I was able to run PBXT 1.0.11 pre-GA in tpcc-like workload, apparently there was bug with did not allow [...]
May 25, 2010
FlashCache: tpcc workload
This is my last post in series on FlashCache testing when the cache is placed on Intel SSD card. This [...]
May 24, 2010
Tuning InnoDB Concurrency Tickets
InnoDB has an oft-unused parameter innodb_concurrency_tickets that seems widely misunderstood. From the docs: “The number of threads that can enter [...]
May 18, 2010
FlashCache: more benchmarks
Previously I covered simple case with FlashCache, when data fits into cache partitions, now I am trying to test when [...]
May 10, 2010
FlashCache: first experiments
I wrote about FlashCache there, and since that I run couple benchmarks, to see what performance benefits we can expect. [...]
April 21, 2010
MySQL 5.5.4 in tpcc-like workload
MySQL-5.5.4 ® is the great release with performance improvements, let’s see how it performs in tpcc-like workload. The full details [...]
March 24, 2010
RAID throughput on FusionIO
Along with maximal possible fsync/sec it is interesting how different software RAID modes affects throughput on FusionIO cards. In short [...]
March 19, 2010
Is your MySQL Server Loaded ?
So you’re running the benchmark/stress test – how do you tell if MySQL server is really loaded ? This looks [...]
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 [...]