… posts and articles look at MySQL performance starting with certain concurrency as the low point. For example, MySQL 5.6 DBA and Developer… on how your production will be impacted. Think about, for example, a system that is slower at low concurrency but a… picture. In terms of benchmarks, Mark Callaghan published an example where 8 sysbench tables are used which means the lowest concurrency you…
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….6), as memory allocation occurs under that mutex. See an example of such an issue. Related bugs: BUG#54982, BUG#49169… we have run sysbench POINT_SELECT test for glibc and jemalloc allocators. Observations: = MySQL 5.5.30 – throughput of MySQL 5.5.30…
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… solely at vCache performance under some different sets of MySQL configuration parameters. For example, given that the front-end device is a… be declared the clear winner. Base MySQL & Benchmark Configuration All benchmarks were conducted with the following: sysbench –num-threads=32 –test=tests…
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… against. For example, in the graph below we compare the performance of the P320h on a standard TPCC-MySQL test to the… this graph we look at the card’s performance on sysbench OLTP: It is worth noting here that EXT4 outperforms XFS…
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
…do it with Sysbench, for example: sysbench –test=oltp –oltp-test-mode=nontrx –oltp-nontrx-mode=update_key –mysql-user=root –mysql-password=”" –oltp-…dpe01:/etc/mysql# sysbench –test=oltp –oltp-auto-inc=off –oltp-test-mode=nontrx –oltp-nontrx-mode=update_key –mysql-user=root –mysql-…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
…Relational Database Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance… to measure the single-threaded insert throughput as sysbench ran the “prepare” phase and filled the table… B-Tree inserts (see InnoDB vs TokuDB for example). This doesn’t mean that we weren’t…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
… which got a lot of attention such as Sysbench and DBT2/TPC-C scale pretty well a…results most relevant for your situation. In this example I spotted the query pattern responsible for …do_select,JOIN::exec,mysql_sel ect,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_…
Post: SysBench - benchmark tool
August 18, 2006 By 20 Comments
… as sysbench is one of software for my everyday use. For example, SUN published their Solaris vs RedHat stuff based on sysbench‘s results (Peter and me provided performance consutling for this publishing). Sysbench… and queries. 0.5 should be realesed soon. Originally Sysbench supported only MySQL, but later Oracle and PostgreSQL (and deviations, e.g…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…here is applicable for any kind of virtualization technology (for example VirtualBox). The goal is to give step by step … # sysbench –test=oltp –db-driver=mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql-password…
Post: Recovery deleted ibdata1
August 10, 2012 By 9 Comments
… I will delete /var/lib/mysql/ib* files, while sysbench generates read/write activity: Screen0: root@localhost:~# sysbench –num-threads=16 –max-requests…-time=3600 –mysql-user=root run sysbench 0.4.12: multi-threaded system evaluation benchmark No DB drivers specified, using mysql Running the… wasn’t something that requires a purge operation (SELECT for example) Trx id counter will be bigger. In that case at…
