MySQL database server parameter optimization mycnf, 16 GB memory 8-core CPU, mobile online update system,

Business scenario:The background supports online mobile phone update system, 16 gb db Server Memory, 8-core, Dell PC server.
QPS:About 200
TPS:1 minute or so

Sort_buffer_size = 32 m, 8 m

Read_buffer_size = 32 m, 8 m

Read_rnd_buffer_size = 16 m, 8 m

Table_open_cache = 512
Small. We recommend that you change it to 2048.

Max_allowed_packet = 5 m
Small, it is recommended to change to 16 m

Tmp_table_size = 64 m
Small, it is recommended to change to 2G

Innodb_buffer_pool_size = 3000 m
Small, changed to 60% to 80% of the total memory of the DB Server

Innodb_additional_mem_pool_size = 20 m smaller, changed to 128 m

The join_buffer_size parameter is not displayed. The value must be set. join_buffer_size = 8 m must be added. This parameter is associated with the join table and is very important.

A little suggestion. You are welcome to discuss it together.