…CPU-bound tasks there. The goal of benchmarks was investigation of InnoDB-plugin and XtraDB scalability in CPU-bound load. CPU…bits virtual power management: I tested MySQL-5.1.30 with InnoDB…cache_size=1M default_table_type=MYISAM ft_min_word_len=…_prepared_stmt_count=1000000 query_cache_size=0 skip_…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
… went over few percents and load was mostly CPU bound. Next I went on testing MySQL. My goal was to simulate as much… MyISAM (double of Innodb already) which scaled to 70.000 queries/sec peaking out at 16 threads. However even with MyISAM we got CPU bound before we could reach the system capacity – these 70K queries…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…CPU bound workload in this case (no disk IO) to see how efficient storage engines are in terms of CPU…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: MyISAM Scalability and Innodb, Falcon Benchmarks
October 12, 2007 By 10 Comments
… benchmark shows following results for MyISAM using MySQL 5.0.45 run on 4 Core System: Threads queries/sec 1 161 2 107… can see Falcon perform extremely poorly when single query executed being 1/3rd of MyISAM and 1/6th of Innodb. On other… – which is quite unexpected for CPU bound load on system with 4 Cores. Here is comparison of MyISAM Innodb and Falcon results in…
Post: Join performance of MyISAM and Innodb
May 29, 2006 By 6 Comments
… benchmarks of Join speed for MyISAM and Innodb storage engines for CPU bound workload, this is when …, integer indexed column and indexed char column. The query is also trivial – the point was to … need for MySQL to request next row matching index Note: This applies to CPU bound workload with …
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
…run, and it can’t be because we used MyISAM tables which are not ACID complaint. Plus we only… tested 10G and 100G data sets which was CPU bound and IO bound box on the Dell 2950 box w 16G…to 3 hours to give MySQL more time to complete the queries: Query MySQL 5.0.23 MySQL 6.0.4Ratio Query13784.453737…
Post: Using Multiple Key Caches for MyISAM Scalability
November 26, 2008 By 8 Comments
… – MyISAM Does Not Scale, or it does quite well… usage I will use Percona Patches: mysql> select * from information_schema.table_statistics …) A bit more query hacking and we get a query which will return statements … fact it can be very significant. For CPU bound workload with 16 Cores Inserting data …
Post: To pack or not to pack - MyISAM Key compression
May 13, 2006 By 3 Comments
… differently. For uncompressed index blocks MySQL can do binary search inside the … will be fast (read_next) as MyISAM will remember previous position and …I’m testing 4 types of queries: select count(*) from t1, t1 … these numbers are for CPU bound workload. If your load is disk bound there are …
Post: Impact of the sort buffer size in MySQL
October 25, 2010 By 8 Comments
… TABLE `sorttest` ( `data` char(30) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 and I inserted 100k … of MySQL. For the benchmark, I used an old PII 350 MHz computer, I think for such CPU bound …the expected correspondence between the time for the queries and the number of sort merge passes. …
Post: Interesting MySQL and PostgreSQL Benchmarks
November 30, 2006 By 20 Comments
… how MySQL or PostgreSQL was configured or about queries. Furthermore MySQL and PostgreSQL has a bit different implementations (ie SubQueries avoided for MySQL) so… if Innodb or MyISAM tables are used – it turns out Both are used in the benchmark. This is CPU bound benchmark with working…
