… m2.4xlarge instance as that’s the instance type with highest memory available, and memory is what really really matters. High-Memory… downward spikes in performance. Other then that, I have also disabled query cache to avoid contention caused by query cache on write heavy… read performance to improve, but they have an impact on the write performance. Well most of the apps rely on read performance and…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
… cases with performance problems with MySQL is what they happen every so often or certain times. Investigating them we find out what the… response times will increase and user experience will suffer. So what you can do to prevent this problem from happening ? The…
Post: Testing Virident FlashMAX 1400
May 4, 2012 By 3 Comments
…use a mode “turbo=1″ for Virident card. What does that mean? Apparently PCIe specification has …reserves internally more space to provide better write performance. So as usually I start with random writes,… Follow @VadimTk !function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(…
Comment: ext4 vs xfs on SSD
May 3, 2012 By 23 Comments
… the metadata performance of XFS (especially with regards to metadata fragmentation), so maybe it’s time to do another benchmark. What I found…, or using nobarrier, all have no statistically significant impact on performance, which seems to indicate that XFS had some bottleneck internally…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… not properly indexed. Here’s a theory that seems to explain the performance you are seeing. The periodic performance variation corresponds to filling…’t graph the performance on the first 100M rows). The minimum performance troughs occur just as the partition switches. So performance gets worse…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
This benchmark doesn’t test the IO performance of EBS though as you’re not flushing to disks on each commit. What numbers do you get when you set innodb_flush_log_at_trx_commit to 1?
Comment: Joining many tables in MySQL - optimizer_search_depth
May 12, 2012 By 6 Comments
Ovais, Syntactic hints surely help pushing the performance in case of particular queries but surely cannot be an …. In addition, hints need to be built into the (application’s) logic which is simply a nightmare for developers in case…
Comment: New distribution of random generator for sysbench - Zipf
May 11, 2012 By 3 Comments
Hi Vadim, That’s very interesting thanks for the article. Can i also ask what software/scripts you use for the graphs in your various articles ? Regards, Romain.
Post: Testing Fusion-io ioDrive2 Duo
May 10, 2012 By 12 Comments
…: We see stable and predictable write performance, with throughput: 660 MiB/s for single, and 1300 MiB/s for Duo Random reads: Again… more stable performance results comparing to previous generation ioDrive. Follow @VadimTk !function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 10, 2012 By 28 Comments
… understand that the insights to the binlog would likely show what you’ve said and I do agree that turning off… DATA INFILE command is executed on master? (cuz that’s not what I’m seeing on our systems, with binlog left on…
