… gave me a chance to run some benchmarks on 24-core (intel cpu based) server, and I could not miss it and ran few CPU-bound tasks there. The goal of benchmarks was investigation of InnoDB-plugin and XtraDB scalability in CPU-bound load. CPU specification…
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 insert… Yasufumi just made patch to enable it. I rerun benchmarks on different server (Dell PowerEdge R900, 16-way Intel Xeon, 32GB of…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 3
October 19, 2009 By 25 Comments
… some scalability benchmarks, my server resources are rather limited but I thought I should try throwing more threads and work at the server until… going to try and continue this series by exploring and benchmarking other NOSQL options and comparing them to database based solutions…
Post: MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)
December 21, 2010 By 11 Comments
… are in our Benchmarks Wiki. Here are the graphs: 13G innodb_buffer_pool_size: In this case, both servers show a straightÂ… Disabled read-ahead logic: innodb_read_ahead=none Buffer pool scalability fixes (different from innodb_buffer_pool_instances) We recognize that… performance, and we tune Percona Server to get the most from such hardware. Actually, from my benchmarks, I see that the Virident…
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 …MySQL Sandbox helped me to test this with different servers easily. I did test on CentOS 5.3, … writes to the disk during this read-only benchmark. Why ? Because for MyISAM tables table header has …
Post: Clustrix benchmarks under tpcc-mysql workload
October 26, 2011 By 9 Comments
… Fusion-io card, and on SuperMicro server powered by 7 Intel SSD 320 cards (this server is equal to hardware that Clustrix…, more is better) So my conclusions from this benchmark: Clustrix shows very good scalability in the high concurrent workload by adding additional…
Post: Modeling InnoDB Scalability on Multi-Core Servers
January 26, 2011 By 11 Comments
… modeling of InnoDB’s scalability as the number of cores in the server increases. Vadim runs lots of benchmarks that measure what happens… Universal Scalability Law modeling, which can predict both software and hardware scalability, depending on how it is used. In brief, the benchmarks are sysbench’s read-only and read-write tests, and the server…
Post: Impact of memory allocators on MySQL performance
July 5, 2012 By 11 Comments
… CPU/RAM resources. Efficient memory allocator should help to improve scalability, increase throughput and keep memory footprint under the control. In… check impact of several memory allocators on the performance/scalability of MySQL server in the read-only workloads. For my testing i…/128/256/512/1024/1536 stop server/get RSS/VSZ size of mysqld The best throughput/scalability we have with lockless/jemalloc…
Post: Announcing Percona Server for MySQL 5.1.68 -14.5
March 15, 2013 By Leave a Comment
…-source solution, Percona Server for MySQL is an enhanced drop-in replacement for MySQL, offering breakthrough performance, scalability, features, …database server. Compare Percona Server to MySQL. Performance Percona Server‘s performance is exceptional. Not only is it faster, but in benchmarking,…
Comment: T2000 CPU Performance - Watch out
May 1, 2008 By 12 Comments
…, “Sun” is not, to my knowledge, “aggressively pushing T2000 as Scalable MySQL Platforms”. Could you provide a reference? That’s not…. Just have a look here: http://www.sun.com/servers/coolthreads/benchmarks/index.jsp What happens when you have a lot of… an acceptable timeframe (i.e. under 1sec, the way many benchmarks test) will drop. What happens when you have a lot…
