Monthly Archives - September 2011

White Paper: Flashcache and MySQL on Virident drive

Our latest MySQL white paper is Improving Percona Server performance with Flashcache on the Virident tachIOn Drive. (Virident funded the research, but as always, we wrote the report ourselves.)
The conclusion is that Flashcache can be good for read-heavy workloads, but more research is needed to understand its performance characteristics on write-heavy workloads. We […]

Read more

Disaster: MySQL 5.5 Flushing

We raised topic of problems with flushing in InnoDB several times, some links:
InnoDB Flushing theory and solutions
MySQL 5.5.8 in search of stability
This was not often recurring problem so far, however in my recent experiments, I observe it in very simple sysbench workload on hardware which can be considered as typical nowadays.
(more…)

Read more

Compression Benchmarking: Size vs. Speed (I want both)

I’m creating a library of benchmarks and test suites that will run as part of a Continuous Integration (CI) process here at Tokutek. My goal is to regularly measure several aspects of our storage engine over time: performance, correctness, memory/CPU/disk utilization, etc. I’ll also be running tests against InnoDB and other databases for comparative […]

Read more

MySQL data via a NoSQL solution, Free ticket to Percona Live London

The much-anticipated ability to access MySQL data via a NoSQL solution has been realized. Using HandlerSocket, significant performance gains can be realized for certain workloads. Sound like something you are interested in? Join us for Percona Live London to hear Ryan Lowe, Percona’s Director of American Consulting speak on this subject. In Ryan’s session […]

Read more

Online Advertiser Intent Media Selects TokuDB over InnoDB and NoSQL for Big Data Ad-Hoc Analysis

Intent Media
Issue addressed: Ad hoc analytics on clickstream data arriving too fast for InnoDB or NoSQL to handle.
TokuDB powers an online advertising application
The Company: Headquartered in New York, Intent Media is a fast-growing online advertising startup. The company helps some of the largest online retailers monetize their traffic more efficiently at scale by showing […]

Read more