Andrew from Sphinx continues to work on improving SQL (or SphinxQL) support and now he published benchmarks comparing arithmetic expression handling in Sphinx to one in MySQL. The result ? Sphinx scored 3x to 20x faster. Andrew goes to explain results are not 100% comparable (as we can see […]Read more
In XtraDB we have the table INNODB_BUFFER_POOL_PAGES_INDEX which shows which pages belong to which indexes in which tables. Using thing information and standard TABLES table we can see how well different tables fit in buffer pool.
ROUND(100 * cnt * 16384 / ( data_length + index_length […]
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 […]
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
test with 16KB page size, random read and writes, 1 and 16 threads, O_DIRECT mode.
FusionIO cards are […]
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:
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 […]