mysql database my.ini optimized 2G memory for station multi compression type Settings

The larger the physical memory, the larger the setting. The default is 2402, 512-1024 is best
innodb_additional_mem_pool_size=4M = 2M by default
innodb_flush_log_at_trx_commit=1
(set to 0 is to wait until innodb_log_buffer_size queue is full before storing 1, default is 1)
innodb_log_buffer_size=2M is 1M by default
innodb_thread_concurrency=8 if your server CPU has a few, it is recommended to use the default 1 as 8
key_buffer_size=256M is best adjusted from 218 to 128 by default
tmp_table_size=64M defaults to 16M to 64-256
read_buffer_size=4M by default is 64K
read_rnd_buffer_size=16M the default is 256K
sort_buffer_size=32M the default is 256K
max_connections=1024 defaults to 1210
thread_cache_size=120 defaults to 60
query_cache_size=64M