Me , too, have the same problem. it seems that every opened page establishes a connection but those connections can't be closed, although i explicitly close in my code I posted a message related with this problem a few days ago, unfortunately couldn't get a satisfying answer. So, i request from Mark Matthew to help us with this problem , since he is the author of Mysql. (my Mysql version is 3.23 , i use jdbc through tomcat 4 b7, on win 2000.) Thanks in advance cheers ----- Original Message ----- From: "sherzodR" <[EMAIL PROTECTED]> To: "Chris Mason" <[EMAIL PROTECTED]> Cc: "MySQL List" <[EMAIL PROTECTED]> Sent: Tuesday, November 27, 2001 1:19 PM Subject: Re: Too many connections (again)
> > > I keep getting that error too. But I couldn't figure out the cause. So I > just used Apache::DBI for persistent DB connection ( you can't do that > unless your scripts are running under mod_perl ) > > -- > sherzodR > > > On Mon, 26 Nov 2001, Chris Mason wrote: > > >I have a lot of databased websites running on my server (1 Ghz P3/256 > >MB/20GB/RH7.1) and I am continually getting connection problems. None of the > >sites are high volume, so I am surprised by this and I suspect that > >connections are not being reused quickly enough. > > > >Here's my config, can anyone help me sort this out? > > > > > > > >[root@server1 /root]# vi /etc/my.cnf > > > >[mysqld] > >#datadir=/var/lib/mysql > >datadir=/usr/mysql > >#socket=/usr/mysql/mysql.sock > >socket=/var/lib/mysql/mysql.sock > > > >[mysql.server] > >user=mysql > >basedir=/var/lib > >max_connections=300 > > > >[safe_mysqld] > >err-log=/var/log/mysqld.log > >pid-file=/var/run/mysqld/mysqld.pid > > > > > >Chris Mason > >[EMAIL PROTECTED] > > > > > >--------------------------------------------------------------------- > >Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > >To request this thread, e-mail <[EMAIL PROTECTED]> > >To unsubscribe, e-mail <[EMAIL PROTECTED]> > >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php