Hy, I’m new to TPC-C benchmarking and i would like to know how and what are the steps for testing MySQL with TPC-C benchmark. My goal is to compare VoltDB and MySQL under TPC-C benchmark. Thanks
Comment: ZFS on Linux and MySQL
May 28, 2013 By 17 Comments
… Solaris at least. @Raghavendra: b) I used the latest zfsonlinux. c) metadata checksum is way short than full data checksum. d…
Comment: ZFS on Linux and MySQL
May 27, 2013 By 17 Comments
… if btrfs (from 3.9) and zfsonlinux (latest) are benchmarked. c) Regarding integrity, XFS from 3.10 is going to have…
Post: Percona MySQL University @Portland: June 17
May 22, 2013 By 1 Comment
… at the inaugural Percona MySQL University event in Raleigh, N.C. on Jan. 29, 2013.[/caption] Portland is a well-recognized…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… UNSIGNED NOT NULL, k INTEGER UNSIGNED DEFAULT ’0′ NOT NULL, c CHAR(120) DEFAULT ” NOT NULL, pad CHAR(60) DEFAULT ” NOT… increasing ID $K=rand(0,10000) // distributed by pareto distribution $C, $PAD = random_string() BEGIN INSERT INTO sbtest (id, k, c, pad) VALUES ($ID, $K, $C, $PAD); INSERT INTO sbtest_r10 (id, k) VALUES…
Comment: How to Monitor MySQL with Percona's Nagios Plugins
May 20, 2013 By 11 Comments
ok nevermind got my answer -x Uptime -C ‘<' -c 10
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
… TABLE sql statement: sub cname ($) { my $c=shift; my $name=”"; while($c > 0) { my $n=$c%36; $name.=chr(ord(’0′)+$n) if… < 10; $name.=chr(ord('a')+($n-10)) if $n >= 10; $c= int $c/36; } return $name } my $sql= “CREATE TABLE t (“; foreach… < 10; $name.=chr(ord('a')+($n-10)) if $n >= 10; $c= int $c/36; } $name.=’0′ foreach(length $name .. shift); return $name…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… work that I’d done with this Virident card (configuration C): innodb_io_capacity = 30000 innodb_adaptive_flushing_method = keep_average… numbers are roughly identical for all four configurations, but configuration C avoids the spikes and produces a very constant and predictable… vs. FlashCache – the basics Once I’d determined that configuration C appeared to produce the most optimal results, I moved on…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… MySQL 5.5.30 top mutex is &doublewrite->mutex: trx0sys.c:196. And most likely this symptom is related to BUG… user=root -D port=3306 -D password= -D maxid1=100000001 -c config/MyConfig.properties -l command line to run test for… user=root -D port=3306 -D password= -D maxid1=100000001 -c config/MyConfig.properties -csvstats final-stats.csv -csvstream streaming-stats…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 8, 2013 By 32 Comments
… is amortized. TokuDB currently detected update expressions like x=x+c, where c is a constant. We could support x=x+value…
