… today I decided to take a closer look at SpecJAppServer benchmarks results which were published by PostgreSQL recently and which as… hardware is different – MySQL benchmark use Sun Fire X4100 available in Nov 2005 using Opteron 285 CPU, PostgreSQL benchmarks use Sun Fire X4200… issue is using MySQL 5.0.27 which has Innodb scalability issues, which were a lot improved in 5.0.37…
Post: Percona Server scalability on multi-cores server
September 29, 2010 By 14 Comments
…, powered by two Intel Westmere CPUs (X5670 @ 2.93GHz). Each CPU has 6 cores and 12 threads. The most amazing part… on this hardware, and you can expect a series of benchmarks. An especially interesting topic is what we can get from… and ran the sysbench oltp read-only and read-write benchmarks using from 1 to 32 threads. The database size was…
Post: table_cache negative scalability
November 16, 2009 By 23 Comments
… LRU for cache management is classics and there are scalable algorithms to deal with it. I would expect …significant writes to the disk during this read-only benchmark. Why ? Because for MyISAM tables table header has … down. We can see the load becomes very CPU bound in this case and it looks like …
Post: Performance Schema overhead
April 25, 2011 By 22 Comments
As continuation of my CPU benchmarks it is interesting to see what is scalability limitation in MySQL 5.6.2, and I am… PERFORMANCE SCHEMA. So I am going to run the same benchmarks (sysbench read-only and read-write) as in previous post…, why Performance Schema can’t do the same ? (Disclaimer: This benchmark is sponsored by Well Know Social Network, and they are…
Post: MyISAM Scalability and Innodb, Falcon Benchmarks
October 12, 2007 By 10 Comments
… 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 scalability question. This time working… more queries per second than identical box, but with 4 CPU Cores. The main query which showed this problem was similar…
Post: T2000 CPU Performance - Watch out
May 1, 2008 By 12 Comments
… aggressively pushing T2000 as Scalable MySQL Platforms, and indeed it is Scalable in terms of high concurrency workloads – it…of purely CPU consuming “Benchmark” function for 2.6Ghz Intel Xeon vs T2000: # XEON mysql> select benchmark(100000000,1+2); +————————–+ | benchmark(100000000…
Post: Interesting MySQL and PostgreSQL Benchmarks
November 30, 2006 By 20 Comments
I had found pile of MySQL and PostgreSQL benchmarks on various platforms which I have not seen before. Very … are used in the benchmark. This is CPU bound benchmark with working set fitting in memory. MySQL and PostrgreSQL Scalability on Xeon Woodcrest, Opteron… less with increased concurrency. Note: I have not validated these benchmarks and as I already mentioned they do not have full…
Post: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 7, 2010 By 48 Comments
….com/docs/wiki/benchmark:ssb:start, and graph is below. There couple comments from me. InfoBright was fully 1 CPU bound during…. I think the problem that engine can use only single cpu/core is getting significant limitation for them. For query 3… scalability on InfiniDB’s blog http://infinidb.org/infinidb-blog/mysql-parallel-query-processing-of-ssb-queries-via-infinidb-.html SSB benchmark…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 3
October 19, 2009 By 25 Comments
… interesting architectures in the future. So lets look at some scalability benchmarks, my server resources are rather limited but I thought I… pegged. At 128 threads I was pegging out my CPU across the board. Also interesting is I started to… going to try and continue this series by exploring and benchmarking other NOSQL options and comparing them to database based solutions…
Post: Impact of memory allocators on MySQL performance
July 5, 2012 By 11 Comments
… important for the proper utilization of CPU/RAM resources. Efficient memory allocator should help to improve scalability, increase throughput and keep memory… allocators based on new malloc. Along with the best throughput/scalability runs with tcmalloc also demonstrate best response time (30-50…
