Buy Percona ServicesBuy Now!

MySQL Blob Compression performance benefits

 | January 11, 2008 |  Posted In: Insight for DBAs

When you’re storing text of significant size in the table it often makes sense to keep it compressed. Unfortunately MySQL does not provide compressed BLOB/TEXT columns (I would really love to have COMPRESSED attribute for the BLOB/TEXT columns which would make them transparently compressed) but you well can do it yourself by using COMPRESS/UNCOMPRESS functions […]

Read More

Be careful rotating MySQL logs

 | December 9, 2007 |  Posted In: Insight for DBAs

If you enable logging of all queries as “slow queries” using the patch or MySQL 5.1 you can get log file to grow huge. Same may happen with general log file. In some cases we’ve got log file sizes of 100G or more which may need to be cleaned up. Here is some danger waiting […]

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

10+ Ways to Crash or Overload MySQL

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

People are sometimes contacting me and asking about bugs like this which provide a trivial way to crash MySQL to the user with basic privileges and asking me what to do. My answer to them is – there is nothing new to it and they just sit should back and relax 🙂 Really – there […]

Read More

Innodb Undelete and Sphinx Support

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

At Percona we are pleased to announce couple of services which should be helpful to MySQL Community and which are not offered by MySQL, Oracle and other companies I know about. First we now do Data Recovery for MySQL. We’re mainly focused on Innodb with this one because it has distinct page structure which allows […]

Read More

Filtered MySQL Replication

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

To get this straight – I’m not a big fan of filtered or partial MySQL Replication (as of version MySQL 5.0) – there is enough gotchas with replication itself and getting things right with filtering can get quite bumpy road. In some applications however it is very helpful so lets see what one should do […]

Read More

Choosing innodb_buffer_pool_size

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

My last post about Innodb Performance Optimization got a lot of comments choosing proper innodb_buffer_pool_size and indeed I oversimplified things a bit too much, so let me write a bit better description. Innodb Buffer Pool is by far the most important option for Innodb Performance and it must be set correctly. I’ve seen a lot […]

Read More

Innodb Performance Optimization Basics

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

Note: There is an updated post on this topic here. Interviewing people for our Job Openings I like to ask them a basic question – if you have a server with 16GB of RAM which will be dedicated for MySQL with large Innodb database using typical Web workload what settings you would adjust and interestingly […]

Read More