… 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: 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… of read-only transactions become obvious. In the following test sysbench does 9 primary key SELECTs followed by a PK UPDATE…(*) from sbtest$i WHERE k like ‘%0%’ SysBench-0.5/lua: POINT_SELECT QPS test sysbench –num-threads=<1..1024> –test=oltp…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… to the following kinds of transactions: MySQL transactions started with START TRANSACTION READ ONLY MySQL transactions created by a non-locking SELECT… perfect case for read-only optimization in MySQL 5.6 and as you can see MySQL 5.6 shines in this benchmark… when the read-only optimization in MySQL 5.6 does not kick in. The default sysbench POINT_SELECT mode benchmark does PK…
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… scalability problems (like allocator from glibc) this will notably slowdown MySQL-transaction creation and many threads will get stuck on glibc… we have run sysbench POINT_SELECT test for glibc and jemalloc allocators. Observations: = MySQL 5.5.30 – throughput of MySQL 5.5.30…
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
… a number of recent blog posts and articles look at MySQL performance starting with certain concurrency as the low point. For… jobs are written to be single-threaded. MySQL replication is single-thread too, and MySQL 5.6 brings some abilities of parallel… terms of benchmarks, Mark Callaghan published an example where 8 sysbench tables are used which means the lowest concurrency you can…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… both systems. The benchmark tool used was sysbench 0.5 and the version of MySQL used was Percona Server 5.5.30… outperforms FlashCache by over 2x, on average. Looking just at sysbench reads, vCache with time-based flushing consistently hit about 27000… be declared the clear winner. Base MySQL & Benchmark Configuration All benchmarks were conducted with the following: sysbench –num-threads=32 –test=tests…
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_table_engine=tokudb…
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
… let’s take a look at the data. With the sysbench fileIO test in asynchronous mode, read performance is an extremely… latency just over 3ms. How well does it perform with MySQL? Exact results vary, depending upon the usual factors (read/write… this graph we look at the card’s performance on sysbench OLTP: It is worth noting here that EXT4 outperforms XFS…
Comment: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… (i.e. the –skip-trx option to sysbench). The 2nd one is the default sysbench mode, i.e. “BEGIN; SELECT …; COMMIT” which…. 2) There was no fix from Percona at the time MySQL bug #49169 was closed. However, as you can see from…
Post: Sysbench with support of multi-tables workload
April 29, 2011 By 4 Comments
… is available from launchpad source tree lp:sysbench . This is set of LUA scripts for sysbench 0.5 ( it supports scripting), and… test i.e. prepare ./sysbench –test=tests/db/oltp.lua –oltp-tables-count=25 prepare run: ./sysbench –test=tests/db/oltp.lua….lua so instead of ./sysbench –test=tests/db/oltp.lua –oltp-tables-count=25 prepare you may use ./sysbench –test=tests/db…
