my.ini

mysql绿色版 易语言版启动程序 附带源代码

# Discuz!EXP MySQL Configuration File.
# This file was generated by Nanu (Comsenz Inc.)

# NOTICE: If you want Discuz!EXP play a role of server, Please adjust the following variables
#         to enhance the performance of MySQL.

[client]
port = 3306

[mysql]
default-character-set = latin1

[mysqld]
basedir =C:\MySQL5\
datadir =C:\MySQL5\data

[WinMySQLadmin]
Server=C:\MySQL5\bin\mysqld-nt.exe

port = 3306
server-id = 1
default-character-set = latin1
default-storage-engine = MYISAM

skip-locking
skip-innodb
skip-bdb

key_buffer_size = 12M
max_connections = 16
max_allowed_packet = 2M
thread_cache = 32
table_cache = 16
sort_buffer_size = 256K
read_buffer_size = 64K
read_rnd_buffer_size = 256K
join_buffer_size = 256M
query_cache_size = 512K
# Try number of CPU's*2 for thread_concurrency
thread_concurrency =2

myisam_sort_buffer_size = 4M
myisam_max_sort_file_size = 100G
myisam_max_extra_sort_file_size = 100G

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[myisamchk]
key_buffer=64M
sort_buffer = 64M
read_buffer = 4M
write_buffer = 4M

[mysqlhotcopy]
interactive-timeout

encoding = CP1251