September 17, 2014

Intel 320 SSD write performance – contd.

I wrote about Intel 320 SSD write performance before, but I was not satisfied with these results. Somewhat each time on Intel 320 SSD I was getting different write performance, so it made me looking into this with details.

FusionIO 320GB MLC random write performance

I have posted results for FusionIO 320GB MLC on our ssdperformanceblog.com blog. To not duplicate content, there is link on original post:http://www.ssdperformanceblog.com/2011/06/fusionio-320gb-mlc-random-write-performance/ Follow my twitter Follow @VadimTk for further results.

Intel 320 SSD random write performance

I have posted results for Intel 320 SSD on our ssdperformanceblog.com blog. To not duplicate content, there is link on original post:http://www.ssdperformanceblog.com/2011/06/intel-320-ssd-random-write-performance/ Follow my twitter @VadimTk for further results.

Write performance on Virident tachIOn card

This is crosspost from http://www.ssdperformanceblog.com/. Disclaimer: The benchmarks were done as part of our consulting practice, but this post is totally independent and fully reflects our opinion. One of the biggest problems with solid state drives is that write performance may drop significantly with decreasing free space. I wrote about this before (http://www.ssdperformanceblog.com/2010/07/free-space-and-write-performance/), using a […]

SSD: Free space and write performance

( cross posting from SSD Performance Blog ) In previous post On Benchmarks on SSD, commenter touched another interesting point. Available free space affects write performance on SSD card significantly. The reason is still garbage collector, which operates more efficiently the more free space you have. Again, to read mode on garbage collector and write […]

How to improve InnoDB performance by 55% for write-bound loads

During April’s Percona Live MySQL Conference and Expo 2014, I attended a talk on MySQL 5.7 performance an scalability given by Dimitri Kravtchuk, the Oracle MySQL benchmark specialist. He mentioned at some point that the InnoDB double write buffer was a real performance killer. For the ones that don’t know what the innodb double write […]

Reference architecture for a write-intensive MySQL deployment

We designed Percona Cloud Tools (both hardware and software setup) to handle a very high-intensive MySQL write workload. For example, we already observe inserts of 1bln+ datapoints per day. So I wanted to share what kind of hardware we use to achieve this result. Let me describe what we use, and later I will explain […]

Using MySQL 5.6 Performance Schema in multi-tenant environments

Hosting a shared MySQL instance for your internal or external clients (“multi-tenant”) was always a challenge. Multi-tenants approach or a “schema-per-customer” approach is pretty common nowadays to host multiple clients on the same MySQL sever. One of issues of this approach, however, is the lack of visibility: it is hard to tell how many resources (queries, disk, […]

Percona XtraDB Cluster performance monitoring and troubleshooting

First of all we would like to thank all of you who attended the Feb. 19 MySQL webinar, “Performance Monitoring and Troubleshooting of Percona XtraDB Cluster.” We got some really good questions – many of which we didn’t have time to address during the sessions, so Johan Andersson, Severalnines CTO,and I are answering them here […]

PERFORMANCE_SCHEMA vs Slow Query Log

A couple of weeks ago, shortly after Vadim wrote about Percona Cloud Tools and using Slow Query Log to capture the data, Mark Leith asked why don’t we just use Performance Schema instead? This is an interesting question and I think it deserves its own blog post to talk about. First, I would say main […]