… comparison to InnoDB and MyISAM. The second goal of benchmark was a popular myth that MyISAM is faster than InnoDB in reads, as InnoDB is transactional… here: http://www.mysqlperformanceblog.com/files/benchmarks/innodb-myisam-falcon.html (Note: This benchmark is synthetic micro benchmarks focusing on particular simple data access patterns…
Post: Fix of InnoDB/XtraDB scalability of rollback segment
January 18, 2009 By 9 Comments
… wrote about InnoDB scalability on 24-core box, and we made research of scalability problems in sysbench write workload (benchmark emulates intensive…-user user –mysql-password –mysql-db sbtest –mysql-table-engine innodb –myisam-max-rows 1000000 run
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
…. Innodb with innodb_file_per_table=1 had the following results: [root@DB10 ~]# for i in 1 10 100 1000 10000; do ./benchmark…scan performance nadly – MyISAM suffers worse than Innodb – Innodb extent allocation works (perhaps would be good option for MyISAM as well) – Innodb suffers fragmentation less…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
…, similar to ones in benchmark InnoDB vs MyISAM vs Falcon (http://www.mysqlperformanceblog.com/2007/01/08/innodb-vs-myisam-vs-falcon-benchmarks-part-1) The… MyISAM / InnoDB and pbxt-0.9.85-beta.tar.gz Compilation parameters: For MyISAM / InnoDB ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb Method of benchmark…
Post: MyISAM Scalability and Innodb, Falcon Benchmarks
October 12, 2007 By 10 Comments
… about InnoDB scalability problems, this time We are faced with one for MyISAM tables. We saw that several times in synthetic benchmarks but never in production, that’s why we did not escalate MyISAM… good enough for performance gotcha illustration purposes. The benchmark shows following results for MyISAM using MySQL 5.0.45 run on 4…
Post: Join performance of MyISAM and Innodb
May 29, 2006 By 6 Comments
We had discussion today which involved benchmarks of Join speed for MyISAM and Innodb storage engines for CPU bound workload, this is when… 1.19s Innodb 0.07s 0.30s 0.38s As you see in such circumstances Innodb is actually faster than MyISAM in 2 cases out of 3. I guess the reasons are the following: Innodb primary…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
… few CPU-bound tasks there. The goal of benchmarks was investigation of InnoDB-plugin and XtraDB scalability in CPU-bound load. CPU…=MYISAM ft_min_word_len=4 innodb_additional_mem_pool_size=16M innodb_buffer_pool_size=15G innodb_data_file_path=ibdata1:10M:autoextend innodb… post. And last one workload I tried is TPCC-like benchmark (you can get it on https://launchpad.net/perconatools), with…
Post: Modeling InnoDB Scalability on Multi-Core Servers
January 26, 2011 By 11 Comments
…’s blog post on InnoDB-vs-MyISAM benchmarks that Oracle recently published prompted me to do some mathematical modeling of InnoDB‘s scalability as the number of cores in the server increases. Vadim runs lots of benchmarks that measure…
Post: MySQL and PostgreSQL SpecJAppServer benchmark results
July 25, 2007 By 13 Comments
… MySQL benchmark use Sun Fire X4100 available in Nov 2005 using Opteron 285 CPU, PostgreSQL benchmarks use … using MySQL 5.0.27 which has Innodb scalability issues, which were a lot improved… come from MySQL unique features – non transactional MyISAM, Multi Value inserts, Query Cache, Merge Tables, …
Post: New OLAP Wikistat benchmark: Introduction and call for feedbacks
January 28, 2010 By 16 Comments
… can see details on our Percona Wikistat benchmark Wiki. I have next goals with proposed benchmark: Compare engines in OLAP queries for… to load data and run queries against available engines: MySQL MyISAM / InnoDB (to have reference results) InfoBright InfiniDB MonetDB LucidDB Greenplum and…
