…://blogs.innodb.com/wp/2012/04/new-flushing-algorithm-in-innodb/ Info on O_DSYNC being faster than O_DIRECT http://…should be better ways of allowing read and writes without locking ie. a special algorithm. I think something… one was to raid 10 a bunch of SSD’s then we could put the Innodb straight to…
Post: Query Profiling with MySQL: Bypassing caches
September 12, 2007 By 6 Comments
…explicitely bypass it by using O_DIRECT flag or mounting file system in direct IO mode. Hardware Caches State… IO cache may however cause dramatic difference. Hardware RAID cache is the one but more important …but there is no way to clean Innodb Buffer Pool without restart. For OS Caches on Linux you…
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…innodb_flush_method = O_DIRECT innodb_max_dirty_pages_pct = 50 innodb_io_capacity = 800 innodb_read_io_threads = 8 innodb_write_io_threads = 4 innodb… the table without secondary indexes…
Post: My Innodb Feature wishes
May 4, 2006 By 30 Comments
… (expecially together with ability to create index without table rebuilding) Buffer pool improvements. I would…RAID and forget about tablespaces by spreading the load, but you often can do it better manually 
I/O…should be very helpful with direct IO as well as with innodb_file_per_table=1 allowing …
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 11 Comments
… inside InnoDB, or to the Threads_running SHOW STATUS counter, without much loss of generality. The Amazon cloud platform with a RAID of… directly attached disks or SSD devices. InnoDB doesn’t handle this very well, because I/O tends to be a blocking operation in InnoDB… weakest link in the chain, due to the way InnoDB handles I/O. If you demand a lot of throughput from your…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…s hardware, including RAID controllers, installed memory… could never understand, O Almighty Percona, here’…that something is disconnecting ungracefully (without closing the connection …InnoDB tables whose .frm files exist but have been dropped from InnoDB…small adjustments to the direction we’re going,…
