• notice
  • Congratulations on the launch of the Sought Tech site

Mysqlread_buffer_size how much

key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections=458624 K

read_buffer_size: is the size of the MySQL read buffer.A request for a sequential scan of the table will allocate a read buffer, and MySQL will allocate a memory buffer for it.The read_buffer_size variable controls the size of this buffer.If the sequential scan requests for the table are very frequent, and you think that frequent scans are too slow, you can improve its performance by increasing the value of this variable and the size of the memory buffer.

The following is the setting for 16g memory


The personal machine is 32G, and the general database is used to store data.It is rarely used mysql so I Set to 2M or 3M

Mobile phone online update system MySQL database server parameter optimization mycnf, 16G memory 8-core CPU

Business scenario: The background supports mobile phone online update system, db server memory 16G, 8 cores, dell pc server.

qps: about 200
tps: 1 or so 50 a minute

sort_buffer_size=32M is big, 8M is enough
read_buffer_size=32M is big, 8M is enough
read_rnd_buffer_size=16M is big, 8M is enough
Small, it is recommended to change to 2048

Small, it is recommended to change to 16M

Small, it is recommended to change to 2G

Small, change it to 60% to 80% of the total memory of the db server

innodb_additional_mem_pool_size=20M is small, change to 128M

Why is the parameter join_buffer_size not seen? It must be set.Join_buffer_size=8M must be added.This is related to the join table and is very important.


Technical otaku

Sought technology together

Related Topic


Leave a Reply