Windows2016 operating system, 24 core processor 64 gb of memory, the database of the data of several more and queries to calculate more, the usage of this configuration is not objective, request help


[mysqld]
Skip - name - resolve
Basedir="installation path"
Datadir="installation path"
Port=3306
Character - set - server=utf8
Default - storage - engine=InnoDB
SQL - mode=NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION

Back_log=500
Wait_timeout=1800
Max_connections=10000
Max_user_connections=800
Max_allowed_packet=1024 m
Max_heap_table_size=2048 m
Thread_concurrency=256
Thread_cache_size=256
Both tmp_table_size=4 g
Table_open_cache=10240
Key_buffer_size=10240 m
Innodb_buffer_pool_size=20 g
Innodb_additional_mem_pool_size=1024 m
Innodb_log_buffer_size=256 m
Query_cache_size=0
Query_cache_type=0
Read_buffer_size=8 m
Read_rnd_buffer_size=8 m
Sort_buffer_size=8 m
Join_buffer_size=8 m

-- - the links=0

CodePudding user response:

Or don't use WINDOWS, use CentOS or something.
Development and testing environment Windows + mysql no problem, you this is the formal environment, look a bit strange...

CodePudding user response:

reference 1st floor XuanXi word reply:

don't use WINDOWS, use CentOS or something.
Development and testing environment Windows + mysql no problem, you this is the formal environment, look a bit strange...

local test system to open the speed is normal, but is deployed to the server is very slow, and couldn't find what reason, don't know what is the database or tomcat configuration has a problem