…_concurrency=0,4,8,16,32,64 innodb_thread_concurrency Throughput 0 68369.02 4 137999.96 8 194537.48 16… not almost 3x times ( 194537÷68369 = 2.8). The best throughput is with innodb_thread_concurrency=8. So now let’s…
Comment: kernel_mutex problem. Or double throughput with single variable
December 2, 2011 By 17 Comments
I posted followup with innodb_thread_concurrency http://www.mysqlperformanceblog.com/2011/12/02/kernel_mutex-problem-cont-or-triple-your-throughput/
Post: Clustrix benchmarks under tpcc-mysql workload
October 26, 2011 By 9 Comments
… additional nodes. In fact the throughput improves more than by 2 times (3 times) by doubling (tripling) amount of nodes. This is…-tolerant. So looking on the results, Clustrix might be not your first choice for single-thread or low concurrency workloads from… workloads, Clustrix provides great performance, and if you need better throughput, just add more nodes. The other factor which would be…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…storage but also downsides – SAN typically has better throughput (because of larger amount of drives) but …for durable transactions the log write latency is triple important compared to other database systems. MySQL …in most cases and is especially good if your IO needs are predictable, like you need …
Post: When to use Hardware upgrade instead of Software Optimization
December 5, 2008 By 5 Comments
…upgrade as the first thing when you can triple performance by simple my.cnf change. Well …application level to be efficient. What is exactly your goal with hardware upgrade ? Same as with …faster. The goal in the application performance – making throughput better, query faster should lead you to goals…
