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? […]Read more
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 […]
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 […]
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!
Q: How do I tune TokuDB?
A: You don’t!
TokuDB has almost no […]
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 Live […]
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 initial […]
MySQL 5.5 and Percona Server 5.5 do not solve all scalability problems even for read only workloads. Workloads which got a lot of attention such as Sysbench and DBT2/TPC-C scale pretty well a they got a lot of attention, there can be other quite typical workloads however which do not scale that well. […]Read more
http://Flexvie.ws fully implements a method for creating materialized views for MySQL data sets. The tool is for MySQL, but the methods are database agnostic. A materialized view is an analogue of software transactional memory. You can think of this as database transactional memory, or as database state distributed over time, […]Read more
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 […]
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, […]