Archive for the ‘mysql filesort performance’ Category

How read_buffer_size Impacts Write Buffering and Write Performance

Июнь 23rd, 2010
Even though the name read_buffer_size implies that the variable controls only read buffering, but it actually does dual purpose by providing sequential IO buffering for both reads and writes. In case of write buffering, it groups the sequential writes until read_buffer_size(it is min(read_buffer_size, 8K)); and then actually does the physical write once the buffer is full. [...]
PlanetMySQL Voting: Vote UP / Vote DOWN