php and freetds

[erezep]

I'm running a site balanced between 5 apache servers running on FC3,
apache 2.0.53,php 4.3.4,freetds 0.63.

I have this strange problem that sometimes, not even times of load, the
connections table at the sql server gets to a very high value (about
1000) my average is below 200.

I don't know how to solve this, but I know that if I restart the
process of all my apache servers, everything turns ok,

This happens at random times, sometimes 2 times a day, and sometimes
even 10.
Do you know what might be the problem?

Thanks In Advance.

Erez

[Jerry Stuckle]

er****@gmail.com wrote:

I'm running a site balanced between 5 apache servers running on FC3,
apache 2.0.53,php 4.3.4,freetds 0.63.

I have this strange problem that sometimes, not even times of load, the
connections table at the sql server gets to a very high value (about
1000) my average is below 200.

I don't know how to solve this, but I know that if I restart the
process of all my apache servers, everything turns ok,

This happens at random times, sometimes 2 times a day, and sometimes
even 10.
Do you know what might be the problem?

Thanks In Advance.

Erez

And your PHP question is?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[erezep]

i dont know, i thought it might be related to php, or some of the guys
here may know...
should i post somewhere else?

[Jerry Stuckle]

er****@gmail.com wrote:

i dont know, i thought it might be related to php, or some of the guys
here may know...
should i post somewhere else?

Well, perhaps you could start out by determining what the connections
are. Depending on what you have on your system, they could be PHP,
Apache, Unix or some batch program running.

We know even less about your system than you do. How should we be able
to help with your problem?

But since this is related to MySQL, I might recommend a MySQL newsgroup.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[erezep]

these are all connection to the ms-sql server, from the web server
serving with apache.
i dont know why at random times they go to such a high level

[Jerry Stuckle]

er****@gmail.com wrote:

these are all connection to the ms-sql server, from the web server
serving with apache.
i dont know why at random times they go to such a high level

But again - what is the source? Is it Apache? PHP? Something else?

You really need to do some diagnosis on the problem before someone else
can help you.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[erezep]

do you know of other program than freetds, i suspect it might be the
problem.....

[Jerry Stuckle]

er****@gmail.com wrote:

do you know of other program than freetds, i suspect it might be the
problem.....

I've heard about it, but never used it. If you think that's the
problem, you should follow up on their mailing list.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[Uber Geschlissen]

Jerry are you just a dickhead or do you have multiple personalities?

FreeTDS is used with PHP.

Duh!
Jerry Stuckle wrote:

er****@gmail.com wrote:

I'm running a site balanced between 5 apache servers running on FC3,
apache 2.0.53,php 4.3.4,freetds 0.63.

I have this strange problem that sometimes, not even times of load, the
connections table at the sql server gets to a very high value (about
1000) my average is below 200.

I don't know how to solve this, but I know that if I restart the
process of all my apache servers, everything turns ok,

This happens at random times, sometimes 2 times a day, and sometimes
even 10.
Do you know what might be the problem?

Thanks In Advance.

Erez

And your PHP question is?

[Uber Geschlissen]

er****@gmail.com wrote:

i dont know, i thought it might be related to php, or some of the guys
here may know...
should i post somewhere else?

FreeTDS has a connection pooling capability, check the docs at www.freetds.org

[Jerry Stuckle]

Uber Geschlissen wrote:

Jerry are you just a dickhead or do you have multiple personalities?

FreeTDS is used with PHP.

Duh!
Jerry Stuckle wrote:

er****@gmail.com wrote:

I'm running a site balanced between 5 apache servers running on FC3,
apache 2.0.53,php 4.3.4,freetds 0.63.

I have this strange problem that sometimes, not even times of load, the
connections table at the sql server gets to a very high value (about
1000) my average is below 200.

I don't know how to solve this, but I know that if I restart the
process of all my apache servers, everything turns ok,

This happens at random times, sometimes 2 times a day, and sometimes
even 10.
Do you know what might be the problem?

Thanks In Advance.

Erez

And your PHP question is?

Go to hell.

I just asked what his PHP question was. Sure FreeTDS is used with PHP.
So are MySQL, Oracle, ODBC, Apache, OSCommerce, PhpBBS and dozens of
other packages and tools. Does this mean any question on any of these
are "on topic"?

The fact here is - he has a problem. It's not at all clear this is
related to PHP. And if it is a FreeTDS problem, FreeTDS has its own
mailing list where he can get much better help from the experts. Ask in
the right place and you get better answers.

And don't top post.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[Uber Geschlissen]

F*** OFF AND DIE DICKHEAD

Who the f*** are you to pontificate and run people. Like you are
the moderator of the newsgroup? Ha! As if you had any power
you little twit. And to even suggest somebody not top-post, is
this the domain of pubescent little children who obsess over
the rules that they make up. I imagine you have all kinds of
little rules for sh** that doesn't matter. Whiner.

STFU and crawl back into your little hole.

People don't need to be pushed away that are asking for help. Smart
people that have answers think outside the box, obviously you want
to stay inside yours because you can't.
Jerry Stuckle wrote:

Uber Geschlissen wrote:

Jerry are you just a dickhead or do you have multiple personalities?

FreeTDS is used with PHP.

Duh!
Jerry Stuckle wrote:

er****@gmail.com wrote:

I'm running a site balanced between 5 apache servers running on FC3,
apache 2.0.53,php 4.3.4,freetds 0.63.

I have this strange problem that sometimes, not even times of load, the
connections table at the sql server gets to a very high value (about
1000) my average is below 200.

I don't know how to solve this, but I know that if I restart the
process of all my apache servers, everything turns ok,

This happens at random times, sometimes 2 times a day, and sometimes
even 10.
Do you know what might be the problem?

Thanks In Advance.

Erez
And your PHP question is?

Go to hell.

I just asked what his PHP question was. Sure FreeTDS is used with PHP.
So are MySQL, Oracle, ODBC, Apache, OSCommerce, PhpBBS and dozens of
other packages and tools. Does this mean any question on any of these
are "on topic"?

The fact here is - he has a problem. It's not at all clear this is
related to PHP. And if it is a FreeTDS problem, FreeTDS has its own
mailing list where he can get much better help from the experts. Ask in
the right place and you get better answers.

And don't top post.

[Jerry Stuckle]

Uber Geschlissen wrote:

F*** OFF AND DIE DICKHEAD

Who the f*** are you to pontificate and run people. Like you are
the moderator of the newsgroup? Ha! As if you had any power
you little twit. And to even suggest somebody not top-post, is
this the domain of pubescent little children who obsess over
the rules that they make up. I imagine you have all kinds of
little rules for sh** that doesn't matter. Whiner.

STFU and crawl back into your little hole.

People don't need to be pushed away that are asking for help. Smart
people that have answers think outside the box, obviously you want
to stay inside yours because you can't.

And you're stupid. You don't even have the brains to follow newsgroup
conventions - which in this case is NOT top posting, asshole.

You're the dickhead who started this. I was trying to steer Erez to the
place where he could get some *real* help.

You haven't even tried that, you stupid moron. No, you just break into
the middle of a conversation where you're not wanted, attack me because
I didn't help Erez to *your* satisfaction. (I have yet to see *you*
contribute anything to help him solve his problem!).

Fucking moron.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[erezep]

Jerry Stuckle wrote:

Uber Geschlissen wrote:

F*** OFF AND DIE DICKHEAD

Who the f*** are you to pontificate and run people. Like you are
the moderator of the newsgroup? Ha! As if you had any power
you little twit. And to even suggest somebody not top-post, is
this the domain of pubescent little children who obsess over
the rules that they make up. I imagine you have all kinds of
little rules for sh** that doesn't matter. Whiner.

STFU and crawl back into your little hole.

People don't need to be pushed away that are asking for help. Smart
people that have answers think outside the box, obviously you want
to stay inside yours because you can't.

And you're stupid. You don't even have the brains to follow newsgroup
conventions - which in this case is NOT top posting, asshole.

You're the dickhead who started this. I was trying to steer Erez to the
place where he could get some *real* help.

You haven't even tried that, you stupid moron. No, you just break into
the middle of a conversation where you're not wanted, attack me because
I didn't help Erez to *your* satisfaction. (I have yet to see *you*
contribute anything to help him solve his problem!).

Fucking moron.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.

js*******@attglobal.net

guys i just need some help for a problem that's realy disturbing me
there's no need to fight ==================

[Jerry Stuckle]

er****@gmail.com wrote:

Jerry Stuckle wrote:

Uber Geschlissen wrote:

F*** OFF AND DIE DICKHEAD

Who the f*** are you to pontificate and run people. Like you are
the moderator of the newsgroup? Ha! As if you had any power
you little twit. And to even suggest somebody not top-post, is
this the domain of pubescent little children who obsess over
the rules that they make up. I imagine you have all kinds of
little rules for sh** that doesn't matter. Whiner.

STFU and crawl back into your little hole.

People don't need to be pushed away that are asking for help. Smart
people that have answers think outside the box, obviously you want
to stay inside yours because you can't.

And you're stupid. You don't even have the brains to follow newsgroup
conventions - which in this case is NOT top posting, asshole.

You're the dickhead who started this. I was trying to steer Erez to the
place where he could get some *real* help.

You haven't even tried that, you stupid moron. No, you just break into
the middle of a conversation where you're not wanted, attack me because
I didn't help Erez to *your* satisfaction. (I have yet to see *you*
contribute anything to help him solve his problem!).

Fucking moron.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.

js*******@attglobal.net

guys i just need some help for a problem that's realy disturbing me
there's no need to fight

==================

Sorry, I just let this idiot get a little under my skin.

You still need to do some troubleshooting. Your problem could be caused
by a lot of different things.

However, since the problem is MySQL connections, I'd suggest you start
troubleshooting with MySQL - check one of the MySQL newsgroups for help.
And if you think the problem is freetds, try the freetds mailing lists.

But there's nothing here indicating a PHP problem - and you'll get a lot
more help in more specific newsgroups.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================