Monthly Archives - July 2009

Copying InnoDB tables between servers

The feature I announced some time ago https://www.percona.com/blog/2009/06/08/impossible-possible-moving-innodb-tables-between-servers/ is now available in our latest releases of XtraBackup 0.8.1 and XtraDB-6.
Now I am going to show how to use it (the video will be also available on percona.tv).
Let’s take tpcc schema and running standard MySQL ® 5.0.83, and assume we want to copy order_line […]

Read more

Autoincrement Semantics

In this post I’m going to talk about how TokuDB’s implementation of auto increment works, and contrast it to the behavior of MyISAM and InnoDB. We feel that the TokuDB behavior is easier to understand, more standard-compliant and offers higher performance (especially when implemented with Fractal Tree indexes).
In TokuDB, each table can have […]

Read more

5.0.83-build17 Percona binaries

Dear Community,
The build 17 of MySQL with Percona patches is available.
New features in the release:

MySQL-5.0.83 is taken as the basis
The new patch innodb_use_sys_malloc.patch is added
The new patch innodb_split_buf_pool_mutex.patch is added
This patch splits the single global InnoDB buffer pool mutex into several mutexes for different purposes. This reduces mutex contention. It may help if you […]

Read more

Maatkit Now Supports Memcached

Have you ever wondered how optimized your Memcached installation is? There is a common misconception that one doesn’t have to think too deeply about Memcached performance, but that is not true. If your setup is inefficient, you could:

Burn Memory
Waste Network Round-Trips
Store Keys That Never Get Retrieved
Have a Low Cache Hit Ratio (i.e. […]

Read more

Just how useful are binary logs for incremental backups?

We’ve written about replication slaves lagging behind masters before, but one of the other side effects of the binary log being serialized, is that it also limits the effectiveness of using it for incremental backup.  Let me make up some numbers for the purposes of this example:

We have 2 Servers in a Master-Slave topology.
The […]

Read more

XtraDB storage engine release 1.0.3-6

Dear community,
Today we are pleased to announce release 6 of XtraDB – the result of 2 months hard work.
The release includes following new features:

MySQL 5.1.36 as a base release
New patch

Shell

innodb_recovery_patches.patch

1

innodb_recovery_patches.patch

Experimental adaptive checkpoint method estimate
innodb_stats – the implementation of the fix forMySQL Bug#30423
expand-import Support of import InnoDB / XtraDB tables from another server
split-bufpool-mutex-3 […]

Read more