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

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.