… 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…
Post: High Rate insertion with MySQL and Innodb
January 7, 2011 By 17 Comments
… memory. Last time I worked with similar system it used MyISAM and the system was built using multiple tables. Using multiple… over 200K of inserts/sec. This time I worked with Innodb tables… it was a different system with different table structure… what I used for start. Using multiple buffer pools with innodb_buffer_pool_instances=8 was very important. Second thing – Partitioning…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… – I have significantly reduced InnoDB buffer pool to make sure the benchmark is IO bound. That said, benchmark was running on a Percona…_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover skip-grant-tables…
Post: Moving from MyISAM to Innodb or XtraDB. Basics
November 22, 2010 By 2 Comments
… ? Regression Benchmarks – Make sure to run regression benchmarks in particular in terms of concurrent behavior. You may have hidden dependencies of MyISAM table… to guaranty you will never run into them. Performance Benchmarks – Innodb and MyISAM have different performance properties and you can’t really say…
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 30 Comments
…)? In this post I’d like to present a small benchmark which shows MySQL performance when you use 3 different approaches… words about our data set we’ve used for this benchmark. We have 4 tables: 1) Table with ENUM: CREATE TABLE… times faster than for MyISAM. This is great example of the case when Innodb is much faster than MyISAM for Read load. The…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… will LOAD DATA INFILE be optimized same way as for MyISAM tables by separate phase of building Indexes ? Will be UNIQUE… range scans. We surely should benchmark this aspect separately. Improved Auto Increment handling Yet another known Innodb problem is table locks which… Scalability improvements Yasufumi Kinoshita did number of interesting benchmarks stress testing other areas in Innodb than buffer-pool which had it locking…
Post: To pack or not to pack - MyISAM Key compression
May 13, 2006 By 4 Comments
… not a bit longer rows is frequent reason of MyISAM performing better than Innodb. In this article I’ll get in a… still best but for Innodb for example difference is not so large. Let us try couple of benchmarks now. I’ve created… case, as integers are relatively short. Now lets do some benchmarks. I’m testing 4 types of queries: select count(*) from…
