… not practical result as IO-bound case as intended. The throughput might depend on main memory size stronger rather than buffer…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… case (which may not be best for your application database throughput) will be more write latency into the cluster. The worst…
Comment: The write cache: Swap insanity tome III
April 22, 2013 By 5 Comments
We are using also: vm.dirty_expire_centisecs = 200 vm.dirty_writeback_centisecs = 100 to make the i/o throughput more stable. The default timeout is quite long and can cause (micro) stalls when flushing a huge amount of data to disk/controller at once.
Post: Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2
April 15, 2013 By
… for glibc and jemalloc allocators. Observations: = MySQL 5.5.30 – throughput of MySQL 5.5.30 with glibc is limited first…
Post: kernel_mutex problem. Or double throughput with single variable
December 2, 2011 By 17 Comments
… not all production systems can tolerate 2x times drop of throughput in the peak times. So what can be done there… we can improve to 145324 q/s , almost to peak throughput from first experiment. With innodb_sync_spin_loops=100 the… innodb_sync_spin_loops=200 for 1-1024 threads. Threads Throughput Throughput spin 200 1 11178.34 11288.42 2 27741.06…
Post: kernel_mutex problem cont. Or triple your throughput
December 2, 2011 By 10 Comments
…_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…
Post: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
… the transactions per second from them, then used the peak throughput as my target configuration. The benchmark was sysbench oltp complex… the system at the RDS server’s peak short-term throughput of 64 threads and see how things went in longer…
Post: RAID throughput on FusionIO
March 24, 2010 By 7 Comments
…/sec it is interesting how different software RAID modes affects throughput on FusionIO cards. In short conclusion, RAID10 modes really disappoint…. As expected RAID1 over 2 disks shows hit on write throughput comparing to single disk, but RAID10 modes over 4 disks…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
… results for each run, I will show different graphs: benchmark throughput – This is New Order Transactions per 10 seconds. dirty page…)Â to help increase throughput. Basically, by lowering innodb_max_dirty_pages_pct, you are killing your throughput. When you disable innodb_doublewrite, you can get stable throughput if you are lucky enough to…
Comment: Introducing new type of benchmark
March 11, 2012 By 16 Comments
… given intensity regardless of the system response rate (compare to throughput measuring benchmarks: they don’t issue another request until they…. 2. The max system throughput benchmark. Run as many parallel requests as needed to make the system throughput (TPS in the case… throughput tests 
. The max system throughput test gives the shared component processing time P – it’s the reciprocal of the max system throughput…
