Monthly Archives - December 2010

Write performance on Virident tachIOn card

This is crosspost from https://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 (https://www.percona.com/blog/2010/07/17/ssd-free-space-and-write-performance/), using a
FusionIO 320GB […]

Read more

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 […]

Read more

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 MySQL 5.1.52.
New […]

Read more

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 5.1.53-12 code bases (fixes […]

Read more

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 […]

Read more

Announcing TokuDB for MariaDB

Tokutek is pleased to announce support for MariaDB for the first time with TokuDB v4.1.1 for MariaDB v5.1.47.
Our customers are choosing MariaDB more and more frequently for their most demanding database applications. We are delighted to help raise MariaDB performance to the next level by making TokuDB available on this new platform. One of […]

Read more

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 […]

Read more

Using MySQL OPTIMIZE tables? For InnoDB? Stop!

Innodb/XtraDB tables do benefit from being reorganized often. You can get data physically laid out in primary key order as well as get better feel for primary key and index pages and so using less space, it is just MySQL OPTIMIZE TABLE might not be best way to do it. In this post, we’re going […]

Read more

Recordings for webinars are now online

We’ve just published the recordings for our webinars; Migrating MyISAM to InnoDB and Introduction to Percona Server, XtraDB and Xtrabackup.  To listen, click on (Watch: Recorded Webinar) on each of these links.
We’re planning for future webinars next year.  If you have any suggestions, feel free to leave a comment.

Read more