Buy Percona ServicesBuy Now!

What’s a good buffer pool read/write ratio?

 | May 31, 2011 |  Posted In: MySQL

At Percona Live last week, someone showed me a graph from their Cacti monitoring system, using the templates that I wrote. It was the buffer pool pages read, written, and created. He asked me if the graph was okay. Shouldn’t there be a lot more pages read than written, he asked? It’s a great question. […]

Read More

Percona Live, NYC

 | May 27, 2011 |  Posted In: Tokutek, TokuView

Yesterday, Percona held Percona Live NYC, which they describe as an “intensive one-day MySQL summit.” They meant it. It was like drinking from a firehose. There was too much for me to give a complete report, so I’d like to highlight two sessions that stuck out for me. Why SQL Wins Sergei Tsarev (Clustrix) gave […]

Read More

Just hours left until Percona Live sells out!

 | May 25, 2011 |  Posted In: MySQL

We’re seeing a spike of last-minute ticket sales for Percona Live New York. Meanwhile, we’re assembling bags and unpacking t-shirts at the venue. If you want to come, buy your ticket now — we’re rapidly selling out the remaining tickets! Remember, if all the tickets are sold, you can still come to the evening event […]

Read More

Never Settle for a “B”

 | May 24, 2011 |  Posted In: Tokutek, TokuView

OldSQL DBs based on B-trees have some well-known problems and workarounds. TokuDB is a NewSQL storage engines based on Fractal Tree indexing, so the natural question is how InnoDB practice translates into TokuDB. This post gives a quick overview. Enjoy! FAQ Q: How do I tune TokuDB? A: You don’t! TokuDB has almost no parameters […]

Read More

Free Percona Live tickets and Percona Support contract!

 | May 23, 2011 |  Posted In: MySQL

Just a couple of announcements for Percona Live: we’re giving away free tickets through Engine Yard, and we’ve arranged our evening open-bar event. For a chance to win a free ticket, check out the guest blog post I wrote for Engine Yard on how to make Rails migrations faster and safer. In other news, Percona […]

Read More

InnoDB compression woes

 | May 20, 2011 |  Posted In: MySQL

InnoDB compression is getting some traction, and I see quite contradictory opinions. Someone has successful deployments in productions, and someone says that compression in current implementation is useless. To get some initial impression about performance I decided to run some sysbench with multi-tables benchmarks. I actually was preparing to do complex research, but even first […]

Read More

The case for getting rid of duplicate “sets”

 | May 17, 2011 |  Posted In: MySQL

The most useful feature of the relational database is that it allows us to easily process data in sets, which can be much faster than processing it serially. When the relational database was first implemented, write-ahead-logging and other technologies did not exist. This made it difficult to implement the database in a way that matched […]

Read More

SoMoLo Data

 | May 16, 2011 |  Posted In: Tokutek, TokuView

SoMoLo Data – Social, Mobile, and Local A Review of MassTLC’s “The Global Impact of Mobility” event this past Friday MassTLC celebrated World Enterprise Mobility Day on Friday by hosting an event near MIT on the “Global Impact of Mobility”. The event included panelists from industry (Groupon, BT, Cisco, etc..), press (WSJ), VC (Highland Capital, […]

Read More