Write performance on Virident tachIOn card

This is crosspost from http://www.percona.com/blog/. Disclaimer: The benchmarks were done as part of our consulting practice, but this post is totally independent and fully reflects our opinion. One of the biggest problems with solid state drives is that write performance may drop significantly with decreasing free space. I wrote about this before (http://www.percona.com/blog/2010/07/17/ssd-free-space-and-write-performance/), using a […]

Percona Training in London and Frankfurt

For those that missed it – last week we added training in Frankfurt and London to our website.  This includes our new Operations Training announced in September. (While in Europe, we’d love to speak at your meetup group on Percona Server and/or MySQL Optimization.  If you’re a meetup organizer in London or Paris, please feel […]

Percona Server 5.1.52-12.3

Percona Server version 5.1.52-12.3 is now available for download. The main purpose of this release is to update the current Percona release candidate to the latest version of MySQL 5.1. The release also includes the HandlerSocket plugin, which provides NoSQL features in Percona Server. Functionality Added or Changed Percona Server 5.1.52-12.3 is now based on […]

Percona XtraBackup 1.5-Beta

Percona XtraBackup 1.5-Beta is now available for download. This release adds additional functionality to Percona XtraBackup 1.4, the current general availability version of XtraBackup. This is a beta release. Functionality Added or Changed Support for MySQL 5.5 databases has been implemented. (Yasufumi Kinoshita) XtraBackup can now be built from the MySQL 5.1.52, MySQL 5.5.7, or Percona Server […]

MySQL Partitioning – can save you or kill you

I wanted for a while to write about using MySQL Partitioning for Performance Optimization and I just got a relevant customer case to illustrate it. First you need to understand how partitions work internally. Partitions are on the low level are separate table. This means when you’re doing lookup by partitioned key you will look […]

How well does your table fits in innodb buffer pool ?

Understanding how well your tables and indexes fit to buffer pool are often very helpful to understand why some queries are IO bound and others not – it may be because the tables and indexes they are accessing are not in cache, for example being washed away by other queries. MySQL Server does not provide […]

Getting History of Table Sizes in MySQL

One data point which is very helpful but surprisingly few people have is the history of the table sizes. Projection of data growth is very important component for capacity planning and simply watching the growth of space used on partition is not very helpful. Now as MySQL 5.0+ has information schema collecting and keeping this […]