News for hackers. Stuff that matters.
Re:Disaster: MySQL 5.5 Flushing by spudlyo on Sunday September 18, 2011 @07:22PM (#3011565)
We do understand why this problem is happening. The algorithm that takes the nice fast (but limited in size) sequential log writes and tries to intelligently write them (mostly randomly) in the background to the data/index blocks where they live can't keep up, and eventually stalls out as the amount of free log space dwindles.

SSDs really help this process happen faster because they have way better random write performance than hard disks.

There are no comments on this comment yet.