… series on the Star Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both… presents some unique challenge to the database optimizer. The SSB benchmark consists of four sets of queries. Each set is known… than MyISAM when the database is cold, but uses less CPU time when the database is hot. I am only speculating…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… to setup and run this benchmark, can be found here. We decided to run this benchmark for MySQL Server 5.5.30, 5… for MySQL 5.6.11. Conclusion: In CPU-bounds case MySQL performs quite well, though we can see small performance drop in MySQL 5… cases MySQL still has performance issues around mutexes and Percona Server shows much better results Configurations and how to run benchmark: [mysqld…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…tried to answer that question by retrying benchmarks on various combinations of hardware and … Dell PowerEdge R720 box and varied cpu combinations with taskset. The following chart…percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… PowerEdge R420 with two Intel(R) Xeon(R) CPU E5-2450 0 @ 2.10GHz, 48GB of RAM …that also. And, if you want to repeat this benchmark, the sysbench code is on Launchpad lp:~vadim-…10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-related …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be…_pass_corrupt_table value checks by optimizing them for better CPU branch prediction. Bug fixed #1125248 (Alexey Kopytov). dialog.so used… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be…_pass_corrupt_table value checks by optimizing them for better CPU branch prediction. Bug fixed #1125248 (Alexey Kopytov). dialog.so used… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing…
Post: Percona Server on the Nexus 7: Your own MySQL Database Server on an Android Tablet
February 28, 2013 By 11 Comments
…_os | Linux | +————————-+——————————+ And a quick useless CPU benchmark just to understand …CPU X5670 @ 2.93GHz bogomips : 5851.73 mysql> SELECT BENCHMARK(10000000,ENCODE(‘hello’,'goodbye’)); +———————————————–+ | BENCHMARK(10000000,…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
… on new storage engine – show me benefits. So there is benchmark I made on one our servers. It is Dell 2950… different if load is CPU bound. I compared MySQL 5.1.30 trees – MySQL 5.1.30 with standard InnoDB, MySQL 5.1.30…-plugin-1.0.2 and MySQL 5.1.30 with XtraDB (all plugins statically compiled in MySQL) For benchmarks I used scripts that…
Post: Looking on 5.4 - IO bound benchmarks
April 30, 2009 By 5 Comments
… check how it works in our benchmarks. For first shoot I took tpcc-like IO-bound benchmark (100W, ~10GB of data, 3GB… Google Spreadsheet (it is also being update with my next CPU benchmarks, and benchmark on SSD & FusionIO), also I post graph there: Results… per minute, more is better). So I can confirm that MySQL team did great job with 5.4 and it shows…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… http://www.mysqlperformanceblog.com/files/benchpbxt/mysql.start and script to run whole loop of benchmarks http://www.mysqlperformanceblog.com/files/benchpbxt… model : 6 model name : Intel(R) Xeon(TM) CPU 3.20GHz stepping : 8 cpu MHz : 3192.222 cache size : 8192 KB 32GB…: For MyISAM / InnoDB ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb Method of benchmark: 1. Prepare table with 1,000,000 records…
