… for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can… MySQL would re-create the test database when using rpm on server upgrade, even if the database was previously removed. Bug fixed…
Comment: State of the art: Galera - synchronous replication for InnoDB
April 23, 2013 By 15 Comments
The link http://www.codership.com/en/content/benchmarking-write-scalability does not work anymore? I am running mysqlslap … with six 300G SAS drives in a raid10 for the database and four 2TB SATA drives in a raid10 for the…
Post: SysBench - benchmark tool
August 18, 2006 By 20 Comments
… of benchmark. Sysbench allows to test: file I/O performance scheduler performance memory allocation and transfer speed POSIX threads implementation performance database… different servers – I will write about in further notes. Regarding database benchmarks – in 0.4.7 and earlier versions Sysbench supported only… next notes I’ll write how to setup and perform database benchmarks.
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
… 10 100 1000 10000; do ./benchmark.php $i 10000000; mysql -e’drop database test1′; mysql -e’create database test1′; done; tables: 1; total… 10 100 1000 10000; do ./benchmark.php $i 10000000; mysql -e’drop database test1′; mysql -e’create database test1′; done; tables: 1; total… 10 100 1000 10000; do ./benchmark.php $i 10000000; mysql -e’drop database test1′; mysql -e’create database test1′; done; tables: 1; total…
Post: On Benchmarks on SSD
July 14, 2010 By 4 Comments
… during benchmark. However it makes task of running benchmark on SSD trickier. It is similar to benchmarks on database but up-down. The database just… at the start of benchmark and remove afterward. The similar issue is when you restore database from backup, run benchmark, and remove files…
Post: MySQL and PostgreSQL SpecJAppServer benchmark results
July 25, 2007 By 13 Comments
… today I decided to take a closer look at SpecJAppServer benchmarks results which were published by PostgreSQL recently and which as… is different – MySQL benchmark use Sun Fire X4100 available in Nov 2005 using Opteron 285 CPU, PostgreSQL benchmarks use Sun Fire X4200…. This is not to mention specific tuning for Benchmark which could be performed on database engine level. As Josh now seems to…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
… DELIMITERS ‘,’,'\n’,'\”‘ NULL AS ”;” Load time: 13065 sec ( 3.6h) Database size after load is 65G , which is discouraging. It seems… I would not fit in timeframe I allocated for this benchmark. Maybe I will try sometime again. Query execution So I… they are in different queries. First favorite query for any database benchmarker is SELECT count(*) FROM ontime;. Both InforBritgh and MonetDB executes…
Post: Watch out for Marketing benchmarks
August 23, 2006 By 7 Comments
… and you better to do things differently or use other database. For example it happens with many types of subqueries, cases… hard to find good technical benchmark these days, competitive benchmarks which are done inside companies are rarely published. Benchmark run by individuals are… mass media – eWeek benchmark or recent CT benchmark are from this type. Interesting enough even in TPC or SPEC benchmarks vendors try to…
Post: Choosing an appropriate benchmark length
March 21, 2011 By Leave a Comment
… heat dispersion challenges if run at that level long-term. Database servers are no different. Many components in the system have… to fit in one or two benchmarks a day. Vadim runs a lot of long-term benchmarks on MySQL and Percona Server… one way to tell: keep running the benchmark. I ended up running the above benchmark for 72 hours to ensure that it…
Post: Introducing new type of benchmark
February 25, 2012 By 16 Comments
… wrong with existing benchmarks? Well, all benchmarks are lie, and focusing on throughput does not get any closer to reality. Benchmarks, like sysbench or tpcc-mysql, start N threads and try to push the database as much as possible…. How we should change the benchmark to base on this model ? There are my working ideas: Benchmark starts N working threads, but…
