… my testing I discovered that innodb_old_blocks_time had an effect on performance of the benchmark. …cold for the cold test. All tests were done with no concurrency. The hardware for this test was provided by… performance of InnoDB significantly during the hot run, as hash indexes are faster than a …
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… TokuDB. I have a particular workload I’m interested in testing – it is an insert-intensive workload (which is TokuDB’s… repeat this benchmark, the sysbench code is on Launchpad lp:~vadim-tk/sysbench/insert-roll-2, command line to run: sysbench –test=insert….sock user=root skip-grant-tables TokuDB-related options are all defaults, as I understand from documentation TokuDB comes with good…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… point the performance is going to level off since these tests were all run for 2 hours anyway, but I think the overall… the clear winner. Base MySQL & Benchmark Configuration All benchmarks were conducted with the following: sysbench –num-threads=32 –test=tests/db/oltp.lua –oltp_tables…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… fairly consistent with our original post across all test combinations. The details are below. Here is… Results: First of all, we used a smaller dataset for this benchmarks round, since reportedly …-index-updates=0 run POINT_SELECT + UPDATE QPS test sysbench –num-threads=<1..1024> –test=oltp.lua…
Post: Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2
April 15, 2013 By
… in case of many small allocations and allows to free all blocks from specific heap at once. But in the case… fulfill it needs. To demonstrate the difference we have run sysbench POINT_SELECT test for glibc and jemalloc allocators. Observations: = MySQL 5… MySQL 5.5.30 with glibc is limited first of all by inefficiency of transaction list handling (see our previous post…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… is necessary when running a large stream of queries. Benchmarks We benchmarked with slow query logs captured from our production systems. We restored a production database backup to our test…usage is 2 orders of magnitude. All graphs looked like this (we did …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… shipped with the libjemalloc library. Benchmark showing the impact of memory …. Bug fixed #1104977 (Ignacio Nin). Running the DDL statement while variable… for MySQL would re-create the test database when using rpm on …optimize-keys and –no-data options, all secondary key definitions would be lost….
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…upgrading was configured on machines with running database servers. We’ve now… shipped with the libjemalloc library. Benchmark showing the impact of memory … for MySQL would re-create the test database when using rpm on …optimize-keys and –no-data options, all secondary key definitions would be lost….
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
… affects performance of full table scan. Not all queries are going to be affected same way…bad as we show here. Benchmarks were done using this script: The benchmark run with following simple shell script:…is a lot of overhead. During this last test box felt really sluggish responding 10+ seconds …
Post: Percona testing: Quick test clusters with kewpie!
January 13, 2012 By Leave a Comment
…/workdir/bot0/var_s1/run/my.pid 20120113-132229 INFO Stopping all running servers… Alternately, you can just let the tests run to ensure some basic functionality. I’ll be writing more about these tests…
