Monthly Archives - May 2010

Percona Server 5.0.90-build21

Dear Community,
Percona Server 5.0.90, release 21 is available for use.
Comparing to the previous release it has following new features:

The build is based on MySQL-5.0.90

Fixed bugs:

Fixed Bug #539190 Percona-XtraDB package doesn’t allow libmysqlclient15off
Fixed Bug #479106 mysql-5.0.87 + patches-5.0.86 compile fail in ubuntu 9.10 (karmic)
Fixed tests mysql, mysql_upgrade, ssl*

See release notes for earlier changes.
(more…)

Read more

Debugging problems with row based replication

MySQL 5.1 introduces row based binary logging. In fact, the default binary logging format in GA versions of MySQL 5.1 is ‘MIXED’ STATEMENT*;   The binlog_format  variable can still be changed per sessions which means it is possible that some of your binary log entries will be written in a row-based fashion instead of […]

Read more

Checking for a live database connection considered harmful

It is very common for me to look at a customer’s database and notice a lot of overhead from checking whether a database connection is active before sending a query to it. This comes from the following design pattern, written in pseudo-code:

Shell

function query_database(connection, sql)
if !connection.is_alive() and !connection.reconnect() then
[…]

Read more

Goal-Driven Performance Optimization white-paper available

If you were at last month’s MySQL conference, you might have seen a small flyer we were distributing, titled “A brief introduction to Goal-Driven Performance Optimization.” This is a super-compressed technical introduction to one of the methods we use to solve problems as quickly and efficiently as possible. We’ve just posted this […]

Read more