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

read_buffer_size=1M

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
table_open_cache=512
Small, it is recommended to change to 2048

max_allowed_packet=5M
Small, it is recommended to change to 16M

tmp_table_size=64M
Small, it is recommended to change to 2G

innodb_buffer_pool_size=3000M
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.