自己写一个my.cnf,可把mysql自带的my-example.cnf改名,放到C盘根目录下
解决方案 »
- MySQL重装2003错误,删除重装半天了……
- 关于一个设计上的问题(MYSQL)
- insert into 很慢!!!
- Mysql的反斜杠问题
- mysql 怎样查询周的时间段
- load data local infile 插不进去
- SQL请教 件数
- 1000人在线,2000条数据的情况下读取一条数据,是mysql还是xml好?
- 求助一下,怎样增加一个排序字段啊
- 安装mysql出现1045的错误?
- 求可以执行子查询并可创建view的"免费"数据库...(急用)因为MySql好像不行???!!!!
- 请教—-安装MYSQL后我在COMMAND里面进入BIN目录后,先输入MYSQLD,然后输入MYSQL,出错!
max_connections=256
max_user_connections=256
其中256为你想要的连接最大数。
一般在100就可以的。
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
#设置最大连接数
set-variable = max_connections=100
set-variable = max_user_connections=0
#
set-variable = key_buffer=16K
set-variable = max_allowed_packet=1M
set-variable = thread_stack=64K
set-variable = table_cache=4
set-variable = sort_buffer=64K
set-variable = net_buffer_length=2K
server-id = 1
# Example mysql config file for medium systems.
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = table_cache=64
set-variable = sort_buffer=512K
set-variable = net_buffer_length=8K
set-variable = myisam_sort_buffer_size=8M
log-bin
server-id = 1# Example mysql config file for large systems.
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
set-variable = key_buffer=256M
set-variable = max_allowed_packet=1M
set-variable = table_cache=256
set-variable = sort_buffer=1M
set-variable = record_buffer=1M
set-variable = myisam_sort_buffer_size=64M
set-variable = thread_cache=8
# Try number of CPU's*2 for thread_concurrency
set-variable = thread_concurrency=8
log-bin
server-id = 1# Example mysql config file for very large systems.
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
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 = thread_concurrency=8
set-variable = myisam_sort_buffer_size=64M
log-bin
server-id = 1