Buy Percona ServicesBuy Now!

TokuDB v5.0.6 is Now Available

 | November 11, 2011 |  Posted In: Tokutek, TokuView

  This version includes support for “SELECT … FOR UPDATE” as well as displaying table “create time” and “last update time” via “SHOW TABLE STATUS”. The release also addresses a number of other bugs and fixes such as “point update” and “replace into” deadlocks. For more details, see the release notes section of the user’s […]

Read More

Review of Virident FlashMAX MLC cards

 | November 10, 2011 |  Posted In: Benchmarks, Hardware and Storage, MySQL

I have been following Virident for a long time (e.g. https://www.percona.com/blog/2010/06/15/virident-tachion-new-player-on-flash-pci-e-cards-market/). They have great PCIe Flash cards based on SLC NAND. I always thought that Virident needed to come up with an MLC card, and I am happy to see they have finally done so. At Virident’s request, I performed an evaluation of their MLC […]

Read More

Improved InnoDB fast index creation

 | November 6, 2011 |  Posted In: Benchmarks, Insight for DBAs, MySQL

One of the serious limitations in the fast index creation feature introduced in the InnoDB plugin is that it only works when indexes are explicitly created using ALTER TABLE or CREATE INDEX. Peter has already blogged about it before, here I’ll just briefly reiterate other cases that might benefit from that feature: when ALTER TABLE […]

Read More

“How Fractal Trees Work” at MIT today

 | November 4, 2011 |  Posted In: Tokutek, TokuView

I’ll be talking about How Fractal Trees Work  today at MIT in the Computational Research In Boston and Beyond (CRIBB) seminar (http://www-math.mit.edu/crib/2011/nov4.html). The talk is at 12:30 in the Stata Center room 32-141.  Pizza available before. This talk will be academically-oriented (not much marketing).  The abstract is as follows: Most storage systems employ B-trees to achieve […]

Read More

Emulating global transaction ID with pt-heartbeat

 | November 4, 2011 |  Posted In: Insight for DBAs, MySQL

Global transaction IDs are being considered for a future version of MySQL. A global transaction ID lets you determine a server’s replication position reliably, among other benefits. This is great when you need to switch a replica to another master, or any number of other needs. Sometimes you can’t wait for the real thing, but […]

Read More

Webinar: Scaling MySQL with TokuDB

 | November 3, 2011 |  Posted In: Tokutek, TokuView

MySQL implementations are often kept relatively small, often just a few hundred GB or less. Anything beyond this quickly leads to painful operational problems such as poor insertion rates, slow queries, hours to days offline for schema changes, prolonged downtime for dump/reload, etc. The promise of scalable MySQL has remained largely unfulfilled, until TokuDB. Time: […]

Read More

The Big Data Community at the MassTLC unConference

 | November 1, 2011 |  Posted In: Tokutek, TokuView

  I had the pleasure of being invited to blog at the MassTLC unConference on Friday. The event was a full day of diverse topics and discussions ranging from the latest in recipe sharing sites, to entrepreneurial CEO war stories, to hot trends in venture investing. An excerpt covering Big Data from my MassTLC blog […]

Read More