…’s tests Percona Server scalability is somewhere in between of MySQL 5.5 and MySQL 5.6. In order … tests on Dell PowerEdge R720 box and varied cpu combinations with taskset. The following chart shows … count(*) from sbtest$i WHERE k like ‘%0%’ SysBench-0.5/lua: POINT_SELECT QPS test sysbench –num-…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… of their CPU efficiently in TPC-C like Workload. We did it couple of weeks ago so MySQL 5.0.67, MySQL 5.1… than MySQL 5.0 with two cores and just 2% slower with 8 cores, thus showing a bit better scalability. MySQL 5.1 plugin (compiled in) is further 3% slower compared to MySQL 5.1 with 2 cores…
Post: Call for opinions: Do we need MySQL 5.0 with MySQL 5.4 performance
April 29, 2009 By 12 Comments
…, additional undo slots, profiling, etc) and integrate it with MySQL 5.0 ? How useful would you find it ? Currently we see a… workload, which consists of the queries running just fine on 5.0. 5.4 especially introduces optimizer changes which besides positive impact for… and fast index build. Innodb plugin 1.0.3 got some Google changes for CPU scalability but not IO patches. I expected Innodb…
Post: MyISAM Scalability and Innodb, Falcon Benchmarks
October 12, 2007 By 10 Comments
… not escalate MyISAM scalability question. This time working on the customer system we figured out that box with 1 CPU Core is… purposes. The benchmark shows following results for MyISAM using MySQL 5.0.45 run on 4 Core System: Threads queries/sec 1… details. Note however even in this case scalability is far from perfect giving only 1.5 times gain with. The solution we…
Post: MySQL/Innodb scalability tests after fix
January 3, 2007 By 1 Comment
… concurrency. The results for MySQL 5.0.20a vs 5.0.32bk are also extremely interesting: 1) For single CPU 5.0.32 is actually slower on… too large to only map it to Innodb scalability patch. 2) Speedup for 5.0.32 for large number of CPUs (2x quad… larger than for 5.0.20 – some 630 vs 540 tps. 4) The bad news are – we still have massive scalability drop with…
Post: table_cache negative scalability
November 16, 2009 By 23 Comments
…the LRU for cache management is classics and there are scalable algorithms to deal with it. I would expect Monty…slow down. We can see the load becomes very CPU bound in this case and it looks like …5.0.85. So the problem is not fixed in MySQL 5.1, lets see how MySQL 5.4 behaves. MySQL 5.4.2 MySQL 5…
Post: XtraDB storage engine release 1.0.2-3 (Spring edition) codename Sapporo
March 2, 2009 By 10 Comments
… MySQL 5.1.31 Scalability fix — ability to use several rollback segments Increasing the number of rseg may be helpful for CPU scale of write-intentional workloads. See benchmark results. Scalability fix — replaced page_hash mutex…, the group commit of InnoDB doesn’t work after MySQL 5.0 with binlog. We pretend to fix this and added “innodb…
Post: Bug fix of InnoDB scalability problem
November 14, 2006 By 13 Comments
… it in my hands. Let me refresh results with MySQL 5.0.27 (without bugfix): select sql_calc_found_rows * from b… still using 4-CPU box and expecting the same time of execution for each thread). The results with 5.0.30-bk: 1 thread: 19 sec 4 threads: 28 sec 29 sec 39 sec 41 sec Great improvement! But scalablity…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… these as plugins instead of patches. 2. Be Scalable I’d like to see MySQL Scaling to … queries well, being able to use only one CPU effectively on single node and no true federation support…m saying about XA which were released in MySQL 5.0 without consistent work with MySQL close Partner – Innobase …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… you assess current state of Innodb scalability with multiple threads and multiple concurrent transactions ? HT: The scalability in my opinion is ‘mediocre…: Users have reported lots of InnoDB scalability problems from multicore CPU‘s. The most recent 5.0.xx behave better. We will continue the…
