… series on the Star Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both… optimize queries for a star schema. A star schema presents some unique challenge to the database optimizer. The SSB benchmark consists of… adaptive hash index are cold for the cold test. All tests were done with no concurrency. The hardware for this test was provided…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… we tried to answer that question by retrying benchmarks on various combinations of hardware and dataset sizes, including the ones that are… case #1. Which is the perfect case for read-only transaction optimization in MySQL 5.6, because all SELECT queries in the… smaller dataset for this benchmarks round, since reportedly Dimitri was using 8 tables with 1M rows each (about 2.1GB) for his tests…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…statements for that), so it will produce all good amount of reads. A few words about the hardware:…also. And, if you want to repeat this benchmark, the sysbench code is on Launchpad lp:~vadim…500.Linux.x86_64/lib/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql #for SSD innodb_flush_neighbor_…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… or mysql started PHP script Zend framework libmemcached PECL module Zend_Cache_Backend_Libmemcached Here is the rough code for this benchmark: // Identical…, there are some tradeoffs to consider: Cost of additional memcached hardware Cost of operations time to maintain an additional system Impact…
Comment: State of the art: Galera - synchronous replication for InnoDB
April 23, 2013 By 15 Comments
…link http://www.codership.com/en/content/benchmarking-write-scalability does not work anymore? I am running … I have seen when running mysql 5.1 or mariadb 5.5 on the same hardware in a master/slave. … controller with six 300G SAS drives in a raid10 for the database and four 2TB SATA drives in a…
Post: MySQL QA Team Benchmarks for MySQL 5.1.30
December 13, 2008 By 12 Comments
As you might have seen MySQL QA Team has published their benchmarks for MySQL 5.0.72 and 5.1.30. It is interesting… at the graphs provided in these benchmarks and see what value is best for MySQL 5.1 and for MySQL 5.0 respectively ? Both versions… some benchmarks now and I can’t wait to see more. If we have data and the good disclosure (settings, versions, hardware…
Post: Announcing Percona Server for MySQL 5.1.68 -14.5
March 15, 2013 By Leave a Comment
…for MySQL, offering breakthrough performance, scalability, features, and instrumentation. Self-tuning algorithms and support for extremely high-performance hardware make it the clear choice for…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… same hardware just running PostgreSQL instead of MySQL or having Sun box replaced with comparable Dell or HP box. Unfortunately such benchmarks are… over vendors do the same thing of tuning database options for benchmark rather than running production reasonable options. It is interesting though…
Post: MySQL and PostgreSQL SpecJAppServer benchmark results
July 25, 2007 By 13 Comments
…however would notice hardware is different – MySQL benchmark use Sun Fire X4100 available in Nov 2005 using Opteron 285 CPU, PostgreSQL benchmarks use …on published SpecJAppServer benchmark while still working for MySQL I remember we spot number of issues in MySQL exposed by this benchmark with only …
Page: Consulting for MySQL
July 31, 2006 By
… benchmarks for your Solution with MySQL. We’re also ready to help with competitive benchmarks comparing MySQL and other databases for…for MySQL Need choosing Hardware and OS for MySQL ? Performing configuration and troubleshooting platform related issues ? We can help you designing optimal hardware…
