EmergencyEMERGENCY? Get 24/7 Help Now!

Understanding Performance Optimization Terminology

 | March 2, 2009 |  Posted In: Insight for Developers

There are few terms you need to have a good understanding if you’re working with high volume systems. I commonly see these mixed and people not understanding the difference between them. Performance – The performance comes down to performing up to users expectations (or expectations of your boss) which drills down to two important metrics […]

Read More

KISS KISS KISS

 | March 1, 2009 |  Posted In: Insight for DBAs

When I visit customers quite often they tell me about number of creative techniques they heard on the conferences, read on the blogs, forums and Internet articles and they ask me if they should use them. My advice is frequently – do not. It is fun to be creative but creative solutions also means unproven […]

Read More

Percona XtraBackup: Open Source Alternative for InnoDB Hot Backup call for ideas

 | February 24, 2009 |  Posted In: Percona Software

For long time as main backup solution for MySQL on Linux we have been using LVM snapshots. Performance concerns from performance critical envinronment caused us to do LVM performance research which showed horrible results forcing us to look at more performing alternatives. Innodb Hot Backup is a good working solution but it is not Open […]

Read More

Beware of MySQL Data Truncation

 | February 7, 2009 |  Posted In: Insight for DBAs

Here is nice gotcha which I’ve seen many times and which can cause just a minefield for many reasons. Lets say you had a system storing articles and you use article_id as unsigned int. As the time goes and you see you may get over 4 billions of articles you change the type for article_id […]

Read More

Should you move from MyISAM to Innodb ?

 | January 12, 2009 |  Posted In: Insight for DBAs

There is significant portion of customers which are still using MyISAM when they come to us, so one of the big questions is when it is feasible to move to Innodb and when staying on MyISAM is preferred ? I generally prefer to see Innodb as the main storage engine because it makes life much […]

Read More

Goal driven performance optimization

 | December 22, 2008 |  Posted In: Insight for Developers

When your goal is to optimize application performance it is very important to understand what goal do you really have. If you do not have a good understanding of the goal your performance optimization effort may well still bring its results but you may waste a lot of time before you reach same results as […]

Read More

Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB

 | December 16, 2008 |  Posted In: Percona Software

Today we officially announce our new storage engine, “Percona XtraDB“, which is based on the InnoDB storage engine. It’s 100% backwards-compatible with standard InnoDB, so you can use it as a drop-in replacement in your current environment. It is designed to scale better on modern hardware, and includes a variety of other features useful in […]

Read More

SHOW OPEN TABLES – what is in your table cache

 | December 14, 2008 |  Posted In: Insight for DBAs

One command, which few people realize exists is SHOW OPEN TABLES – it allows you to examine what tables do you have open right now:

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.