EmergencyEMERGENCY? Get 24/7 Help Now!

dbqp and Xtrabackup testing

 | November 16, 2011 |  Posted In: Benchmarks

So I’m back from the Percona dev team’s recent meeting.  While there, we spent a fair bit of time discussing Xtrabackup development.  One of our challenges is that as we add richer features to the tool, we need equivalent testing capabilities.  However, it seems a constant in the MySQL world that available QA tools often […]

Read More

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