… start to degrade. If you’re just setting up a test environment to get familiar with the technology, certainly there’s…
Comment: MySQL 5.6.7-RC in tpcc-mysql benchmark
June 3, 2013 By 22 Comments
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
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… #2 on the picture below, following various scenarios: For these tests, all servers are running on 127.0.0.1 with…
Comment: ZFS on Linux and MySQL
May 29, 2013 By 17 Comments
Nice article! Actually I ran into performance issues during testing ZFS on Linux, it’s true it was some months …
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… level was less than half of xfs for the tpcc test and that’s maybe just normal. We didn’t try…
Comment: How to calculate a good InnoDB log file size
May 22, 2013 By 38 Comments
… not repeatable today: (despite the fact that i ran this test several times over the course of ten minutes yesterday, maybe…
Comment: Derived Tables and Views Performance
May 21, 2013 By 16 Comments
…=mysql_connect(’127.0.0.1′,’root’,”); mysql_select_db(‘test‘,$mysql); function display_menu($parent, $level) { $result = mysql_query(“SELECT…
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
… in my previous benchmark run. A small handful of additional tests were also performed using the Cisco UCS C250. The operating… take a look at the data. With the sysbench fileIO test in asynchronous mode, read performance is an extremely steady 3202MiB… quick and handily outperforms the other cards that it was tested against. For example, in the graph below we compare the…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… 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…
