… our repositories. Benchmark showing the impact of memory allocators on MySQL performance can be… fixed #1130888 (Seppo Jaakola). If MySQL replication threads were started before running wsrep recovery,…1132974 (Seppo Jaakola). Conflicting prepared statements in multi-master use case could cause node …
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…, here is how one would start the memcached plugin: mysql> install plugin daemon_memcached soname ‘libmemcached.so’; In an … } } $totalTimeFetch = $timer->stop(); $avgTimeFetch = $totalTimeFetch / 1000000; While this benchmark doesn’t show any multi-threading or other advanced operation, it is using …
Post: EC2/EBS single and RAID volumes IO benchmark
August 6, 2009 By 14 Comments
… is not quite perfect. So I have spent some time benchmarking volumes. Interesting part with EBS volumes is that you see… used xfs filesystem mounted with noatime,nobarrier options and for benchmark I used sysbench fileio modes on 16GB file with next… of course to get benefit from multi-threading IO in MySQL you need to use XtraDB or MySQL 5.4 ® However there may be…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
Amazon’s Relational Database Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on… single-threaded insert workload is not very revealing. To understand the sustained write performance of an RDS instance, we need a multi-threaded long-term insert benchmark such as IIBench. In the next post in…
Post: FusionIO 320GB MLC benchmarks
January 11, 2010 By 19 Comments
…. The full numbers are available on our Wiki benchmarks page, couple words about benchmarks. I did sysbench fileio runs on 100% space… increased concurrency To get most from card you need multi-threaded IO (4-16 threads) With RAID0 you can get doubled space with…) Now having these cards and numbers, I am going to benchmark MySQL with FusionIO as storage.
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…. That means Galera supports the XtraDB storage engine. Support for multi-threaded slaves. Using custom scripts for node propagation. RSYNC method comes… an average MySQL master-slave setup. Potential performance penalty: Although to have performance numbers I am going to run different benchmarks, I…
Post: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
… should expect from the system. What I usually look for MySQL is performance in random reads and random writes. Sequential reads… run sysbench v0.4.8: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 1 Extra file open flags…
Post: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 7, 2010 By 48 Comments
… than other engines. Though LucidDB and MonetDB are also have multi-thread loaders, only InfoBright ICE used single core. InfiniDB: 24 010…/mysql-parallel-query-processing-of-ssb-queries-via-infinidb-.html SSB benchmark may be not good for InfoBright, the synthetic nature of benchmark…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
…multi-core and multi-disks utilization. Also results may be different if load is CPU bound. I compared MySQL 5.1.30 trees – MySQL…MySQL 5.1.30 with XtraDB (all plugins statically compiled in MySQL) For benchmarks…10M:autoextend innodb_file_io_threads = 4 innodb_thread_concurrency = 16 innodb_flush_log…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…MySQL AB made new storage engine Falcon available for wide auditory. We cannot miss this event and executed several benchmarks…4, 16, 64, 128, 256 concurrent threads. 3. For each thread perform a warm-up run (duration 180…this is specific Falcon’s way to handle multi-versioning. I think this is a big …
