• notice
  • Congratulations on the launch of the Sought Tech site

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

Tags

Technical otaku

Sought technology together

Related Topic

0 Comments

Leave a Reply

+