… the benchmarks, to see the difference in numbers. Benchmark results For the purpose of this benchmark, I … first obvious improvement is shown by the high numbers of Innodb_buffer_pool_read_ahead …best possible performance gain. This is not entirely visible in the manual either for MariaDB or MySQL, …
Post: Virident tachIOn: New player on Flash PCI-E cards market
June 15, 2010 By 19 Comments
… high margin in the price) as well as high performance in general and stable performance under high …- performance numbers. I took sysbench fileio benchmark with 16KB blocksize to see what maximal performance …sequential writes performance (important in question for log related activity in MySQL) I am…
Page: Consulting for MySQL
July 31, 2006 By
…MySQL Performance Optimization and Scaling Consulting – Hardware and OS configuration, MySQL Server Configuration, Schema, Queries, Application Architecture, Caching etc. MySQL High… benchmarks for your Solution with MySQL. We’re also ready to help with competitive benchmarks comparing MySQL…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
…been working for a customer benchmarking insert performance on Amazon EC2, and I have some interesting …GB of instance storage 64-bit platform I/O Performance: High API name: m2.4xlarge As for the IO… 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22…
Post: Clustrix benchmarks under tpcc-mysql workload
October 26, 2011 By 9 Comments
… Clustrix product, and this is the report on performance characteristics of Clustrix under tpcc-mysql workload. I tested tpcc 5000W (~500GB of… better) So my conclusions from this benchmark: Clustrix shows very good scalability in the high concurrent workload by adding additional nodes. In…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… benchmark As the goal was to compare performance with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions… to high concurrency response time in the first case is significantly better. It would be interesting however to run similar benchmarks on…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
…) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on standard EC2 …each), 64-bit platform, High I/O Capacity.” I used sysbench’s oltp benchmark, with 400,000,000…somewhat IO-bound. My goal for this benchmark is long-term performance, but as a side project, I…
Post: Great Talks on Percona Live,NY!, Free Pass opportunity inside
September 7, 2012 By 1 Comment
…topic which is highly relevant for your job to significantly increase mastery of the topic. If you work with benchmarking, performance analyses load…approaches to MySQL high availability or Percona XtraDB Cluster in Practice if you’re interested in brand new approach to MySQL high availability, …
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 55 Comments
… it out. I could do benchmarks, but that would not be interesting — we already know that benchmarks are unrealistic, and we know… reached 3. One of the samples shows the performance during a period of pretty high utilization. (Note: A read concurrency of 2… causing acute performance problems for the database, manifested as epic stalls and server lockups which show up as sky-high latency spikes…
Post: MySQL: what read_buffer_size value is optimal ?
September 17, 2007 By 25 Comments
… writers and do more benchmarks and performance research. I just recently wrote about rather surprising results with sort performance and today I’ve… this variable to some high value. Sample my.cnf values on large memory sizes recommend 1M settings and MySQL built-in default… query to perform full table scans, with 3 runs and averaged results. MySQL 5.1.21-beta was used for tests. mysql> select…
