EmergencyEMERGENCY? Get 24/7 Help Now!

MySQL Schema Agility on SSDs

 | September 29, 2012 |  Posted In: Tokutek, TokuView

TokuDB v6.5 adds the ability to expand certain column types without downtime.  Users can now enlarge char, varchar, varbinary, and integer columns with no interruption to insert/update/delete statements on the altered table.  Prior to this feature, enlarging one of these column types required a full table rebuild.  InnoDB blocks all insert/update/delete operations to a table […]

Read More

Three Ways that Fractal Tree Indexes Improve SSD for MySQL

 | September 27, 2012 |  Posted In: Tokutek, TokuView

Since Fractal Tree indexes turn random writes into sequential writes, it’s easy to see why they offer a big advantage for maintaining indexes on rotating disks. It turns out that that Fractal Tree indexing also offers signficant advantages on SSD. Here are three ways that Fractal Trees improve your life if you use SSDs. Advantage […]

Read More

Logging Foreign Key errors

 | September 27, 2012 |  Posted In: MySQL

In the last blog post I wrote about how to log deadlock errors using Percona Toolkit. Foreign key errors have the same problems. InnoDB only logs the last error in the output of SHOW ENGINE INNODB STATUS, so we need another similar tool in order to have historical data. pt-fk-error-logger This is a tool very […]

Read More

Announcing TokuDB v6.5: Optimized for Flash

 | September 25, 2012 |  Posted In: Tokutek, TokuView

We are excited to announce TokuDB® v6.5, the latest version of Tokutek’s flagship storage engine for MySQL and MariaDB. This version offers optimization for Flash as well as more hot schema change operations for improved agility. We’ll be posting more details about the new features and performance, so here’s an overview of what’s in store. […]

Read More

Timezone and pt-table-checksum

 | September 25, 2012 |  Posted In: Insight for DBAs, MySQL, Percona Software

I recently worked through an issue with a client trying to detect data drift across some servers that were located in different timezones.  Unfortunately, several of the tables had timestamp fields and were set to a default value of CURRENT_TIMESTAMP.  From the manual, here is how MySQL handles timezone locality with timestamp fields: Values for TIMESTAMP columns are […]

Read More