… of Hardware OS And Application optimization. I call this Innodb Performance Optimization Basics so these are general guidelines which work well… most cases this setting improves performance. Though be careful if you do not have battery backed up RAID cache as when write…-isolation=READ-COMMITTED. This option has some performance benefits, especially in locking in 5.0 and even more to come with MySQL…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
…/O Performance: High API name: m2.4xlarge As for the IO configuration I chose 8 x 200G EBS volumes in software RAID…_table = 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You can see that the buffer pool is sized… read performance to improve, but they have an impact on the write performance. Well most of the apps rely on read performance and…
Comment: FusionIO 320GB MLC benchmarks
January 12, 2010 By 19 Comments
… cards into RAID 0 configuration. Most likely we talk about RAID 10, which halves storage space; or RAID 5 / 50, which hits write performance. With…
Comment: Living with backups
November 18, 2008 By 28 Comments
I played recently with backups while performing server upgrades… My new backup slave performs the whole backup (~60GB uncompressed dump, though using… the deadline scheduler (which was the default) gives the best performance in all tested kernels – side read operation are fast and… more than using deadline. The IO subsystem is a hardware RAID 0+1 (3 stripped RAID1), 6x 10k SCSI-320 disks, 128M…
Comment: Clustrix benchmarks under tpcc-mysql workload
October 26, 2011 By 9 Comments
Interesting that at high concurrency 7 Intel 320 perform pretty much the same as FusionIO. 7 320 cost about $2K. How much does that FuisonIO cost – around $10K? When you RAID-0 7 SSD, did SATA become the bottleneck?
Comment: Virident tachIOn: New player on Flash PCI-E cards market
June 16, 2010 By 19 Comments
… keeping that in mind, people like to implement RAID 0 because it gives them better performance per server and higher usable capacity. The…
Comment: FusionIO 320GB MLC benchmarks
January 12, 2010 By 19 Comments
… be able to read the data off them. But agreed, > RAID 0 if great for benchmarking but not for a production database… Intel mobo SATA II connector. I’ve honestly had serious performance or reliability issues with almost every SSD device I’ve…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
… be merged on OS level or RAID controller so we should expect at least as good performance from O_DIRECT as from… Uptime | 6 days, 6:21, 4 users, load average: 0.00, 0.01, 0.05 System | Supermicro; PDSMi; v0123456789 (Other) Service Tag | 0123456789… is dramatically different. The good news though is even though performance advantages of buffered mode can be dramatic for some workloads…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… the bad things I’ve heard about loss of performance with 5.0.X. I’m hopeful that 5.1.X will… there were bunch of micro optimizations in Innodb in 5.0 series. Also note the “Auto Increment Issue” is finally solved… as RAID cache so it can handle system restarts. When putting log files on such device could give great logging performance because…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… area of optimization. I frequently see batch jobs killing server performance overtaking buffer pool. Though full table scan is only one…, “Helps in performance tuning in heavily concurrent environments. Sets the max\ imum number of threads allowed inside InnoDB. Value 0 will disable… regressions in 5.0 because of group commit being broken. Most do not have RAID with BBU. With good RAID with BBU you…
