Reducing high I/O wait times

[FakeOutdoorsman]

Besides buying a new hard drive, what are the best ways to reduce high I/O wait times and reduce high reads/writes per second on a server running database driven applications?

[souki]

maybe this :

- disk tunning (hdparm, kernel)
- more RAM
- database cache, buffer, shared memory tunning
- table's structure, field's size, indexes
- reduce number of connections (web app?)
- application level (if you've designed it)

[FakeOutdoorsman]

Thanks for the info. I think adding more RAM and another hard drive might be the solution right now.

[rastilin]

Why not change the disk scheduler to something designed for less latency like "deadline"?