… post, we’ll look at some sysbench test results. Disclosure: The research and testing conducted for this post were sponsored by Virident… look at some numbers. vCache vs. vCache – MySQL parameter testing The first test was designed to look solely at vCache performance under… benchmarks were conducted with the following: sysbench –num-threads=32 –test=tests/db/oltp.lua –oltp_tables_count=32 \ –oltp-table-size…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… in Percona Server showed fairly close results in our tests. In Dimitri’s tests Percona Server scalability is somewhere in between of… 1M rows each (about 2.1GB) for his tests, while in our original tests we used a much larger one, 16 tables…-index-updates=0 run POINT_SELECT + UPDATE QPS test sysbench –num-threads=<1..1024> –test=oltp.lua –oltp_tables_count=8 –oltp…
Comment: Using Flexviews - part two, change data capture
April 13, 2013 By 26 Comments
… | 1954 if you try to write the query: DELETE FROM test.demo WHERE c3=1960; Flexviews produces this query: INSERT INTO `flexviews`.`test_demo` VALUES (-1, @fv_uow_id, 999,242,3,6….”,”; } Now, Flexviews will produce a new query: INSERT INTO `flexviews`.`test_demo` VALUES (-1, @fv_uow_id, 999,242,3,6…
Comment: CVE-2012-4414 strikes back in MySQL 5.5.29 (and what we're doing in Percona Server 5.5.29)
May 1, 2013 By 4 Comments
… that Oracle MySQL 5.5.31 passes the test accept for the case “*** Test truncation of long SET expression in LOAD DATA ***”. I do not think “*** Test truncation of long SET expression in LOAD DATA ***” is a…
Comment: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…-disk RAID 10 of fairly standard SAS drives. Your proposed test scenario is an interesting one, but for purposes of this… be a lot closer to the 10% dirty page ratio test.
Comment: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
I am confused about how this tests flashcache. The use case for flashcache is to put some … (78gb) and the flash device is huge (2.2tb). To test flashcache I think you should use a database much larger…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 9, 2013 By 32 Comments
… INSERT benchmark What did you mean by that? In your tests you ran many INSERT .. ON DUPLICATE KEY UPDATE queries. That… to work pretty well (better than InnoDB in the 2nd test) for these upsert queries. So why did you say the…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 9, 2013 By 32 Comments
Thanks Vadim, I did the test on 5.6 and load data infile concurrently results for … key worth distribution, memory or CPU as repeating the same test on uncompressed table scale as expected. Mark did you cover…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… workloads in the CPU and IO-bound cases. For this test we used a PowerEdge R720 box with a fast PCI…=100000001 -c config/MyConfig.properties -l command line to run test for 10x dataset: ./bin/linkbench -D requesters=64 -D dbid…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 8, 2013 By 32 Comments
… supports an upsert optimization that is applicable to your second test. Typically, the “insert on dup key update” statements do a…). Let me know if you would like to run this test.
