…MySQL replication is single-thread too, and MySQL 5.6 brings some abilities of parallel replication but these apply only to some use…sysbench tables are used which means the lowest concurrency you can run with to compare apples to apples is 8. Running a comparable benchmark with…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…am going to use new the Dell PowerEdge R420 with two …I also show 5-minute moving averages to TokuDB…. However it will interesting how both InnoDB and …sysbench/insert-roll-2, command line to run: sysbench –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql…
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
…use was CentOS 6.3, and for the sysbench fileIO tests, the EXT4 filesystem was used…5 milliseconds; and at 128 write threads we have maximum throughput with latency just over 3ms. How well does it perform with MySQL… TPCC-MySQL test to the original FusionIO and the Intel i910 with assorted buffer…
Post: Is MySQL 5.6 slower than MySQL 5.5?
February 18, 2013 By 23 Comments
…with high concurrency compared to single thread ? Note Sysbench is simple enough it does not take advantage of any of new MySQL 5…MySQL 5.6 performance. Here is Sysbench command I used: root@dpe01:/mnt/data/sandboxes/msb_5_6_10# sysbench –test=oltp –mysql-socket=/tmp/mysql_sandbox5610.sock –mysql…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… vs MySQL 5.5 & the Star Schema Benchmark[/caption] So far most of the benchmarks posted about MySQL 5.6 use the sysbench OLTP workload. I wanted to… was to see how MySQL 5.6 performs out-of-the-box as compared to 5.5.30 with default settings. The non-default settings were tried to dig…
Post: Disaster: MySQL 5.5 Flushing
September 18, 2011 By 27 Comments
…sysbench multi-tables workload, with 20 tables, 10,000,000 rows each. Total database size ~58GB. MySQL version: 5.5…MySQL 5.5 and servers with big memory configuration I expect we will see this problem more and more often on production systems. How to…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
…MySQL solution. I’ve had some clients hitting performance limitations on standard EC2 servers with… to be dedicated to RDS, not shared with …with 3.25 ECUs each), 64-bit platform, High I/O Capacity.” I used sysbench‘s oltp benchmark, with…, say, every 5 seconds instead of…, we will see how the Amazon …
Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
November 26, 2012 By 4 Comments
…to keep my myq_gadgets toolkit up to date with what I consider is important to…0 14 1 5 19:17:…of how many parallel replication threads you could use…., this is a sysbench test what is …to 2.5k to start seeing replication conflicts regularly. Hopefully this is helpful for you to get an idea of how to…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
… so there should be plenty CPU to spare. We’re using Percona Server 5.5.15 for this test with buffer pool size of 512MB…/mysql_sandbox5516.sock prepare Running Sysbench and MySQLDump. Note we run them in the loop to see how result stabilizes. [root@localhost msb_ps_5_5_15]# sysbench –test=oltp –db-driver=mysql –num-threads=1 –max…
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
…MySQL Replication Latency in Percona XtraDB Cluster[/caption] I was curious to check how Percona XtraDB Cluster behaves when it comes to MySQL… 275.94 ms Avg: 5.06 ms …to DPE1 is blocked for some time. To check this idea I decided to use the sysbench script with very simple point update queries to…
