…make flushes from buffer pool faster and also give RAID more room to optimize requests so writes would …sorts to be able to do so. Regarding O_DIRECT and Linus I know, so what ? The point is…be used to cache data instead of Innodb Buffer Pool, well this first would require to use mmap IO because you…
Comment: When to use Hardware upgrade instead of Software Optimization
December 7, 2008 By 5 Comments
… to get so much of local storage. IO system starvation can be the problem for sure but good directly attached storage is often good answer for that. Think about Caching… very cheap boxes for databases – little memory, no good RAID, poor hardware components and when loose a lot of time managing these.
Comment: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
… query performance of a mysql database. On a six disk RAID-10 15K RPM system, 22 MB/sec of random reads … win I receive from the battery backed cache is knowing that the last IO-OP from the controller made it … is a good link on what Linus Torvalds thinks of O_DIRECT. http://kerneltrap.org/node/7563
Post: High Rate insertion with MySQL and Innodb
January 7, 2011 By 17 Comments
…key caches was the good solution at that time and we could get over 200K of…hardware so It can’t be compared directly, still it is nice to see …started to see load to get IO bound because of log writes and flushing dirty buffers… (say better RAID or Flash) which is a very cool number. Of course, mind …
