Current location: Hot Scripts Forums » Programming Languages » PHP » Still too many MySql connections


Still too many MySql connections

Reply
  #1 (permalink)  
Old 02-07-04, 03:34 PM
CoraxCornerman CoraxCornerman is offline
New Member
 
Join Date: Jan 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Still too many MySql connections

Hello!

Since we had some more visitors lately, we ran into problems with the 'too many mysql connections' error. I have to reboot mysql every hour or so...


This is our my.cnf:


[mysqld]
set-variable = max_connections=1024
max_user_connections=3
set-variable = wait_timeout=60

Can anyone suggest something, so that there won't be such an error that often again. The site is a download site.

Thanks a lot!
Reply With Quote
  #2 (permalink)  
Old 02-08-04, 09:51 PM
blaw's Avatar
blaw blaw is offline
Junior Code Guru
 
Join Date: Dec 2003
Location: Vancouver, BC, Canada
Posts: 550
Thanks: 0
Thanked 0 Times in 0 Posts
Hi there,

Maybe you an start looking into the problem from here?

http://www.mysql.com/doc/en/Too_many_connections.html
__________________
Blavv =|
Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
PHP and MySQL ? rob2132 Hot Scripts Forum Questions, Suggestions and Feedback 4 08-29-08 02:22 AM
(Still) trying to install mySQL on winXP! (IIS) linseym PHP 1 01-24-04 03:11 PM
Installing mySQL on a WinXP Pro machine linseym PHP 4 01-17-04 06:28 AM
PHP to MySQL script question...(using a field to update info in MySQL) DisneyFan25863 PHP 4 11-02-03 03:31 AM
great product for dumping/recovering MySQL databases Dave Brown General Advertisements 1 10-03-03 07:40 AM


All times are GMT -5. The time now is 08:45 AM.
vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.