一个经过高手优化的MySQL数据库实例_MySQL

据说这是高手优化的mysql,供大家参考,其中连接数: max_connections=1500可以根据服务器的性能更改.

#set-variable = connect_timeout=5

#set-variable = wait_timeout=5

建议启用,负担重的服务器可以适当减少持续连接时间

[mysqld]

basedir=D:/mysql

#bind-address=ip

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

网钛商城系统源码

网钛商城系统是个易用美观功能强大的一套商城系统，使用PHP语言，数据库有ACCESS和MYSQL两种。这套系统经过多家企业两年的使用，经功能汇总而整理出来，功能强大， 配置灵活，操作人性化，很容易上手，属于较成熟的PHP商城系统，允许个人按照自己的意愿修改和配置。我们今后还会定期的进行升级和修改。免费版仅可以使用Access数据库。

101

查看详情

# Try number of CPU's*2 for thread_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