Master optimized mysql for your reference
It is said that this is MySQL optimized by masters for your reference.The number of connections: max_connections=1500 can be changed according to the performance of the server.
#set-variable=connect_timeout=5
#set-variable=wait_timeout=5
It is recommended to enable it, and the server with heavy load can appropriately reduce the continuous connection time
[mysqld]
basedir=D:/mysql
#bind-address=ip
datadir=D:/mysql/data
#language=D:/mysql/share/yourlanguagedirectory
#slowquerylog#=
#tmpdir#=
#port=3306
set-variable=max_connections=1500
skip-locking
#skip-networking
set-variable=key_buffer=384M
set-variable=max_allowed_packet=1M
set-variable=table_cache=512
set-variable=sort_buffer=2M
set-variable=record_buffer=2M
set-variable=thread_cache=8
#TrynumberofCPU's*2forthread_concurrency
set-variable=thread_concurrency=8
set-variable=myisam_sort_buffer_size=64M
#set-variable=connect_timeout=5
#set-variable=wait_timeout=5
server-id=1
[isamchk]
set-variable=key_buffer=128M
set-variable=sort_buffer=128M
set-variable=read_buffer=2M
set-variable=write_buffer=2M
[myisamchk]
set-variable=key_buffer=128M
set-variable=sort_buffer=128M
set-variable=read_buffer=2M
set-variable=write_buffer=2M
[WinMySQLadmin]
Server=D:/mysql/bin/mysqld-nt.exe
0 Comments