MySQL database server parameter optimization mycnf, 16 GB memory 8-core CPU

MySQL database server parameter optimization mycnf, 16 GB memory 8-core CPU business scenario: the background supports online mobile phone update system, db Server Memory 16 GB, 8-core, dell pc server. Qps: about 200 tps: About 1 minute, 50 or more sort_buffer_size = 32 M, 8 M can be read_buffer_size = 32 M, 8 M can be read_rnd_buffer_size = 16 M, 8 M can be table_open_cache = 512 small, it is recommended to change 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, changed to 60% to 80% innodb_additional_mem_pool_size = 20 M of the total memory of the db server. Changed to 128 M join_buffer_size. Why is this parameter not displayed? The value must be set. join_buffer_size = 8 M must be added, this is join t. It is very important.