…_mutex in MySQL 5.1 and MySQL 5.5 is known: Bug report. In fact in MySQL 5.6 there are…For this we will take sysbench running only simple select PK queries against 48 tables, 5,000,000 rows … Mutex at 0x2b0ccc8 ‘&kernel_mutex’, lock var 1 waiters flag 0 –Thread 140370752542464 has waited at trx0trx.c…
Post: kernel_mutex problem. Or double throughput with single variable
December 2, 2011 By 17 Comments
Post: Group commit and real fsync
May 3, 2006 By 9 Comments
… interleave such funny way Group commit is broken in MySQL 5.0 if binary loging is enabled (as it enables XA) Certain… can be done for example by using SysBench: sysbench –test=fileio –file-fsync-freq=1 –file-num=1 –file-total-size=16384 –file-test… task I’m not sure it will be done in 5.0 Good if it is done in 5.1.
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 it works…-tables-count=25 –num-threads=5 run oltp.lua should understand most options that available for regular sysbench –test=oltp there are… 1), in this case N sbtest tables will be used. Additional parameter –oltp-secondary is taken from Mark Callaghan’s sysbench tree…
Post: MySQL versions shootout
October 10, 2011 By 6 Comments
… ran simple sysbench oltp read-write all data fits into memory workload. Versions in question: MySQL 4.1 MySQL 5.0 MySQL 5.1 (with built-in InnoDB) MySQL 5.1 with InnoDB-plugin MySQL 5.5 MySQL 5.6 All versions are… is better) threads MySQL 4.1 MySQL 5.0 MySQL 5.1 MySQL 5.1+InnoDB-plugin MySQL 5.5 MySQL 5.6.2 1 685.52 639.73 596.01…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
…5.5 do not solve all scalability problems even for read only workloads. Workloads which got a lot of attention such as Sysbench…like this: SELECT * FROM table WHERE deleted = 0 AND group_id IN (62715996, 62716592, 62717660, … have compared Percona Server 5.1.56-12.7 and Percona Server 5.5.11-20.2 with…
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
…through cache mode. We benchmarked the systems with sysbench multi-table and oltp read-write workload. All… two versions tested: Percona Server 5.1.57 – released and Percona Server 5.1.57 with the Group Commit Fix… enabled thread trx=1, No binlog trx=1, Binlog sync=0 trx=1, Binlog sync=1 1 382.39 371….
Post: MySQL 5.5-m2 scalability
February 28, 2010 By 17 Comments
…-m2 milestone, and I have a predition that MySQL-5.5 will be announced as GA on MySQL UC 2010 in … scalability characteristics we should expect from new release. I made sysbench oltp benchmarks on 10 mln rows (worth 2.5GB of… in InnoDB) sysbench command for reference: ./sysbench –test=oltp –oltp-table-size=10000000 –init-rng=1 –num-threads=$i –max-requests=0 –oltp-dist…
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
…sysbench –test=oltp –mysql-user=root –mysql-password=”" –oltp-table-size=1000000 –num-threads=32 –init-rng=on –max-requests=0…set global wsrep_causal_reads=1; Query OK, 0 rows affected (0.00 sec) When …Cluster related configuration # PXC Settings for Version: ‘5.5.29-55-log’ socket: ‘/var/run/…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… physical disk cache was disabled. The tool I used was sysbench 0.4.10 that came with this Ubuntu system. I have… spike in OS buffers during “prepare” phase of sysbench. I found out that sysbench would not honor –file-extra-flags during “prepare… in_prg {925} dm-0 462.1 34.1 7.7 0% 3.8 8.2 12.1 87.0 0.5 0% 0.0 0.7 93% 0 While number of operations…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…-socket=/tmp/mysql_sandbox5516.sock prepare [root@localhost msb_ps_5_5_15]# sysbench –test=oltp –db-driver=mysql –mysql-host=localhost –mysql… 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-requests=0 –oltp-dist-type=uniform –max…
