Discuz!官方免费开源建站系统

 找回密码
 立即注册

QQ登录

只需一步,快速开始

搜索

會員超過100人時 mysql反應就變慢 請幫我看一下哪設錯了 謝謝 my.ini

[复制链接]
fscar 发表于 2008-8-24 17:28:39 | 显示全部楼层 |阅读模式
cpu=xeon5110雙合心有二棵
記憶体=2gb
my.ini設定值如下:
================================================
#This File was made using the WinMySQLAdmin 1.4 Tool
#2007/11/6 上午 06:28:11

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions


[mysqld]
basedir=D:/mysql
#bind-address=192.168.1.15
datadir=D:/mysql/data
#language=D:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
set-variable=max_connections=1024
skip-locking
#skip-networking
set-variable=key_buffer=512M
set-variable=max_allowed_packet=4M
set-variable=table_cache=4096
set-variable=thread_cache=64
set-variable=join_buffer_size=32M
set-variable=sort_buffer=32M
set-variable=record_buffer=32M
set-variable=max_connections=10000
set-variable=wait_timeout=120
set-variable=interactive_timeout=120
set-variable=max_connect_errors=30000
set-variable=long_query_time=1
set-variable=max_heap_table_size=256M
set-variable=tmp_table_size=128M
# Try number of CPU's*2 for thread_concurrency
set-variable=thread_concurrency=8
set-variable=myisam_sort_buffer_size=128M
#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
user=root
password=1233211234567
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

手机版|小黑屋|Discuz! 官方站 ( 皖ICP备16010102号 )star

GMT+8, 2024-11-19 00:49 , Processed in 0.030622 second(s), 3 queries , Gzip On, Redis On.

Powered by Discuz! X3.4

Copyright © 2001-2023, Tencent Cloud.

快速回复 返回顶部 返回列表