Optimization of my. ini in MySQL database 2 GB memory for multi-site and multi-compression settings

The larger the physical memory, the larger the setting. The default value is 2402, and the value is adjusted.
Innodb_additional_mem_pool_size = 4 m; default value: 2 m
Innodb_flush_log_at_trx_commit = 1
(If it is set to 0, innodb_log_buffer_size is stored after the queue is full. The default value is 1)
Innodb_log_buffer_size = 2 m; default value: 1 m
Innodb_thread_concurrency = 8 if you have a few CPUs on your server, set it to a few. We recommend that you use the default value of 8
Key_buffer_size = 256 m. The default value is 218 to 128.
Tmp_table_size = 64 m. The default value is 16 m and the value is adjusted to 64-256.
Read_buffer_size = 4 m. The default value is 64 K.
Read_rnd_buffer_size = 16 m. The default value is 256 K.
Sort_buffer_size = 32 m. The default value is 256 K.
Max_connections = 1024 the default value is 1210.
Thread_cache_size = 120 The default value is 60.
Query_cache_size = 64 m