… on MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance… MySQL client to abort the connections on terminal resize. Bug fixed #925343 (Sergei Glushchenko). Percona Server for MySQL would re-create the test…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… second for MySQL 5.6.11. Conclusion: In CPU-bounds case MySQL performs quite well, though we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL still has performance issues…=100000001 -c config/MyConfig.properties -l command line to run test for 10x dataset: ./bin/linkbench -D requesters=64 -D dbid…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… on MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance… MySQL client to abort the connections on terminal resize. Bug fixed #925343 (Sergei Glushchenko). Percona Server for MySQL would re-create the test…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
… Cluster (PXC) for MySQL is a hot thing right now and some users jump right in without enough testing. Consequently, they’re…), table without PK imposes an additional overhead, and because cluster performance is somewhat dependent on the slowest node – this overhead can…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… vs. vCache – MySQL parameter testing The first test was designed to look solely at vCache performance under some different sets of MySQL configuration parameters. For… FlashCache performance versus that of vCache, and I also included a “no cache” test run as well using the base HDD MySQL configuration…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… results in our tests. In Dimitri’s tests Percona Server scalability is somewhere in between of MySQL 5.5 and MySQL 5.6. In order to understand more about differences between results we have rerun tests on… other tests. There is some minor variation, e.g. in the first two cases Percona Server performance is even slightly ahead of MySQL…
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
… the sysbench fileIO test in asynchronous mode, read performance is an extremely steady 3202MiB/sec with almost no deviation. Write performance is also… throughput with latency just over 3ms. How well does it perform with MySQL? Exact results vary, depending upon the usual factors (read… it was tested against. For example, in the graph below we compare the performance of the P320h on a standard TPCC-MySQL test to…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… does NOT set an lower bound on performance, only a upper bound. The best performance you can expect is modifying a given… update much faster. I see this tuning very frequently for “performance” reasons when data durability isn’t as crucial. This is…-alone MySQL Innodb with asynchronous slaves. We may not think about the tradeoffs, but we’re making them (anyone obsessively testing slave…
Comment: Virident vCache vs. FlashCache: Part 1
May 17, 2013 By 3 Comments
… only 500GB. What are my options for achieving the best performance? I could by a ton of RAM, but that isn… flash For example, see http://www.ssdperformanceblog.com/2013/04/testing-the-micron-p320h/ – the card referenced there is a Micron… card, not Virident, but there’s a comparison in TPCC-MySQL performance between that card and a traditional SSD – the PCIe card…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… I wanted to compare InnoDB performance vs TokuDB. I have a particular workload I’m interested in testing – it is an insert… to run: sysbench –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp… = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-related options are…
