…on an interface every second. I’m running a sysbench test on one node and measuring the outbound (UP) …mysql]# service mysql stop [root@node1 mysql]# service mysql stop [root@node1 mysql]# service mysql start –wsrep_cluster_address=gcomm:// [root@node2 mysql]# service mysql start [root@node3 mysql…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…sysbench test results. Disclosure: The research and testing conducted for this post were sponsored by Virident. First, some background information. All tests…–max-requests=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…: single SELECT queries doing PRIMARY KEY lookups (aka QPS sysbench mode); same MySQL queries executed inside single-statement transactions (TPS mode, see…$i WHERE k like ‘%0%’ SysBench-0.5/lua: POINT_SELECT QPS test sysbench –num-threads=<1..1024> –test=oltp.lua –oltp_tables_count…
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
… system in use was CentOS 6.3, and for the sysbench fileIO tests, the EXT4 filesystem was used. The card itself is… let’s take a look at the data. With the sysbench fileIO test in asynchronous mode, read performance is an extremely steady… was tested against. For example, in the graph below we compare the performance of the P320h on a standard TPCC-MySQL test to…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… this benchmark, the sysbench code is on Launchpad lp:~vadim-tk/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: Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2
April 15, 2013 By
… is another issue in InnoDB transaction processing that notably affects MySQL performance – for every transaction InnoDB creates a read view and… difference we have run sysbench POINT_SELECT test for glibc and jemalloc allocators. Observations: = MySQL 5.5.30 – throughput of MySQL 5.5.30…
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
… can do it with Sysbench, for example: sysbench –test=oltp –oltp-test-mode=nontrx –oltp-nontrx-mode=update_key –mysql-user=root –mysql-password=”" –oltp-table…: root@dpe01:/etc/mysql# sysbench –test=oltp –oltp-auto-inc=off –oltp-test-mode=nontrx –oltp-nontrx-mode=update_key –mysql-user=root –mysql-password=”" –oltp…
Post: Sysbench with support of multi-tables workload
April 29, 2011 By 4 Comments
… use –test=tests/db/oltp.lua to run OLTP test i.e. prepare ./sysbench –test=tests/db/oltp.lua –oltp-tables-count=25 prepare run: ./sysbench –test=tests/db….lua so instead of ./sysbench –test=tests/db/oltp.lua –oltp-tables-count=25 prepare you may use ./sysbench –test=tests/db/parallel_prepare.lua –oltp…
Post: Is MySQL 5.6 slower than MySQL 5.5?
February 18, 2013 By 23 Comments
… 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-user=msandbox_rw –mysql…
Post: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
… important for MySQL. To prepare small 128MB single file working set we can use the following command: [root@DB10 sysbench]# ./sysbench –test=fileio –max…-threads=64 –file-test-mode=rndwr cleanup sysbench v0.4.8: multi-threaded system evaluation benchmark Removing test files… [root@DB10 sysbench]# ./sysbench –test=fileio –max…
