… transactions Per Minute in tpcc-mysql). However, like Mark Callaghan mentioned…from being strict 0.5 sec, but 0.5 is the … node to a cluster (e.g. XtraDB Cluster), how does it affect the response…1-8 threads): The queue piles up, waiting time grows, and the final response time grows linearly up to ~30…
Post: Fix of InnoDB/XtraDB scalability of rollback segment
January 18, 2009 By 9 Comments
… 8 disks) to compare mysql-5.1.30-XtraDB-1.0.2-pre-release3 with default (1) and 16 rollback segments. For reference MySQL parameters: [mysqld] #mysqld options…-mode auto –mysql-host localhost –mysql-port 3306 –mysql-socket /data/vadim/benchwork/var/mysql_benchwork.sock –mysql-user user –mysql-password –mysql-db sbtest –mysql-table-engine…
Post: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB
December 16, 2008 By 25 Comments
… existing MySQL-5.1.30 installation http://www.percona.com/mysql/5.1.30/binary/percona-xtradb-1.0.2-1-5.1.30.x86_64.tar.gz * OurDelta will also be using Percona XtraDB for its upcoming 5.1 builds. XtraDB is…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
…. I compared MySQL 5.1.30 trees – MySQL 5.1.30 with standard InnoDB, MySQL 5.1.30 with InnoDB-plugin-1.0.2 and MySQL 5.1.30 with XtraDB (all plugins statically compiled in MySQL) For benchmarks…. As you see XtraDB is somewhat 1.5x better than InnoDB in standard 5.1.30 and even more than InnoDB-plugin-1.0.2 And…
Post: XtraDB storage engine release 1.0.2-2 (New Year edition)
December 29, 2008 By 20 Comments
… version 1.0.2-2 you can get as bzr branch lp:percona-xtradb -r tag:release-1.0.2-2 percona-xtradb-1.0.2-2 as source code in tar.gz as binaries, percona xtradb is compiled in into MySQL-5.1.30 RPM as separated shared library, to use as drop-in plugin for existing MySQL-5.1.30 installation XtraDB is…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
… virtual power management: I tested MySQL-5.1.30 with InnoDB plugin, Xtradb-1.0.2-1, and XtraDB-1.0.2-2 (rel2). XtraDB-rel2 has not been released… have the same TPS as with 1 connection (and it is on 24-cores box!). XtraDB is slightly better there than InnoDB… connections, but after that InnoDB-plugin is dropping down. XtraDB and XtraDB-rel2 seem quite better, I guess this is mostly because…
Post: Another scalability fix in XtraDB
January 23, 2009 By 13 Comments
… ’0′, zip varchar(8) NOT NULL default ”, country_id smallint(5) unsigned NOT NULL default ’0′, PRIMARY KEY (id) ) CREATE INDEX… InnoDB-plugin-1.0.2 were kind of discouraging, dropping down just after 8 connections, si I decided to test MySQL-5.1.30 with… for page_hash will be included in next release of XtraDB, and expect new results. for reference InnoDB was run with…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…XtraDB based on the MySQL 5.5 code line. The answer: Yes, we are. My benchmarks here are based on Percona Server 5.5…MySQL 5.5.8 we have regular dips (3 times per hour) from 24900 NOTPM to 17700 NOTPM (dips of around 30…choice is innodb_buffer_pool_instances=1, as we implemented buffer pool …
Comment: XtraDB storage engine release 1.0.2-2 (New Year edition)
January 2, 2009 By 20 Comments
Regarding “as binaries, percona xtradb is compiled in into MySQL-5.1.30 RPM” – does this mean that XtraDB is the default InnoDB storage engine in the server RPM file or does it still need to be enabled via the loadable modules method?
Post: Copying InnoDB tables between servers
July 31, 2009 By 10 Comments
…35 InnoDB: Rolling back trx with id 0 1559890, 30 rows to undo InnoDB: Rolling back of trx …to run MySQL server ® with XtraDB6 storage engine, you can take one of our binary builds with 5.1.36. On new server we run set global innodb_expand_import=1; to put XtraDB into …
