mysql set variable_mysql优化配置参数__set-variable_连接_max_connections_数据_数据库__169IT.COM...

第一种

代码如下:

#This File was made using the WinMySQLAdmin 1.4 Tool

#2004-2-23 16:28:14

#Uncomment or Add only the keys that you know how works.

#Read the MySQL Manual for instructions

[mysqld]

basedir=D:/mysql

#bind-address=210.5.*.*

datadir=D:/mysql/data

#language=D:/mysql/share/your language directory

#slow query log#=

#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

# Try number of CPU's*2 for thread_concurrency

set-variable =