… few words about the hardware: I am going to use new the Dell PowerEdge R420 with two Intel(R) Xeon(R… will use two different schemas. The first schema is from sysbench, and the table looks like: CREATE TABLE sbtest$I ( id… this benchmark, the sysbench code is on Launchpad lp:~vadim-tk/sysbench/insert-roll-2, command line to run: sysbench –test=insert_roll…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
… would execute read/write queries against a 20M rows table: sysbench –test=oltp –oltp-table-size=20000000 –mysql-table-engine=innodb… buffer pool was completely warmed up with the dataset that sysbench will be using entirely in memory. Furthermore I filled up… results showing the QPS over 5 second periods with the new DROP TABLE implementation (MysQL version >= 5.5.23) and DROP…
Post: Virident tachIOn: New player on Flash PCI-E cards market
June 15, 2010 By 19 Comments
… specification) Now to most interesting part – performance numbers. I took sysbench fileio benchmark with 16KB blocksize to see what maximal performance… have aligned IO requests) and mounted with nobarrier option Benchmark: sysbench fileio on 100GB file, 16KB blocksize The raw results are… design with replaceable individual flash modules, I think it establishes new high-end standard for flash devices With single card you…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… used new sysbench with Lua scripting language, so all queries were scripted for sysbench. New sysbench you can get from svn repository: svn co https://sysbench.svn.sourceforge.net/svnroot/sysbench The used LUA script for sysbench http…
Post: Introducing new type of benchmark
February 25, 2012 By 16 Comments
… result is also represents the throughput (transactions per second in sysbench; NewOrder transactions Per Minute in tpcc-mysql). However, like Mark… a prototype based on sysbench. It is there lp:~vadim-tk/sysbench/inj-rate/. It works like a regular sysbench, but you need… we have an usual sysbench setup, and we target an arrival rate as 3000 transactions per second (regular sysbench transactions). We vary…
Post: Quality Assurance: Percona Server Development Now Monitored by Automated Sysbench Performance Regression Checks!
October 23, 2012 By Leave a Comment
Continuous integration of new features and bug fixes is great – but what if a … monitoring in place: Live Percona Server Performance Regression Checks Using Sysbench While systems are being optimized, the above is a live… verifying the performance of the current build. Technical details: two Sysbench runs (OLTP read only & OLTP read/write) are executed for…
Post: New distribution of random generator for sysbench - Zipf
May 9, 2012 By 3 Comments
Sysbench has three distribution for random numbers: uniform, special and gaussian. … implemented Zipf for sysbench, right now it is in a separate tree https://code.launchpad.net/~vadim-tk/sysbench/zipf-distribution, you…
Post: Sysbench evaluation of iSCSI performance
July 6, 2006 By 2 Comments
… posted pretty interesting post about iSCSI vs SCSI performance using SysBench. This is nice to finally see some iSCSI benchmarks done… hardware available for tests. It is also good to see Sysbench being used, as It is developed by our team, even… first version of this tool myself, for performance research (The new version was complete rewrite). The problem I see in this…
Post: Query Response time histogram - new feature in Percona Server
July 11, 2010 By 11 Comments
… software engineer Oleg Tsarev implemented this feature. The feature adds new INFORMATION_SCHEMA table QUERY_RESPONSE_TIME ( full docs are on… affects response time. There are histograms and pie charts for sysbench oltp runs for 1, 32 and 128 concurrent threads 1…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…-client percona-xtrabackup Install haproxy and sysbench on the client node. # yum -y install haproxy sysbench After installing everything, let’s configure… (security purposes) per_source = UNLIMITED } Also, we should add the new service to /etc/services. mysqlchk 9200/tcp # mysqlchk Clustercheck will…. Next we will try to use the cluster with sysbench. We will use sysbench from the EPEL repo. First, let’s create…
