首页 > 代码库 > MySQL 的 read_buffer_size 参数是如何影响写缓冲和写性能的?

MySQL 的 read_buffer_size 参数是如何影响写缓冲和写性能的?

来自国外博客的一篇文章介绍了MySQL 的 read_buffer_size 参数是如何影响写缓冲和写性能。

据说 read_buffer_size 参数只影响以下两种情况的写数据的性能:

  • SELECT INTO … OUTFILE ‘fileName
    • When writing to the OUTFILE, the writes are buffered before writing to OUTFILE
  • When filesort is used, during merge buffers and when merged results are written to a temporary file, then writes are buffered

下表是该文章测试的一些数据:

read_buffer_sizephysical writesexe time in secs
=0 (defaults to 8200)2349528.39
=131072 (default)293727.44
=167772162326.71
=335544321226.00
=536870912126.72

 

详细内容请看原文:

http://venublog.com/2010/06/23/how-read_buffer_size-impacts-write-buffering-and-write-performance/

MySQL 的 read_buffer_size 参数是如何影响写缓冲和写性能的?