Working on large upgrade of MySQL 4.1 running Innodb to MySQL 5.0 and doing oprofile analyzes we found very interesting issue of … much higher for MySQL 5.0 compared to MySQL 4.1 It was something like 2-3 for MySQL 4.1 vs 40-60 for MySQL 5.0 At the same… Sleep shows much smaller value which is close in MySQL 5.0 and 4.1 Hopefully this issue will be fixed sooner or later…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
…MySQL 5.6.7 performs Hardware specification Server: Dell PowerEdge R710 CPU: 2x Intel(R) Xeon(R) CPU E5-2660 0… on bigger buffer_pool, innodb_buffer_pool_instances=1 is more preferable. The the results on …stable results. So there it is with 2x4GB vs 2x8GB innodb logfiles. Obviously the result is …
Comment: Quick comparison of MyISAM, Infobright, and MonetDB
October 1, 2009 By 30 Comments
Why you don’t put the version used of each software? that’s is very important!! there are differences between infobright 3.1.1 and 3.2 (ICE vs IEE), MySQL 4.1 vs 5.0 vs 5.1, for example.
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…on a Percona Server 5.0.92-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql socket=/var/…, the difference was still 15% — 909 iops unaligned -vs- 1049 aligned. Random write. This is an important … {925} dm-0 462.1 34.1 7.7 0% 3.8 8.2 12.1 87.0 0.5 0% 0.0 0.7 93% 0 While number …
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…` varchar(8) NOT NULL default ”, `country_id` smallint(5) unsigned NOT NULL default ‘0‘, PRIMARY KEY (`id`), UNIQUE KEY `email` (`email`), KEY… of RAM 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-5.1-falcon…
Post: ext4 vs xfs on SSD
March 15, 2012 By 26 Comments
…consider. Starting the MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally Percona Server 5.1 and 5.5), InnoDB uses “…results I see running MySQL benchmarks (to be published later) on ext4 vs xfs. Actually amount…,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d….
Post: InnoDB, InnoDB-plugin vs XtraDB on fast storage
January 13, 2010 By 13 Comments
… check how MySQL / InnoDB performs here. For benchmark I took MySQL 5.1.42 with built-in InnoDB, InnoDB-plugin 1.0.6, and XtraDB 1.0.6-9 ( InnoDB with Percona patches). As benchmark engine I used tpcc-mysql with 1000 warehouses…/wiki/benchmark:fusionio:mysql:start, here are my thoughts and interesting facts. First, chart with results for InnoDB vs InnoDB-plugin during…
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
… two versions tested: Percona Server 5.1.57 – released and Percona Server 5.1.57 with the Group Commit Fix …cache enabled thread trx=1, No binlog trx=1, Binlog sync=0 trx=1, Binlog sync=1 1 382.39 371.17…2188.38 There is still performance difference binlogs vs no-binlogs, but it is much smaller when…
Post: How much overhead DRDB could cause ?
June 2, 2008 By 4 Comments
…_flush_log_at_trx_commit=1 and sync_binlog=1 you will have 4 “sync” operations in MySQL 5.0 – there is event written to… not fixed in 5.1 to date. So this is the access pattern which is often going to define your MySQL on DRBD… overhead besides network IO we’re speaking about 300 microseconds vs 5000 microseconds and DRBD overhead can be well below 10…
Post: PBXT in tpcc-like benchmark
June 2, 2010 By 10 Comments
…I was able to run PBXT 1.0.11 pre-GA in tpcc-like workload, apparently there was…GB on server), and compared 1 and 16 users in MySQL-5.1.46/PBXT and Percona Server / XtraDB – 5.1.45-rel10.2. As … results are also better for PBXT: 5785.567 TpmC vs 4905.967 TpmC ( XtraDB) For 16 threads final result …
