… happening concurrently. It is very typical to hear complains about MySQL interactive performance – serving simple standard web traffic is drastically impacted when… to be pushed out of buffer pool. Lets repeat the benchmark with innodb_old_blocks_time=1000 which will correspond to…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
… fix the buffer pool scalability issue. Let’s see how MySQL performance changes for the last workload if we set innodb_buffer… used for benchmarks on FusionIO: [client] socket=/var/lib/mysql/mysql.sock [mysqld] core basedir=/usr/local/mysql user=root socket=/var/lib/mysql/mysql.sock…
Post: A piece of Sun/MySQL Marketing
February 27, 2008 By 7 Comments
… stuff related to Sun and MySQL and among other things – These Benchmarks This may be great piece of Benchmarks for Sales and Marketing… Virtualization Software” used with Windows is a crap ? Remembering horrible MySQL performance loss from Xen and VMWARE It is quite possible. You…
Post: Disaster: MySQL 5.5 Flushing
September 18, 2011 By 27 Comments
…,000 rows each. Total database size ~58GB. MySQL version: 5.5.16 Initial benchmark, which InnoDB configured for this hardware innodb_flush… my benchmark I measure results each 10 sec, and when we graph it, it looks like: Basically there two stages: MySQL handles… using SSD as storage, then I would recommend it. Vanilla MySQL performs equally bad on SSD and HDD, while for SSD in…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
We were doing MySQL Performance evaluation on TPC-H queries for the client and they … from MySQL,though at least we get to see performance of individual queries. We also packaged the toolset we used for benchmarks so… those presented in TPC-H benchmark are still subpar even with changes which are currently seen in MySQL 6.0 tree. There…
Post: Why do we care about MySQL Performance at High Concurrency?
February 26, 2013 By 9 Comments
In many MySQL Benchmarks we can see performance compared with rather high level of concurrency. In some cases … if people do not really run MySQL with high concurrency does it really matter how MySQL performs with high concurrency or is it just marketing gimmicks to promote new software versions ? Performance at High Concurrency…
Post: MySQL: what read_buffer_size value is optimal ?
September 17, 2007 By 25 Comments
The more I work with MySQL Performance Optimization and Optimization for other applications the better I understand … writers and do more benchmarks and performance research. I just recently wrote about rather surprising results with sort performance and today I’ve…
Post: Percona Server on the Nexus 7: Your own MySQL Database Server on an Android Tablet
February 28, 2013 By 11 Comments
… benchmark just to understand some level of performance of tablet CPUs: Processor : ARMv7 Processor rev 9 (v7l) processor : 0 BogoMIPS : 1993.93 mysql> SELECT BENCHMARK(10000000,ENCODE(‘hello’,'goodbye’)); +———————————————–+ | BENCHMARK…
Post: MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)
December 21, 2010 By 11 Comments
… card The raw results, config, and script are in our Benchmarks Wiki. Here are the graphs: 13G innodb_buffer_pool_size… looking for high MySQL performance, and we tune Percona Server to get the most from such hardware. Actually, from my benchmarks, I see that the Virident card is not fully loaded, and we may benefit from running two separate instances of MySQL…
Post: MySQL Performance Engineer opening
May 13, 2008 By Leave a Comment
… know we love to analyze performance of various MySQL features, benchmark, compare, analyze things and post our findings on MySQL Performance Blog. However recently we… could focus on such tasks. What are we expecting from MySQL Performance Engineer ? Such person should have a passion for making things…
