… II as the cache storage device. EXT4 is the filesystem, and CentOS 6.4 the operating system…mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL configuration (configuration A) appears below: #####fixed innodb options innodb…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…MySQL AB made new storage engine Falcon available for wide auditory. We cannot … and queries are described here Used hardware CentOS release 4.4 (Final) 2 Ñ… Dual…MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql…
Post: Percona-XtraDB version 9.1
March 14, 2010 By 16 Comments
…the new version 9.1 of XtraDB storage engine. The name of binaries has changed to…mysql-tests: mysql mysql_upgrade ssl tests enabled rpl_killed_ddl and innodb-autoinc tests Percona-XtraDB obsoletes mysql…. It will replace currently installed mysql-server, mysql-client, etc. Centos platform. 1. If you …
Post: Percona Server version 10
April 13, 2010 By 3 Comments
… of Percona Server with XtraDB storage engine. Since the previous release 9.1 there are following changes MySQL 5.1.45 as a… checksum algorithm used in InnoDB tables New supported platforts are added. The full list includes (karmic is new): CentOS 5 (x86_64… at mysql start Bug #550867:5.1.45+xtradb-10 compilation fails on Ubuntu Karmic Bug #547230:Add new columns to innodb…
Post: MySQL - to use or not to use
May 28, 2007 By 10 Comments
…MySQL 4.0. This even applies to Innodb tables which were already on par with general MySQL level of stability in MySQL…MySQL 5.0 with spice of enterprise features is far from being simple and MySQL 5.1+ with wide choice of storage engines…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
…guess it is first reaction on new storage engine – show me benefits. So there is benchmark I made on… MySQL 5.1.30 trees – MySQL 5.1.30 with standard InnoDB, MySQL 5.1.30 with InnoDB-plugin-1.0.2 and MySQL … Linux kernels 2.6.18+ (which are used on CentOS / RedHat 5.2) are coming with CFQ scheduler as…
