Monthly Archives - March 2010

Announcing TokuDB v3.1

Tokutek is pleased to announce immediate availability of TokuDB for MySQL, version 3.1. It is designed for continuous querying and analysis of large volumes of rapidly arriving and changing data, while maintaining full ACID properties.
TokuDB v3.1’s new functionality includes:

Improved handling of a full disk
Configurable disk space reserve
Faster group commits
Faster crash recovery
Improved SHOW ENGINE STATUS and SHOW […]

Read more

RAID throughput on FusionIO

Along with maximal possible fsync/sec it is interesting how different software RAID modes affects throughput on FusionIO cards.
In short conclusion, RAID10 modes really disappoint me, the detailed numbers to follow.
To get numbers I run

Shell

sysbench fileio

1

sysbench fileio

test with 16KB page size, random read and writes, 1 and 16 threads, O_DIRECT mode.
FusionIO cards are […]

Read more

xtrabackup-1.1

Dear Community,
It is time to announce the next version of backup software from Percona – XtraBackup 1.1.
The list of changes in version 1.1 includes:
Changelog:

XtraBackup is built on a base of MySQL 5.1.44 with InnoDB plugin 1.0.6
Added –host option
tar4ibd can treat over 64GB file
tar4ibd is default method for stream, even tar is specified
the binary supports […]

Read more

InnoDB TABLE/INDEX stats

In Released and new coming features I did not mentioned two additional INFORMATION_SCHEMA tables available in XtraDB:
It is

INNODB_TABLE_STATS

INNODB_INDEX_STATS

These table show statistics about InnoDB tables ( taken from InnoDB data dictionary).
INNODB_TABLE_STATS is

| table_name | table name in InnoDB internal style (‘database/table’) |

| rows | estimated number of all rows |

| clust_size | cluster index […]

Read more

When the subselect runs faster

A few weeks ago, we had a query optimization request from one of our customer.
The query was very simple like:

Shell

SELECT * FROM `table` WHERE (col1=’A’||col1=’B’) ORDER BY id DESC LIMIT 20 OFFSET 0

1

SELECT * FROM `table` WHERE (col1=’A’||col1=’B’) ORDER BY id DESC LIMIT 20 OFFSET 0

This column in the table is looks like this:

Shell

`col1` […]

Read more