The technology has changed considerably.
Your stats may be accurate for single individual drives but using a program like fancycache can yield a 1000x performance boost.
http://www.romexsoftware.com/en-us/fancy-cache/index.html
Infiniband / Striping / hybrid arrays of SSD + disks / clustering etc are all consumer cost reachable technologies today.
1 GB per second sustained read/writes is doable today and with clustering over infiniband 5gb/sec is attainable while remaining affordable.
Even some of the journaled posts on index settings and speed may not accurately reflect the hardware impact.
Try these simple changes for a 1000x boost
For DB Use covering indexes\ 64k page size (cuts read i/o in half and better cache hit rates)
For Disk use Fancycache setup with write only cache (1gb 512k blocks write deferred 2 sec) this buffers writes to achieve near SATA 3 spec speeds. Deferring the writes for 2 secs increases cache read hits and reduces hammering of i/o write operations... less fragmented sequentially writes of random data... which in turn optimizes read i/o.
CAUTION: Write deferred caching can cause serious data corruption on power failure/system lock ups.
Your stats may be accurate for single individual drives but using a program like fancycache can yield a 1000x performance boost.
http://www.romexsoftware.com/en-us/fancy-cache/index.html
Infiniband / Striping / hybrid arrays of SSD + disks / clustering etc are all consumer cost reachable technologies today.
1 GB per second sustained read/writes is doable today and with clustering over infiniband 5gb/sec is attainable while remaining affordable.
Even some of the journaled posts on index settings and speed may not accurately reflect the hardware impact.
Try these simple changes for a 1000x boost
For DB Use covering indexes\ 64k page size (cuts read i/o in half and better cache hit rates)
For Disk use Fancycache setup with write only cache (1gb 512k blocks write deferred 2 sec) this buffers writes to achieve near SATA 3 spec speeds. Deferring the writes for 2 secs increases cache read hits and reduces hammering of i/o write operations... less fragmented sequentially writes of random data... which in turn optimizes read i/o.
CAUTION: Write deferred caching can cause serious data corruption on power failure/system lock ups.
