Monthly Archives - March 2010

Percona-XtraDB-9.1: released and new coming features

Recently Alexandr announced new Percona-XtraDB-9.1 release, and now it is good time to summarize features we have and what is expected soon.
This release contains long waited features from 5.0:

extended slow.log

USER/TABLE/INDEX/CLIENT_STATISTICS + THREAD_STATISTICS ( coming in release-10)

Extended slow.log is now even more extended, there is additional information for each query:

Shell

# Bytes_sent: 4973 Tmp_tables: […]

Read more

Percona sessions at the MySQL conference

Many Percona employees will be at the 2010 MySQL conference. We’ll be giving a lot of informative technical talks on various topics. Here’s a list:

Morgan Tocker, Baron Schwartz: Diagnosing and Fixing MySQL Performance Problems
Peter Zaitsev: Scaling Applications with Caching, Sharding and Replication
Baron Schwartz: EXPLAIN Demystified
Vadim Tkachenko: An Overview of Flash Storage for […]

Read more

Percona-XtraDB version 9.1

Dear Community,
We are announcing today the new version 9.1 of XtraDB storage engine.
The name of binaries has changed to Percona-XtraDB. It is applicable to all packages including RPM, DEB and tar.gz packages.
New features in version 9.1:

MySQL 5.1.43 is taken as the basis
packages name changed to Percona-XtraDB
Enabled support of SSL
Enabled profiling
Added script to sort LRU […]

Read more

The 451 Group reports on TokuDB v3.0 for MySQL

Matt Aslett over at The 451 Group has written a Market Development report entitled “Tokutek delivers ACID transaction support with TokuDB version 3.0.” Get the full report and you can try out The 451 Group’s services for free by visiting http://the451group.com/apply/apply.php.
Matt observes that, “While TokuDB is effectively an operational database technology, it does blur […]

Read more

How many fsync / sec FusionIO can handle

I recently was asked how many fsync / sec ( and therefore durable transactions / sec) we can get on FusionIO card.
It should be easy to test, let’s take sysbench fileio benchmark and run, the next command should make it:

Shell

./sysbench –test=fileio –file-num=1 –file-total-size=50G –file-fsync-all=on –file-test-mode=seqrewr –max-time=100 –file-block-size=4096 –max-requests=0 run

1

./sysbench –test=fileio –file-num=1 –file-total-size=50G –file-fsync-all=on […]

Read more