Anyone know how to solve this? - GoFuckYourself.com - Adult Webmaster Forum

X

-=HOAX=-

Confirmed User

Join Date: Dec 2001

Posts: 4365
Share

Post
#1

Anyone know how to solve this?

07-18-2002, 10:20 AM

Warning: Too many connections in mysqlfunc.inc.php on line 4

Warning: MySQL Connection Failed: Too many connections in mysqlfunc.inc.php on line 4
Chould not connect to MySQL

Insert Value Here.
Tags: None
Amputate Your Head

There can be only one

Join Date: Aug 2001

Posts: 39075
Share

Post
#2

07-18-2002, 10:26 AM

hmmm..... I have seen this before....

but no, I don't know how to fix it.

SIG TOO BIG
Comment
-=HOAX=-

Confirmed User

Join Date: Dec 2001

Posts: 4365
Share

Post
#3

07-18-2002, 10:30 AM

I've tried multiple variations in the my.cnf file but mysqld is pegging the processor at 95%+ then again the 80k+ on a dual p450 with 256megs of ram could be the problem...

I know mysql is not necessarily the best db to be running but its kinda industry standard...

Anybody know what type of traffic I should be able to push through that system?

Insert Value Here.
Comment
-=HOAX=-

Confirmed User

Join Date: Dec 2001

Posts: 4365
Share

Post
#4

07-18-2002, 10:37 AM

C'mon...help GFY maintain its one useful thread a day quota!

Insert Value Here.
Comment
DjSap

Confirmed User

Join Date: Jul 2002

Posts: 3869
Share

Post
#5

07-18-2002, 10:48 AM

well copy and paste line 4 otherwise its kinda hard...

Blog Themes, TGP Design, Writing Services, Grunt Work
ICQ: 66871495
Comment
pipp

Confirmed User

Join Date: Oct 2001

Posts: 1185
Share

Post
#6

07-18-2002, 10:51 AM

Switch to postresql handles complexity much bether then mysql. What kind off querys are you running that are causing this ?
Comment
JFPdude

Confirmed User

Join Date: Jan 2002

Posts: 4027
Share

Post
#7

07-18-2002, 10:55 AM

First how many concurrent connections does your mysql server allow ... I'm guessing this needs to be raised

second check the database for corruption .. that will also cause the error.

Need to see the line to be for sure but I would start at those 2 places.
Comment
Sysyphus

So Fucking Banned

Join Date: May 2002

Posts: 11
Share

Post
#8

07-18-2002, 11:03 AM

Put this:

set-variable = max_connections = some number

in your /etc/my.cnf file. Where some number = 1000 or 2000 or 3000, etc... See what works. Consider checking in your operating systems share/mysql directory (/usr/share/mysql, /usr/local/share/mysql) and look at the different sample configs you can use as your /etc/my.cnf. More memory usage = less disk usage = happy MySQL (In most cases anyway)

You'll have to restart MySQL for the changes to take effect.

Apparently the board didn't like my choice in braces...
Comment
FierceHost

Confirmed User

Join Date: Apr 2002

Posts: 424
Share

Post
#9

07-18-2002, 11:03 AM

login your shell and do a "free" command, post the 2nd line of what you see. This will tell you if its your ram, or not. also do a uptime command and post them results. you prob need to change your concurrent con variable. if your server load is too much, then you can't the only thing you can do is get a better server.

250$ 1000GB / Mo - 2000mb space - 10 domains - .26 per gig overage
<font color="#00FF00">ICQ 132871574</font>
Comment
vending_machine

Confirmed User

Join Date: Jun 2002

Posts: 1070
Share

Post
#10

07-18-2002, 11:07 AM

Originally posted by FierceHost
login your shell and do a "free" command, post the 2nd line of what you see. This will tell you if its your ram, or not. also do a uptime command and post them results. you prob need to change your concurrent con variable. if your server load is too much, then you can't the only thing you can do is get a better server.

The free command only works on select systems, FYI...
Comment
vending_machine

Confirmed User

Join Date: Jun 2002

Posts: 1070
Share

Post
#11

07-18-2002, 11:08 AM

Originally posted by pipp
Switch to postresql handles complexity much bether then mysql. What kind off querys are you running that are causing this ?

postgresql can handle more complex queries, yes, but it is by no means faster. It's not even half as fast as mysql.
Comment
vending_machine

Confirmed User

Join Date: Jun 2002

Posts: 1070
Share

Post
#12

07-18-2002, 11:09 AM

Originally posted by -=HOAX=-
Warning: Too many connections in mysqlfunc.inc.php on line 4

Warning: MySQL Connection Failed: Too many connections in mysqlfunc.inc.php on line 4
Chould not connect to MySQL

Are you using persistent connections? How many connections are open at the time when it fails?

If your queries aren't streamlined and optimized, upping the number of max connections isn't going to help you.
Comment
-=HOAX=-

Confirmed User

Join Date: Dec 2001

Posts: 4365
Share

Post
#13

07-18-2002, 11:24 AM

I'm using the defualt my.cnf specified in /usr/local/share/mysql/my-medium.cnf

As far as I see there is not set limit of max allow connections...I see max packet size.. but that's it...this is pretty much the default config and install of mysql...I'm using agp sql and epowertrader...switching is not an option its been done...its what I have to work with...

I'm concerned because I have two other boxes running same setups and the traffic to them is increasing...one is currently at about 16,000 unq's a day...and growing fast...but it seems much calmer.

A top command shows mysql using about 3-6% of the cpu on average...

Insert Value Here.
Comment
-=HOAX=-

Confirmed User

Join Date: Dec 2001

Posts: 4365
Share

Post
#14

07-18-2002, 11:24 AM

And the free command is not used in freebsd btw.

Insert Value Here.
Comment
SetTheWorldonFire

Confirmed User

Join Date: Feb 2002

Posts: 7444
Share

Post
#15

07-18-2002, 12:03 PM

You can have about 100 connections, I think that's the limit.

Make sure you close your connections, Once connected they can stay open for 8 hours.

http://www.mysql.com/doc/T/o/Too_many_connections.html

www.STWOFDesign.com
hit me up on icq 154206276 or Skype: JaimeGizzle
Comment
-=HOAX=-

Confirmed User

Join Date: Dec 2001

Posts: 4365
Share

Post
#16

07-18-2002, 12:30 PM

The info on that page seems to have helped immensly!

Insert Value Here.
Comment
Mr.Fiction

Confirmed User

Join Date: Feb 2002

Posts: 9484
Share

Post
#17

07-18-2002, 12:36 PM

Originally posted by SetTheWorldonFire
You can have about 100 connections, I think that's the limit.

Make sure you close your connections, Once connected they can stay open for 8 hours.

http://www.mysql.com/doc/T/o/Too_many_connections.html

You can have over 1000 MySQL connections. We've done it.

You just need to tune your my.cnf file to allow more connections. Make sure you have the CPU and memory to back it up.

Don't be lazy, protect free speech: ACLU | Free Speech Coalition | EFF | IMPA
Comment
-=HOAX=-

Confirmed User

Join Date: Dec 2001

Posts: 4365
Share

Post
#18

07-18-2002, 12:41 PM

Originally posted by Mr.Fiction

Make sure you have the CPU and memory to back it up.

I think that's my problem...

Insert Value Here.
Comment
foe

Confirmed User

Join Date: May 2002

Posts: 5246
Share

Post
#19

07-18-2002, 12:41 PM

Yeh basically edit your mysql conf file, I would recomend you set the maximum to 500 connections, most servers will be able to handle that
Comment
toddler

Confirmed User

Join Date: Jun 2002

Posts: 1911
Share

Post
#20

07-18-2002, 12:44 PM

mysql is significantly faster than post for reads. Will see if i can find my notes from when i did my last compare. If i recall though,
doing something small like a select against a table with 5000 entries, and doing an insert based on the result, was about 30%
faster than post.

http://www.flickr.com/photos/zoddler/
Comment

Previous template Next

Working...