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.