… been working for a customer benchmarking insert performance on Amazon EC2, and I have some interesting results that I wanted to… EC2 Compute Units (8 virtual cores with 3.25 EC2 Compute Units each) 1690 GB of instance storage 64-bit platform I/O… innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_max_dirty_pages_pct = 50 innodb_io_capacity = 800…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… hash joins and other background operations. This will have a direct impact in our query response times and throughput. Setting up… set up the hosts file: sudo su – # cat hosts.internal | ~ec2-user/tools/mkhosts >> /etc/hosts # ping shard20 PING shard20 (10… innodb-flush-log-at-trx-commit=1 innodb-flush-method=O_DIRECT innodb-ibuf-active-contract=1 innodb-import-table-from-xtrabackup…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
… as compared to directly attached disks or SSD devices. InnoDB doesn’t handle this very well, because I/O tends to be… 5.1, probably due to improvements such as our I/O algorithms and reduced mutex contention. The performance improvements I got… not directly on-topic for this post. The bottom line is that there is not a huge performance difference between EC2+EBS…
Post: The perils of InnoDB with Debian and startup scripts
January 28, 2009 By 13 Comments
…’re running on Amazon EC2 with 8G of RAM and EBS storage, which is slower than typical directly-attached server-grade RAID… large as we’d like to. To avoid physical I/O all the time we need to get some reasonable amount… chosen strategy for this was to set innodb_flush_method=O_DIRECT. We could also tune the OS, but in my experience…
