两个32k纸是多大尺寸:MySQL 1040 错误 Too many connections
来源:百度文库 编辑:偶看新闻 时间:2024/05/10 06:34:18
Can not connect to MySQL server
Error: Too many connections
Errno.: 1040
原因:
因为 my.ini 中设定的并发连接数太少或者系统繁忙导致连接数被占满。
解决方式:
打开 MYSQL 安装目录打开 my.ini 找到 max_connections 默认是 100, 一般设置到500~1000比较合适,重启 MySQL ,解决 MySQL 1040 错误。
高手优化的MYSQL my.ini的1000人在线配置。
#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=1000
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 = 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
重启一下MYSQL服务就OK了
Error: Too many connections
Errno.: 1040
原因:
因为 my.ini 中设定的并发连接数太少或者系统繁忙导致连接数被占满。
解决方式:
打开 MYSQL 安装目录打开 my.ini 找到 max_connections 默认是 100, 一般设置到500~1000比较合适,重启 MySQL ,解决 MySQL 1040 错误。
高手优化的MYSQL my.ini的1000人在线配置。
#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=1000
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 = 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
重启一下MYSQL服务就OK了
mysql错误
mysql安装错误
mysql错误号1045
MYSQL错误警告
Mysql 的错误1067是什么意思?
MYSQL的错误,怎么解决?
phpMyAdmin - 错误 无法载入 mysql 扩展
jsp网站搭建错误问题?(tomcat+mysql)
关于PHP和MYSQL的一个错误
关于Lost connection to MySQL server during query 错误提示
描述:错误: connect:Lost connection to MySQL server during query
unix 2c8d6es7djsdns9ms(8)错误 mysql 3.2.0.1
请教有关php与MySQL的错误提示的解决方法?
Big Ma Ma
too serious too soon
much too too much
pb中获取mysql的数据,中文是乱码,如何解决?另外在datawindow中不能保存中文,提示:Data too long ...
歌词中有du ma la di lu 爱上你是个天大的错误是什么歌
MYSQL老是运行好好的一段时间就会1067登录错误怎么回事!!
mysql出现1067错误无法启动服务,重装,修改my.ini也无法使用。如何解决?
mysql运行错误libmyclient.so.12:cannot open shared object file : No such file or directory
我linux下安装mysql后再编译安装php.结果得到错误提示
Hibernate+MySQL错误,哪位高手来帮帮忙谢谢啦,在线等,急
MA是什么意思