EmergencyEMERGENCY? Get 24/7 Help Now!

Enum Fields VS Varchar VS Int + Joined table: What is Faster?

 | January 24, 2008 |  Posted In: Benchmarks

Really often in customers’ application we can see a huge tables with varchar/char fields, with small sets of possible values. These are “state”, “gender”, “status”, “weapon_type”, etc, etc. Frequently we suggest to change such fields to use ENUM column type, but is it really necessary (from performance standpoint)? In this post I’d like to present […]

Read More

Data Recovery Toolkit for InnoDB Version 0.1 Released

 | November 26, 2007 |  Posted In: Insight for DBAs

As Peter mentioned in one of previous posts, we’ve done huge work developing robust strategies of InnoDB data recovery to provide our customers effective data recovery services and one of major parts of these strategies is our toolkit for InnoDB data recovery. Today I’m proud to announce its first public release which was used to […]

Read More