如何针对大量写入和少量读取（100：1）优化/调整mysql。阅读perf reqd

I have simple db with 4 tables with a few millions rows each, and several indexes. I'm performing several hundred update and inserts on them per minute. The reads are much less frequent, but they need to be fast - for a web app. The reads should have priority - I can delay writes, if it helps improve the snappiness of reading.I have simple db with 4 tables with a few milli