Archive for the 'performance' Category
What if random IO speed wasn’t a database limitation?
This isn’t so far fetched, in particular today with the growing use of solid state drives. In what scenarios would MySQL perform better if it used a DRAM-based SSD? With extremely low latency, and very fast random IO compared to mechanical devices, IO bound db workloads could change considerably. Clustered indexes would matter less as long as the number of page accesses doesn’t increase, as opposed to trying to access data purely sequentially (which is data that has some relationship to its adjacent node – that’s why it’s stored for sequential access). Joins lose some of their cons, because random IO doesn’t matter as much. It would be interesting to see benchmark data comparing SSDs versus traditional disks on a database’s performance. Has anyone done this type of analysis?
1 comment
